J
J
I wish to connect to a database to do an SQL delete
command.
Works ok in straight access.
The table was migrated to sql server and I wish to do the
same operation.
Connection comes up with a 3146 ODBC call failed error
when I try to connect automatically.
Connection works fine when I connect manually using the
dbDriverprompt parameter.
I have cut and pasted the parameters from the manual
connection in to the auto connection but still get the
same error. anyone any ideas?
Set wrkODBC = CreateWorkspace("EFACS", "sa", "exelexel",
dbUseODBC) ' no errors given
Params = "ODBC;DRIVER=SQL
Server;SERVER=EFACSSERVER;UID=sa;PWD=exelexel;APP=Microsoft
Open Database Connectivity;WSID=IT-2;DATABASE=whatifdb"
Set conefacs = wrkODBC.OpenConnection("CON_1",
dbDriverComplete, False, Params)
' gives 3146 run time error
command.
Works ok in straight access.
The table was migrated to sql server and I wish to do the
same operation.
Connection comes up with a 3146 ODBC call failed error
when I try to connect automatically.
Connection works fine when I connect manually using the
dbDriverprompt parameter.
I have cut and pasted the parameters from the manual
connection in to the auto connection but still get the
same error. anyone any ideas?
Set wrkODBC = CreateWorkspace("EFACS", "sa", "exelexel",
dbUseODBC) ' no errors given
Params = "ODBC;DRIVER=SQL
Server;SERVER=EFACSSERVER;UID=sa;PWD=exelexel;APP=Microsoft
Open Database Connectivity;WSID=IT-2;DATABASE=whatifdb"
Set conefacs = wrkODBC.OpenConnection("CON_1",
dbDriverComplete, False, Params)
' gives 3146 run time error