CreateDSN function

[Mart]

Can anyone help with this....?

I'm using a IBM DB2 database. I have the server name, db
name etc... but what is the SVRname,Silent and ODBCAttr
arguments?

Any tips would be welcome.


CreateDSN(DSNname As String, ODBCDriver As String,
SVRname As String, _
DBname As String, USER As String, PWD
As String, DSNdesc As String, _
Silent As Boolean, ODBCAttr As
String) As Boolean

Thanks

M.
..

 

[Ivar Svendsen]

Hello.

The easies way is to use the ODBC dialog to create a link
to the tables from Access. This will produce a .dsn file
that you can open in Notepad. You should be able to read
out all parameters you need from this file.

 

[DB2]

You can use an ODBC driver for DB2(ie StarSQL, www.starquest.com),
then you need to define your ODBC datasource through the ODBC Data
Source Administrator.

Hope this helps,

Bob