Need Help - SQL Server 2000

Question

0.00/5 (No votes)

See more:

We have Classic ASP script which run on windows 2003 / SQL Server 2000 / SQLXMLOLEDB.3.0 ...

Recently we changed host. Now when we try to execute our script we get following error message .

Our connection string is
str = "Provider=SQLXMLOLEDB.3.0;Data Provider=SQLOLEDB;Initial Catalog=XXX;data source=XXXX;User ID=sa;Password=sa;"

ADODB.Connection error '800a0e7a'

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

Pl help me...

Thanks in advance!!!!

Posted 31-May-12 4:24am

nitintfs

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2012-05-31T04:28:00

Solution 1

Sounds like the provider isn't installed on the host you have moved to

http://www.connectionstrings.com/Providers/sqlxml-3-0-oledb-provider[^]

Do you have to use that provider? Maybe try a different connection string, e.g

http://www.connectionstrings.com/sql-server#p6[^]

Posted 31-May-12 4:28am

Dylan Morley

Comments

nitintfs 31-May-12 10:37am

Thanks for your immediate response...

For your reference my code something similar to the link below but it is developed using Classic ASP instead of VB -
http://msdn.microsoft.com/en-us/library/aa258684%28v=sql.80%29.aspx

Dylan Morley 31-May-12 10:44am

Ah I see - you may need to contact your new host support department and ask them about that provider

nitintfs 31-May-12 10:57am

It is VPS server and I have installed all necessary components - SQLXMLOLEDB.3.0 ...

What could be the solution for this ?

Please help me..

nitintfs 31-May-12 10:59am

I found one more link -
http://community.discountasp.net/showthread.php?t=2017

please see comments / sample code posted by Bruce.

My application similar to sample code by Bruce ...