As400 DbExpress Connection

[keenanbr]

I'm trying to use DBExpress to connect to AS400. I have added the following to 'dbxdrivers.ini'

[CA400]
GetDriverFunc=getSQLDriverCA400
LibraryName=dbexpca400.dll
VendorLib=cwbdb.dll
Database=10.70.65.68
User_Name=
Password=
ServerCharSet=
ErrorResourceFile=
LocaleCode=0000
BlobSize=-1
RowsetSize=-1
RoleName=
CA400 TransIsolation=DirtyRead
CommitRetain=True
AutoCommit=True
Custom String=/trace=0
Connection Timeout=-1
Trim Char=False

[CA400 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

When I add a new connection in 'Data Explored' and 'Test Connection' I get

Borland.Data.TDBXError: cwbDB_SetAutoCommit returned error code 1.

I can connect using Client Access and by using a .udl.

Any help appreciated

 

[whosrdaddy]

try with flag AutoCommit=false

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[keenanbr]

i tried that