[Python.NET] Opening a SqlClient.Connection object fails

Felix McAllister felix_mcallister at hotmail.com
Mon Nov 3 11:41:32 EST 2003


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




More information about the PythonDotNet mailing list