General discussion

Locked

Dsn-less connection with ADO

By hemant_mail ·
Hi.
I have problem to connect Sql server with ADO with out any DSN.
I connect with DSN, but I want to coonect it with out DSN.
Is there any solution about this???
Hemant.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ADO Connection without DSN name

by RMCDUFFIE In reply to Dsn-less connection with ...

Use these in your connect string:
"Driver=SQL Server;"
"SERVER=" + strServer + ";"
"UID=" + strLoginID + ";"
"PWD=" + strPwd + ";"
"DATABASE=" + strDBS + ";"

If you don't have a database name you might want to use the ODBC API instead.

Rob McDuffie

Collapse -

Use this:

by Bunce In reply to ADO Connection without DS ...
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums