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)

[Former Member]

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