On Mon, 2004-04-26 at 04:20, Dossy wrote: > On 2004.04.26, Tom Jackson <[EMAIL PROTECTED]> wrote: > > A few months back I made a few changes to the nssolid module and called > > it, temporarily nsunixodbc. > > Strangely, I was intrigued by your comment that "nsodbc can't use the > UnixODBC driver manager" so I gave it a whack on Linux, and found that > the changes needed to make nsodbc work with nsunixodbc were minimal. > > I documented my efforts on the wiki: > > http://panoptic.com/wiki/aolserver/nsodbc > > The patch to nsodbc is available as a link from that wiki page. Once I > do some more testing, I'll commit the changes to CVS. I'm hoping the > changes that I made can work towards eliminating the need for a separate > nsunixodbc driver. > > > I started playing around with this again last week and noticed that you > > cannot issue transactions over odbc via sql commands. You have to signal > > the start of a transaction by changing a connection parameter. > > > > Since this isn't supported in the ns_db api, I added them to the ns_odbc > > command: > > ns_odbc begintransaction $dbHandle > > ns_odbc committransaction $dbHandle > > ns_odbc rollbacktransaction $dbHandle > > Here's a handy page describing transactions in ODBC: > > http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/6_050_1.htm > > Basically, in order to get "transactions" under ODBC you call > SQLSetConnectAttr and turn autocommit off. Then, you need to explicitly > commit or rollback using SQLEndTran with SQL_COMMIT or SQL_ROLLBACK. Is > that what the 3 commands you implemented essentially do?
Yes, so simple I never break out of the ns_odbc command. > > The module is at http://zmbh.com/nsunixodbc/nu.tgz and compiles as > > nu.so, so there is no confusion, and until an accepted name can be > > chosen for the module. I have a gratuitous copy of XP now, so maybe I > > can see if it compiles on win. > > Please do me a favor and test nsodbc after applying my patch and see if > it works with UnixODBC on your system. If so, I'll commit the patch and > implement the transaction-handling commands for ns_odbc, then we can > live with one AOLserver ODBC driver module again. > Dossy, do me a favor and give me some advice on what is needed for the module I am working on to compile under win. The code in the module you are working with isn't being worked on by anyone else and is more out of date than the nsunixodbc module. tom jackson -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
