General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Excel VBA to access the FoxPro free table thought out byODBC
I am using the excel VBA to access the FoxPro free table thought out by the ODBC32. in that case the FoxPro free table is store in the server and share with my staff.
when i want to search the record in the free table. and run at
Set rstTemp = conMain.OpenRecordset(sSQL, dbOpenDynamic)
the VBA will be returne error message is that
"execution cancelled 3669"
my opendatabase and openconnection statement is that:
Set wrkMain = CreateWorkspace("hdfandtxf;", "Admin", "", dbUseODBC)
Set conMain = wrkMain.OpenDatabase("hdfandtxf", False, , "ODBC;DATABASE=hdfandtxf;UID=Admin;PWD=;DSN=hdfandtxf;[logintimeout=0];")
wrkMain.LoginTimeout = 0
' Set conMain = wrkMain.OpenConnection("hdfandtxf", dbDriverNoPrompt, true, "ODBC;DATABASE=hdfandtxf;UID=Admin;PWD=;DSN=hdfandtxf;[logintimeout=0];")
please help me ^_^
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only