Delphi2009 Data Explorer CA400 Add New Connection

[keenanbr]

Can anyone help me with this?

I am trying to add a new AS400 connection.

I have edited dbxdrivers.ini thus;

[CA400]
GetDriverFunc=getSQLDriverCA400
LibraryName=dbexpca400.dll
VendorLib=cwbdb.dll
Database=MYAS400
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

I can connect via IBM Client Access.

How do I setup a new connection in Data Explorer?

I have tried but keep getting

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

I have tried setting
AutoCommit=False
but get the same error.

I have never setup an AS400 connection and think I am making some basic error. Any help would be greatly appreciated.

Regards,

 

[whosrdaddy]

I never used dbexpress.
Give ODBC in combination with dbGo (ADO) a shot.

/Daddy

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

 

[whosrdaddy]

and no need to create a second thread for the same problem...

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

 

[keenanbr]

I can connect via dbgo and BDE but really need to connect via DBexpress.

 

[DjangMan]

I Googled the error message and the driver's dll name and found these links:

http://cc.codegear.com/partners/delphi8/peter_sawatzki/dbexpca400/index.html

http://support.microsoft.com/kb/286464

What if you leave that line out of the .ini file?

 

[keenanbr]

Thanks, but I already saw those.

 

[keenanbr]

Never got this to work. Had to use ADO which works fine. Would love to know if anyone has got dbexpress driver to work.