help - inserting values into database tables
python at chajadan.net
Tue Feb 19 09:16:09 CET 2002
It seems I have ISDN on the brain, because I changed the correct "DNS" to
the incorrect "DSN" partway through and never went back ;)
At 09:57 PM 2/18/02 -0800, you wrote:
>Hi Joe =)
>Your problem shouldn't be too hard to fix.
>Using odbc, you can't open the database file directly like that, since
>odbc supports so many different database standards, it needs to know which one.
>This requires a DNS. In order to set up a DNS for MS Access, just go to
>your control panel, and you should have an option called "OBDC
>Datasources" or similar. Click that, and it will show you your current
>DSNs. There are several types of DSNs, but you will want to make this file
>a System DSN, so click that tab. Select New, and choose the correct
>database driver, in this case MS Access. Then you have to name the DSN,
>anything you'd like (avoid spaces), chose a login/password or leave that
>blank, and finally show it the database file this whole DSN should be
>Then, you can odbc.odbc("myDsnName")
>Let me know if you have any other questions and I'll try to help. I work
>on Win98, so some of what I described may look slightly different under
>XP, but it should be there.
>At 06:35 PM 2/18/02 -0600, you wrote:
>>Just wondering if you can help?
>>I installed the python ver 2.0(from CD)for windowsX on a windows98
>>system. Then I installed the windows32all stuff.
>>So are the dbi and the odbc modules should now be installed
>>on my system now, or do I need some other package ??????
>>It seems I can import the dbi then the odbc with no errors...
>>But my simple script below won't run; has an error that I
>>don't understand ???????
>>I am running from the command line, heres my environ stuff
>>******* Do I need to put in another path to Lib ?????
>>******** Heres the error I get upon running from prompt
>>Traceback (most recent call last):
>> File "conntest.py", line 8, in ?
>> conn = odbc.odbc("c:\\codepy\\Manufacturers.mdb")
>>dbi.operation-error: [Microsoft][ODBC Driver Manager] Data source name not
>>found and no default driver specified in LOGIN
>>The Manufacturers.mdb is the ms-access database of ver office XP
>>2002. It is just a small database with a small table in it.
>>Very simple kind. The file is in that codepy directory also.
>>So I don't understand ?????????????????
>>What is DSN, does it allow for a ms-access file??????????
>>Well anyways heres my test database connection script, I am
>>just trying to connect and print some output from the database.
>>I think I am doing this correct but not sure ??????????
>>The script: conntest.py listing
>>#! /usr/bin/env python #not needed for windowspython
>>#test script to connect to a ms-access database
>>conn = odbc.odbc("c:\\codepy\\Manufacturers.mdb")
>>rs = conn.cursor()
>>rs.execute("select * from ManufName")
>>Can you shine any light my way ???????????
>>Thank you (working on a windows system today(UGH...)),
>>----- Original Message -----
>>From: chajadan <python at chajadan.net>
>>Sent: Monday, February 18, 2002 2:34 PM
>>Subject: Re: help - inserting values into database tables
>> > I always use PythonWin, part of the win32all distribution. It's a
>> > color-coded ide, with a basic syntax check, and has one nifty advantage
>> > over any other input editor I've tried: when you call a function, it takes
>> > the document strings and actually gives you a little note about what kind
>> > of input it's expecting!
>> > So all in all it should be the same thing as it ever was, but now in the
>> > environment your particular task seems to ask for. The only "new" things
>> > will be the other possible windows-only features you might want to learn
>> > and use in your time on windows.
>> > Happy computing!
>> > --chajadan
>> > At 08:15 AM 2/18/02 -0600, mylinuxboxroot wrote:
>> > >Hey thanks,
>> > >This is great, and I have the project now that it will be developed on a
>> > >windows
>> > >server so I guess I don't need to worry about going from linux to the
>> > >MS-Access
>> > >database. I will develop it right on the server using the win32all
>> > >distribution that
More information about the Python-list