Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 16-bit odbc to sql server problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-08 : 09:10:53
Mike writes "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 gets "Stored Procedure" "not found"

I have tried using "dbmssoc3" and even "dbnmp3" as network libraries, but that did not help.

Access 2.0 passthrough does seem to work.

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.

Upgrading from VB3 is not an option at this time.

Help!"

macka
Posting Yak Master

162 Posts

Posted - 2002-08-09 : 04:51:00
Take a look at my reply on your other post.

macka.


Go to Top of Page
   

- Advertisement -