Das deutsche Python-Forum

Code: Alles auswählen

import dbi 
import odbc 

myconn = odbc.odbc('DB_Modell_mit_Daten.mdb') 
mycursor = myconn.cursor() 
mycursor.execute('SELECT * FROM T_DATEN') 
mydata = mycursor.fetchall() 
print mydata[0]
mycursor.close() 
myconn.close() 
print mydata[1]

Code: Alles auswählen

import dbi, odbc

def dump(TabellenName):
    mycursor = myconn.cursor()
    mycursor.execute('SELECT * FROM '+TabellenName)
    mydata = mycursor.fetchall()

    for i in range( len(mydata) ):
        print i,mydata[i]

    mycursor.close()


myconn = odbc.odbc('DatenBankName')

dump("Index")

myconn.close()

Code: Alles auswählen

import win32com.client

conn = win32com.client.Dispatch(r'ADODB.Connection')
#DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:/DB.mde;
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=//PC1/c$/WINDOWS/system32/ias/dnary.mdb;'
conn.Open(DSN)

rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs.Open('SELECT * FROM Attributes', conn, 1, 3)

flds_dict = {}
for x in range(rs.Fields.Count):
    flds_dict[x] = rs.Fields.Item(x).Name   # Die Spaltenueberchriften werden ausgelesen
    print flds_dict[x]
    print rs.Fields.Item(x).Type             # Feldtyp 202 ist ein Textfeld. 3 inst ein Integerfeld
    print rs.Fields.Item(x).DefinedSize     # Groesse des Spaltenfeldes. in Access hatten wir fuer Text 50
    print '','','',
    x = rs.Fields.Item(x).Value               # Feldwerte
    print x

Code: Alles auswählen

odbc.odbc('DRIVER=Microsoft Access-Treiber (*.mdb);UID=admin;DBQ=PFAD_ZUR_MDBDATEI')

Code: Alles auswählen

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

Code: Alles auswählen

[ODBC]
DRIVER=SQL Server
UID=UserName
Network=DBMSSOCN
WSID=VMWARE
APP=Microsoft Data Access Components
SERVER=.\SQLEXPRESS

Code: Alles auswählen

import dbi, odbc

dbconf = {
    "dbHost"            : '.\SQLEXPRESS',
    "dbDatabaseName"    : 'DatabaseName',
    "dbUserName"        : 'UserName',
    "dbPassword"        : 'Password',
    "dbTablePrefix"     : 'lucid_',
}

DSN_info = (
    "DRIVER={SQL Server};SERVER={%s};"
    "UID=%s;PASSWORD=%s;DATABASE=%s"
) % (
	dbconf["dbHost"],
	dbconf["dbUserName"],
	dbconf["dbPassword"],
	dbconf["dbDatabaseName"]
)
print DSN_info

c = odbc.odbc(DSN_info)

Code: Alles auswählen

Traceback (most recent call last):
  File "test.py", line 6, in ?
    c = dbapi.connect('.\SQLEXPRESS', 'UserName', 'Password')
  File "C:\Python24\Lib\site-packages\pymssql.py", line 309, in connect
    con = _mssql.connect(dbhost, dbuser, dbpasswd)
_mssql.error: Could not connect to MS SQL Server