Re: Classic ASP connectionstring to SQL Server 2005

So this connection string is in the VB6 dll? Yes

What is the error message? Provider cannot be found. It may not be properly
installed.

Do you have physical access to the machine running the web server? Yes

If so, can you ping the sql server? Yes


"Bob Barrows [MVP]" wrote:

Both libraries should no be needed.
So this connection string is in the VB6 dll? No, it makes no difference.
I'm still in the dark as to the failure mode when using SQLOLEDB. What
is the error message?
Do you have physical access to the machine running the web server? If
so, can you ping the sql server?

Guy wrote:
Thanks for the information. I tried using 'SQLNCLI' but when I did I
received an error message:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

I also checked to see if TCP/IP is enabled and it is. I noticed that
there is an option to enable both TCP/IP and name pipes. Is that an
option I should enable instead? Did I mention that I am accessing the
database from an ASP to VB6 DLL to SQL Server 2K5? I'm not sure if
that matters but I thought I should mention it. Any other suggestions
would be greatly appreciated.

Thanks
Guy
"Bob Barrows [MVP]" wrote:

Guy wrote:
Hi

I am supporting a classic ASP application that uses SQL Server 2000
on the backend. I now need to contect to a SQL Server 2K5 database.
I currently use conntectionstring: Provider= sqloledb.1;Persist
Security Info=False;User ID='XXX';Password= 'XXXX';Initial Catalog=
'XXXXX';Data Source='XXXX';Connect Timeout='25' which does not work.
Is there another connectionstring I should use?


That's pretty much what I use. You can also use the SQLNCLI provider
instead of the SQLOLEDB one, but if SQLOLEDB isn't working, then
neither should SQLNCLI. (btw - always endeavor to describe your
symptoms without using the words "not work" or "not working" or
similar non-descriptive verbiage - error messages are always
helpful).

Is TCP/IP enabled on your sql server? I think you have to use the SQL
Server Surface Area Configuration tool (Start>SQL Server
2005>Configuration Tools) to enable it ... yes, it's accessed by
clicking the Services and Connections link. Look for the Remote
Connections option in the Database Engine node.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.

Relevant Pages

  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • VSS Errors using NTBackup
    ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... I tried adding the TCP but then I get a error message "Microsoft Office Accounting cannot open the company because of a connection error." ... I assume that's why trying to force a TCP connection doesn't work. ... Rick Byham, SQL Server Books Online ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to send emails - common issue!!
    ... Is Tiscali your Internet connection provider as well as your mail provider? ... That error message typically happens when the two providers are different. ... I have been using the same laptop for the past year, ...
    (microsoft.public.windows.vista.mail)
  • Re: Error while connecting remote SQL server
    ... There might be possoble you have defined aliases for the SQL server in your ... An error has occurred while establishing a connection to the server. ... (provider: Named Pipes Provider,error:40-Could not open ... (provider: Named Pipes Provider, error: 0 - No process is on the other ...
    (microsoft.public.dotnet.framework.adonet)