p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ADO.NET (http://p2p.wrox.com/forumdisplay.php?f=109)
-   -   Driver's SQLSetConnectAttr failed (http://p2p.wrox.com/showthread.php?t=7806)

saulodet January 2nd, 2004 05:10 PM

Driver's SQLSetConnectAttr failed
 
Hi

I'm trying to connect to SyBase 12.5 using ODBC, in this case I need to use two connections and I have a string with this value:

    string myODBC = "DSN=myodbc;Uid=myuser;pwd=mypass"

And I use it, to establish both connections

When I connect for the first time there is no problem, but when I try the second time I get an exception:

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

What's wrong??
J.C.




Deepesh_Jain January 3rd, 2004 01:18 AM

May be you are using the same variable to reconnect and you are not closing the connection for the first time.

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

saulodet January 5th, 2004 01:28 PM

Thanks Deepesh Jain



All times are GMT -4. The time now is 04:18 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.