mORMot Open Source

daisutao

Member

Registered: 2015-05-08

Posts: 17

Is mORMot support iSeries Access ODBC Driver?

I want to connect AS400 use SynDBExplorer by ODBC, but not success.

the follow is my set, what's wrong ?
Server = "Driver=iSeries Access ODBC Driver;System=192.168.121.40;DefaultLibraries=MEKBLIB2;Uid=mz6;Pwd=mz6"

Last edited by daisutao (2015-05-29 03:28:50)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Is mORMot support iSeries Access ODBC Driver?

Take a look at TODBCConnectionProperties.Create() help.

The connection string should be in aDatabaseName, and aServerName should be ''.

daisutao

Member

Registered: 2015-05-08

Posts: 17

Re: Is mORMot support iSeries Access ODBC Driver?

I change the setting:

Database = "Driver=iSeries Access ODBC Driver;System=192.168.121.40;DefaultLibraries=MEKBLIB2;Uid=mz6;Pwd=mz6"
Server = ""

but i got an excption:
TODBCConnection.Connect: unrecognized provider
DBMSName=DB2/400 SQL
DriverName=CWBODBC.DLL
DBMSVersion=05.04.0014

view source, only support follow DB?
DBMS_NAMES: array[0..7] of PAnsiChar = (
    'ORACLE','MICROSOFT SQL','ACCESS','MYSQL','SQLITE','FIREBIRD','INTERBASE','POSTGRE');

Last edited by daisutao (2015-05-29 08:29:04)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Is mORMot support iSeries Access ODBC Driver?

No, it is at DriverName level...

Please try http://synopse.info/fossil/info/bb84e99138

daisutao

Member

Registered: 2015-05-08

Posts: 17

Re: Is mORMot support iSeries Access ODBC Driver?

thank you! i will try it at next week.

now it work ok!.  thank again.

Last edited by daisutao (2015-06-01 01:16:34)