Click here to Skip to main content
11,801,910 members (61,089 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP XML SQL-Server
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

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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

Do you have to use that provider? Maybe try a different connection string, e.g[^]
techfortune at 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 -
Dylan Morley at 31-May-12 10:44am
Ah I see - you may need to contact your new host support department and ask them about that provider
techfortune at 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..
techfortune at 31-May-12 10:59am
I found one more link -

please see comments / sample code posted by Bruce.

My application similar to sample code by Bruce ...

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

  Print Answers RSS
0 OriginalGriff 445
1 KrunalRohit 301
2 F-ES Sitecore 215
3 CHill60 185
4 Afzaal Ahmad Zeeshan 180
0 OriginalGriff 2,715
1 Maciej Los 1,900
2 KrunalRohit 1,797
3 CPallini 1,550
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web02 | 2.8.151002.1 | Last Updated 31 May 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100