How do I create a connection string to sql server?

[Former Member]

Hi All,

I am currently connecting to a SQL Server via ODBC DSN connection. I am wondering how do I create a connection string directly to a sql server without a DSN connection?

Thank you in advance.

[Former Member · Accepted solution]

As in:

Database ->

Database Expert ->

Create New Connection ->

OLE DB (ADO) ->

Microsoft OLE DB Proived for SQL Server (from dropdown)