ODBC for Access and PB 8.0

[B2BGURU]

I've migrated a 6.5 application up to PB 8.0 and also moved a 97 access database up to office for XP (Access 2000). When I try to run the application from the PB environment I receive the following error when trying to connect to the db. "DB transaction not found. Call setrans or settransobject function". I'm not issuing a retrieve just a connect. Also - if I put the old compiled version (6.51) on the same box with the same database and run it - it connects with no problem. Something with the ODBC driver and PB 8.0 that's giving the issue. Any Clues woudl be appreciated!

PS - The ODBC setup has been done correctly based on the old version connecting.

 

[egodette]

I am using a MS 2000 database and I connect with no problem.

Here is my code...

SetPointer(HourGlass!)

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=comp;UID=dba;PWD=sql'"

connect using sqlca;

if sqlca.sqlcode = 0 THEN
open(w_main)
else
messagebox("Compliance","Could not connect to the Compliance database&quot
halt
end if

In ODBC on the machine I set up a DSN pointing to the database.