Networks

Ask something
Discussion Locked

sql dmo

0 helpful
3 replies

by katanabk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have created an application that uses the sqldmo library to access sql7/2000 servers on a network. after installing it on a client machine that does not have sql server or msde, the program runs but only picks up sql7 servers and when trying to log on to a server gives the message "[Microsoft][ODBC SQL Server Driver]invalid attribute/option identifier".
i have included all the files listed in msdn & the mdac files i need. i have also added a udl to the client and this only picks up sql7 servers too although it does connect. I used INNO SETUP to create the setup.exe. Please help!!!

3 replies

by joseph moore

I found a nice SQL Server discussion forum that was talking about this exact same error. Here is one of the post:

"The best way to overcome this issues is to replace couple of .dll files under OS system path i.e, replace the following files with good copies from the CD or SP - odbcbcp.dll and sqlsrv32.dll located in winnt\system32"

The discussion is here:
http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=3541
(please remove any spaces)

hope this helps

by katanabk

Thanks for your help. I'd already added the odbcbcp.dll but not the sqlsrv32.dll. I also found an article in msdn titled "SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000" which is not the problem but the solution to this is to use Odbcbcp.dll, Sqlsrv32.dll and Sqlsrv32.rll files dated 02/15/01 or later. These files on the sql 2000 disc are dated 08/06/2000 (mdy) so these will not fix the problem. So, iv'e now added these files dated 04/11/01 (mdy) andmy problem is fixed.

This discussion is closed to new replies.