I am trying to access Sql Server 6.5 and 7.0 using 16-bit ODBC (vb 3.0). The program uses two methods to execute stored procedures...
DB_SQLPASSTHROUGH - gets "invalid argument"
SQLPREPARE --> SQLEXECUTE get "Stored Procedure" "not found"
I have tried using "dbmssoc3" and even "dbnmp3" as network libraries, but that did not help.
I expect that I have something wrong with my ODBC setup.
Any ideas? I have searched the web, but cannot find much help. Maybe an install of the latest version of 16-bit ODBC might help, but I cannot find it. I did install Access 2.0 attempting to get a more current 16-bit ODBC.
Help!
DB_SQLPASSTHROUGH - gets "invalid argument"
SQLPREPARE --> SQLEXECUTE get "Stored Procedure" "not found"
I have tried using "dbmssoc3" and even "dbnmp3" as network libraries, but that did not help.
I expect that I have something wrong with my ODBC setup.
Any ideas? I have searched the web, but cannot find much help. Maybe an install of the latest version of 16-bit ODBC might help, but I cannot find it. I did install Access 2.0 attempting to get a more current 16-bit ODBC.
Help!