Question Re: How do I create a connection string to sql server? in Technology Q&A

How do I create a connection string to sql server?

Former Member — Fri, 20 Mar 2009 15:30:10 GMT

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.

Re: How do I create a connection string to sql server?

Former Member — Fri, 20 Mar 2009 15:49:32 GMT

As in:

Database ->

Database Expert ->

Create New Connection ->

OLE DB (ADO) ->

Microsoft OLE DB Proived for SQL Server (from dropdown)

Re: How do I create a connection string to sql server?

Former Member — Fri, 20 Mar 2009 15:49:41 GMT

If you have SQL Server or client installed in your machine you can directly connect to SQL server using native connection. When you create new report you can see the option create new connection, here you can see SQL Server. Expand it and enter the connection details where you will be directly connected to SQL Server without ODBC connection.

Regards,

Raghavendra