I have to change connection of my Webware application from MySQL to
MSSQL2K. I am using DBPool module.
For MySQL I use:

import MySQLdb
datapool[dbName] = DBPool(MySQLdb, 5, host='localhost', user='user',
  passwd='pass', db=dbName, compress=0, cursorclass=MySQLdb.cursors.DictCursor)

For odbc I tried to use:

import odbc
datapool[dbName] = DBPool(odbc, 5, dsn='myDSN')

but it does not work. :(

And another question. Is there a possibility for odbc to accessing
database results by fields? I cannot find good documentation for odbc
module. The only web page I found is very short. :(

What is the correct syntax for MiscUtils.DBPool and odbc?

-- 
JZ



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss

Reply via email to