Monday, October 29, 2012

Database setup

Good Morning
First i made an odbc connect liek this:
 
---------------------------------------------------------
import pyodbc
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=MAURITIUS;DATABASE=baan5c;UID=***;PWD=*****')
cursor = cnxn.cursor()
cursor.execute("SELECT x.t_name, y.t_mail FROM tttaad200000 as x, tttcmf200000 as y WHERE (x.t_name = y.t_name) AND (x.t_user = 'muster')")
row = cursor.fetchall()
if row:
 print row
--------------------------------------------------------
This gave me out the correct data (name + e-mail) from a user.
I tryed now to use this database in the Admin site, but i'm to stupid to implements this correct into the Database Setup.
The server is not on my computer, it is in the same LAN
 
Can someone help me please?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/a8cnBtTu1RYJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment