Opening a SqlClient.Connection object fails
![](https://secure.gravatar.com/avatar/d2c7a35e3b6624e2fd5a25a113dbb304.jpg?s=120&d=mm&r=g)
Hi, Has anyone successfully opened a connection to SQL Server 2000 using PythonNet and the SqlClient.Connection object? Here's some code I have: import CLR import CLR.System import CLR.System.Data import CLR.System.Data.SqlClient connectionString = u"Driver={SQL Server};Server=(local);Database=Enterprise;Trusted_Connection=yes;" conn = CLR.System.Data.SqlClient.SqlConnection() conn.ConnectionString = connectionString conn.Open() conn.Close() The error I get is: Traceback (most recent call last): File "C:\tmp\testcon.py", line 10, in ? conn.ConnectionString = connectionString TypeError: Exception has been thrown by the target of an invocation. Ideas anyone? Felix. _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
participants (1)
-
Felix McAllister