Error with Todbc in FW0902

[PeterHarmes]

Hi,

I've upgraded my xHarbour & FW and i'm getting the following error message when i'm trying to make a connection to a Sage table using oOdbc := TOdbc():New(cDsn, cName, cPass)

AutoCommit could not be set from TOdbc:New()

This worked on the previous version i used (FW0712)

Any ideas?

Thanks In Advance

Pete

[Antonio Linares]

Pete,

We have not modified that method since version 7.04.

Is your previous 7.12 based EXE working fine with the same ODBC connection ?

[PeterHarmes]

I've just noticed that theres no changes. yes, the previous 712 version worked fine - i've also upgraded my xHarbour enterprise version to April 09 so i don't know if theres a conflict there?

[PeterHarmes]

Anyone else having problems? especially if you've rebuilt the FW lib using xHarbour enterprise?

I can confirm that Todbc works with FW9.01 & xHarbour enterprise Dec 08

Any ideas?

Pete

[Antonio Linares]

Pete,

It seems as the lines that fail are:

Code: Select all  Expand view

   if ( nRet := SqlSetConnectOption( ::hDbc, SQL_AUTOCOMMIT, AUTOCOMMIT_ON ) ) != SQL_SUCCESS
      ::NewError("AutoCommit could not be set from TOdbc:New()",,, nRet)
   endif
 

What value do you get for nRet ?

[PeterHarmes]

I get 1274675200 !!!!!

Pete

[PeterHarmes]

Just an update on this..

I have just tested the code using 09.05 and it is working fine. I think the problem was due to having to rebuild the FiveWin libraries with the xHarbour builder.

Pete

[Antonio Linares]

Pete,

Gald to know it is working fine again