Home > Archive > MS SQL Server ODBC > June 2005 > Can I use integrated security in an ODBC connection string without using a DSN?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Can I use integrated security in an ODBC connection string without using a DSN?
Tony

2005-06-11, 8:23 pm

Can I use integrated security in an ODBC connection string without using a
DSN?

If so, what would the syntax be for SQL Server and Oracle (if supported by
Oracle)?

Tony


Jens Süßmeyer

2005-06-11, 8:23 pm

Trusted connection:

"Driver={SQL Server};Server=Aron1
;Database=pubs;Trust
ed_Connection=yes;"

from http://www.connectionstrings.com/ (really good source for
connectionstrings)

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Tony" < tonyng2@spacecommand
.net> schrieb im Newsbeitrag
news:O4upNWsbFHA.3492@TK2MSFTNGP14.phx.gbl...
> Can I use integrated security in an ODBC connection string without using a
> DSN?
>
> If so, what would the syntax be for SQL Server and Oracle (if supported by
> Oracle)?
>
> Tony
>



Tony

2005-06-12, 3:23 am

Thanks....

Do you know of a way to connect using integrated security with Oracle?

Tony

"Jens Süßmeyer" < Jens@Remove_this_For
_Contacting.sqlserver2005.de> wrote in
message news:Onf$jAtbFHA.2936@tk2msftngp13.phx.gbl...
> Trusted connection:
>
> "Driver={SQL Server};Server=Aron1
;Database=pubs;Trust
ed_Connection=yes;"
>
> from http://www.connectionstrings.com/ (really good source for
> connectionstrings)
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
> "Tony" < tonyng2@spacecommand
.net> schrieb im Newsbeitrag
> news:O4upNWsbFHA.3492@TK2MSFTNGP14.phx.gbl...
>
>



Jens Süßmeyer

2005-06-12, 7:23 am

YOu have to set a parameter in the SQLNet.Ora

http://www.windowsitpro.com/Windows...2280/42280.html

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Tony" < tonyng2@spacecommand
.net> schrieb im Newsbeitrag
news:Oq36BPwbFHA.1044@TK2MSFTNGP10.phx.gbl...
> Thanks....
>
> Do you know of a way to connect using integrated security with Oracle?
>
> Tony
>
> "Jens Süßmeyer" < Jens@Remove_this_For
_Contacting.sqlserver2005.de> wrote
> in message news:Onf$jAtbFHA.2936@tk2msftngp13.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com