ACCESSING SQL DATABASE THRU TP
when i am running the following script for accessing data from sql table error occured at workspace "user defined type not defined".what are all options to be enable in tools>reference.
Dim wrkodbc As Workspace
Dim conpubs As Connection
Dim rs As Recordset
Set wrkodbc = createWorkspace("NewODBCworkspace", "admin", "", dbuseODBC)
Set conpubs = wrkodbc.Openconnection("connection1", , , "ODBC;DATABASE=master database;uid=sa;pwd=sa;dsn=bbb")
Set rs = conpubs.OpenRecordset("select * from emp", dbopendynaset, False)
MsgBox "connected successfully"
While rs.EOF <> True
Name = rs(0)
ID = rs(1)
Re: ACCESSING SQL DATABASE THRU TP
Not sure what the problem is, what line os the error occuring on.
Also refer to the message I posted in "SQL IN TP" which shows an example using ADO, this may be better for you in the long run.