SQL2000 database vs python, using mssqldb

[Greg Fortune]

It appears you are using the api correctly assuming mssqldb provides the
Python v2.0 db api.  You can find that document at
http://python.org/peps/pep-0249.html  You'll have to check the mssqldb
packages for specific documentation about any changes/limitations in that
module.

Greg Fortune
Fortune Solutions


Raaijmakers, Vincent (IndSys, GE Interlogix) wrote:

> First of all, thanks for all the help guys!
> 
> Until now, lots of install problems on all the recommended
> packages/modules.
> 
> For now, my best option was to make use of my existing Pyro framework
> (thanks Irmen!) I already build a MSSQL (Pyro/server)service on the
> windows box using mssqldb. My linux app will talk to this service.
> This at least has been installed successful and my service can already
> connect to the database.
> 
> So far so good: Now, I can't find the API of MSSQL. Not on the website nor
> in the installed folders. So, I tried to use the examples and only the
> connections seems successful. When I try a select on a table, it tells me
> that the table name is an invalid object name.
> 
> Just tried a kind of a hello world example...
> 
> import mssqldb
> import MSSQL
> db = MSSQL.connect('my_db_server', 'user', 'password', 'my_database')
> ## so far, so good
> 
> c = db.cursor()
> c.execute('select * from my_table')
> ## boom, error
> 
> c.fetchall()
> c.nextset()
> 
> The ms sql enterprise manager shows me that the database and table is
> there. Unfortunately, in python the error tells me: Invalid object name
> 'my_table'
> 
> Anyone with experience?
> Where are the API's?
> 
> Vincent