FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Error with Todbc in FW0902
Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
Error with Todbc in FW0902
Posted: Thu May 07, 2009 09:23 AM

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

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Error with Todbc in FW0902
Posted: Thu May 07, 2009 09:51 AM

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 ?

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
Re: Error with Todbc in FW0902
Posted: Thu May 07, 2009 09:57 AM

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?

Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
Re: Error with Todbc in FW0902
Posted: Fri May 08, 2009 02:37 PM

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

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Error with Todbc in FW0902
Posted: Fri May 08, 2009 08:58 PM
Pete,

It seems as the lines that fail are:
Code (fw): Select all Collapse
   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 ?
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
Re: Error with Todbc in FW0902
Posted: Mon May 11, 2009 09:22 AM

I get 1274675200 !!!!!

Pete

Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
Re: Error with Todbc in FW0902
Posted: Wed Jun 10, 2009 09:14 AM

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

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Error with Todbc in FW0902
Posted: Wed Jun 10, 2009 11:47 AM

Pete,

Gald to know it is working fine again :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com

Continue the discussion