On Tue, 2011-08-30 at 14:08 -0700, John Fabiani wrote: > Hi, > I have a little time available and I thought I would look into using pyodbc > with Dabo.
John, If I haven't mentioned it before it might be worth you looking at http://hg.backslashat.org/repos/dabo-odbc/ which is contains a set of patchs to an ancient dabo to do this. > The first issue is the connection string. The pyodbc does NOT > follow the "host", "user", etc. that we have been using for the connection. > For example to connect to an MS SQL database on windows you would use > something like: > DRIVER={SQL Server};SERVER=cloak;DATABASE=test;UID=user;PWD=password > > And of course the connection string would be different for other platforms > and > database engines. At first I thought I would just change CxnEditor to deal That's what I did locally and added a driver and dsn attribute. It was good enough for what I needed so I haven't mantained it. But it would probably help you in the right direction. The important patches are :- http://hg.backslashat.org/repos/dabo-odbc/rev/af94151ed49a http://hg.backslashat.org/repos/dabo-odbc/graph/aeb4a75ba49f and http://hg.backslashat.org/repos/dabo-odbc/rev/eb192fd4cd54 But you could just the db/dbOdbc.py from the last one and hack from there. -- Roger Gammans <[email protected]> --- StripMime Report -- processed MIME parts --- multipart/signed text/plain (text body -- kept) application/pgp-signature --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/1314742033.3879.186.camel@localhost
