Can I use integrated security in an ODBC connection string without using a DSN?
This is a discussion on Can I use integrated security in an ODBC connection string without using a DSN? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Can I use integrated security in an ODBC connection string without using a DSN? If so, what would the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:46 PM
| |||
| |||
 Re: Can I use integrated security in an ODBC connection string without using a DSN? Trusted connection: "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=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 >      |
|
02-27-2008, 09:46 PM
| |||
| |||
| Re: Can I use integrated security in an ODBC connection string without using a DSN? Thanks.... Do you know of a way to connect using integrated security with Oracle? Tony "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.d e> wrote in message news:Onf$jAtbFHA.2936@tk2msftngp13.phx.gbl... > Trusted connection: > > "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=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 >> > > |
|
02-27-2008, 09:46 PM
| ||||
| ||||
| Re: Can I use integrated security in an ODBC connection string without using a DSN? YOu have to set a parameter in the SQLNet.Ora http://www.windowsitpro.com/Windows/...280/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.d e> wrote > in message news:Onf$jAtbFHA.2936@tk2msftngp13.phx.gbl... >> Trusted connection: >> >> "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=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 >>> >> >> > > |
 |
« Timeout Expired - Same query working for months
|
ODBC Error when running DTS directly on the server »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:11 AM.
