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
