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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


.

Relevant Pages

  • Re: Aggregate column comparison in sql server sql ?
    ... is a syntax that also works in Oracle. ... so SQL Server is at fault here. ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Performance of REGEXP_LIKE vs LIKE?
    ... There are certain situations where the syntax of REGEXP_LIKE ... is cleaner and shorter than the comparable LIKE expression. ... search of a 3 million record table, for a series of text strings. ... How about Oracle Text? ...
    (comp.databases.oracle.misc)
  • Supporting SQL Server and Oracle query syntax
    ... Server and Oracle using the IDb* interfaces instead of using each provider ... Unfortunately we still have to deal with the differences in the SQL syntax. ... The JOIN syntax is probably the most obvious difference between SQL Server ... Dim select as SelectStatement = currentProvider.GetSelectStatement ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to ODBC without a DSN
    ... > Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle) ... > This would be great as dumb users can't handle creating a DSN. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Connection to ODBC without a DSN
    ... > Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle) ... > This would be great as dumb users can't handle creating a DSN. ...
    (microsoft.public.sqlserver.programming)