Connection string for InterSystems Cache ODBC driver

G

Guest

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
 
M

Markus

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's wrong with my ODBC connection string? 2
Silly ODBC Connection problem 3
ODBC connection works, but connection string doesn't 8
Provider independent data access: problem with Excel ODBC source 3
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
ODBC & OLEDB 2
How to get a SQLConnection string from an ODBC DNS? 4
What is the connection string for oleDBConnection for Paradox? 3

Top