Re: ODBC vs OLEDB - Is there a real differnece?

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

From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 14:46:51 +1100

a) To get to ODBC you now need to go through an OLEDB Provider (the OLEDB
Provider for ODBC Drivers)

b) I don't understand what you're talking about with respect to "passwords
in clear text". Clear text where? If you want to connect to the SQL Server
using the IUSR_<machinename> account you use "Integrated Windows Security"
to connect to the SQL Server. There's no need to store the password anywhere
yourself:

strConnect = _
    "Provider=SQLOLEDB;" & _
    "Data Source=<servername>;" & _
    "Initial Catalog=<databasename>;" & _
    "Integrated Security=SSPI;"

Cheers
Ken

"John Hoge" <jhoge123@yahoo.com> wrote in message
news:d0f2d316.0403231712.69123f33@posting.google.com...
: I've been told that OLEDB is a faster way to get to a SQL Server
: database from ADO than to use ODBC. My paranoid streak prevents me
: from putting a password in cleartext on my web server. Given the
: number of source revelation exploits I've read about, I would rather
: not do this and just use the IUSR account through the ODBC driver.
:
: Any thoughts on the issue?

Relevant Pages

  • Re: ODBC vs OLEDB - Is there a real differnece?
    ... >account if the SQL Server is on another machine on the network ... ... Jeff ... >> a) To get to ODBC you now need to go through an OLEDB Provider (the ... >> OLEDB Provider for ODBC Drivers) ...
    (microsoft.public.inetserver.asp.db)
  • Re: Import problems on Windows Server
    ... your OWN research the Mickeysoft ODBC drivers do NOT support ANY ... Oracle feature beyond 7.3? ... There are plenty of non MS ODBC drivers that will connect with the various editions of non-MS databases, some of the drivers are actually better. ... Free speech - I'm here to stay dude - get used to it; when you see a post relating to SQL Server or Windows I'll be there with an answer to any myth you might want to TRY and spread. ...
    (comp.databases.oracle.server)
  • RE: Linked Server -- unexpected return data length
    ... Some 3rd party ODBC drivers behave differently than SQL Server ODBC driver ... where the length indicator buffer is populated with the value '-1'. ... Some 3rd party ODBC drivers, however, do not take this approach and instead ...
    (microsoft.public.sqlserver.server)
  • Re: ODBC vs OLEDB - Is there a real differnece?
    ... Ken Schaefer wrote: ... > OLEDB Provider for ODBC Drivers) ... >> I've been told that OLEDB is a faster way to get to a SQL Server ... >> not do this and just use the IUSR account through the ODBC driver. ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL slammer, i have it, awww geez now what?
    ... >have fix) and mine says MSDA and JET 4.0 and is OLEDB ... >Provider for ODBC drivers I shut down ports ...
    (microsoft.public.sqlserver.security)