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

From: Bob Barrows (reb01501_at_NOyahoo.SPAMcom)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 07:00:15 -0500

Of course, using integrated security requires that IUSR be made a domain
account if the SQL Server is on another machine on the network ...

Ken Schaefer wrote:
> 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? 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)