Connection string for InterSystems Cache ODBC driver

I want to form an ODBC connection string in C#.
I know how to plug all the connection data into the ODBC Data Source
Administrator, but want to do it programmatically.
I assume it is something like:

provider=InterSystems ODBC; host=127.0.0.1; port=1972; namespace=JDKKR;
login=foo; password=bar

but this does not work for me.

Any suggestions?
Thanks

Try using "provider=MSDASQL.1;Extended Properties="DRIVER={InterSystems ODBC};SERVER=127.0.0.1; PORT=1972;DATABASE=JDKKR;UID=foo;PWD=bar" as connactionstring.

Regards
Markus
---
Posted via www.DotNetSlackers.com