ODBC access to AS400 DB2

tentacle

Hi,


I am tryin to get an ODBC connection to a AS400(iseries) DB2 database. I have an example codeunit for a connection to an access DB with a connection string like:
StrConnString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp.mdb;Persist Security Info=False ';

In my system-dsn i created an entry with an "iseries access odbc driver" and I can use Excel to read from the database on the iseries.

But I do not manage to read from that database in NAV. I even do not know hoe to create the correct connection string because I do not know the "provider".

Anyone who can give some hints how to start?

Regards

chrido

simple way to get the connection string (for any database)

1.) Right click on your desktop and create a file mystring.udl
2.) double click on the file
3.) edit your preferences and close it
4.) open mystring.udl in your favourite texteditor and extract the connection string

greetings, chris

tentacle

Thanks a lot!!!! Its working