Hi Tim,

In case like that I use ODBC Manager to create FILE DSN with options I want, open it in any text editor and copy it's contents into connection string.

>Hi!
>
>Whats the correct format for the connection string for DB2..
>So far I tried:
>?SQLSTRINGCONNECT("Driver=IBM DB2 ODBC DRIVER;DB=PDM;UID=db2admin;PWD=db2admin")
>
>But I get the error:
>Connectivity error: [IBM][CLI Driver] SQL1013N The database alias name or database name "" could not be found. SQLSTATE=42705
>
>Not quite sure how to format this..
>
>An aside question: (How do I change/set a password in the "command center"
>for a new user?)
>
>BR
>Tim