Friday, March 9, 2012

how to find out MSSQL connection string?

how to find out MSSQL connection string?
Thx
YuriWHi Yuri,
Can you give us some more information on what it is you want
to know? Are you wanting to know how to build a connection
string for an application, for ADO to connect to SQL Server?
Or do you want to know how to tell how an application or
user is connecting to SQL Server? Or something else?
-Sue
On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>how to find out MSSQL connection string?
>Thx
>YuriW
>|||What connection string you should use to connect to a SQL
Server instance depends on the driver you use.
For instance, if you use the Microsoft SQL Server ODBC
driver, the connection string is documented under the
SQLDriverConnect() function.
Linchi
>--Original Message--
>how to find out MSSQL connection string?
>Thx
>YuriW
>
>.
>|||Say I have a ODBC connection that tests OK.
I want to know what connection string it uses when making a connection...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
> Hi Yuri,
> Can you give us some more information on what it is you want
> to know? Are you wanting to know how to build a connection
> string for an application, for ADO to connect to SQL Server?
> Or do you want to know how to tell how an application or
> user is connecting to SQL Server? Or something else?
> -Sue
> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
> <yuriw@.hotmail.com> wrote:
> >how to find out MSSQL connection string?
> >
> >Thx
> >
> >YuriW
> >
>|||It depends on what you entered for the options but it would
look something like the SQL Server ODBC examples at this
site (watch for line wrap on the link):
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer
Most of the entries correspond to what you see in the ODBC
data source administrator applet except for dialog you get
for authentication. If you select Windows NT Authentication
Using Network Login ID, that will use a connection string
with Trusted_connection=Yes.
If you select SQL Server authentication, that will use a
connection string with UID=YourLogin and PWD=YourPassword.
-Sue
On Wed, 29 Oct 2003 23:30:38 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>Say I have a ODBC connection that tests OK.
>I want to know what connection string it uses when making a connection...
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
>> Hi Yuri,
>> Can you give us some more information on what it is you want
>> to know? Are you wanting to know how to build a connection
>> string for an application, for ADO to connect to SQL Server?
>> Or do you want to know how to tell how an application or
>> user is connecting to SQL Server? Or something else?
>> -Sue
>> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
>> <yuriw@.hotmail.com> wrote:
>> >how to find out MSSQL connection string?
>> >
>> >Thx
>> >
>> >YuriW
>> >
>

No comments:

Post a Comment