[python-win32] python.exe crashes while connecting to the MSSQLDatabase on remote machine using pyodbc module

[Michel Claveau]

Hi!

Several solution are given.
Another (example) :

    import win32com.client
    from win32com.client import Dispatch
    connexion = Dispatch('ADODB.Connection')
    connexion.ConnectionString = "Provider=SQLOLEDB.1; Data 
Source=192.168.10.10; uid=username; pwd=password; database=baseSQLdata"
    connexion.Open()
    if connexion.State == 1:
        print "connected."
        recordset = Dispatch('ADODB.RecordSet')
        recordset.ActiveConnection = connexion
        recordset.Open("tablexample")
        while not recordset.EOF:
            print recordset.Fields.Item("mail").Value, 
recordset.Fields(2).Value
        recordset.Close()
        recordset = None
        connexion.Close()
        connexion = None


@-salutations
-- 
Michel Claveau