Click here to Skip to main content
11,412,345 members (67,560 online)
Rate this: bad
good
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 5:24am

1 solution

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

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[^]
  Permalink  
Comments
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 -
http://msdn.microsoft.com/en-us/library/aa258684%28v=sql.80%29.aspx
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 -
http://community.discountasp.net/showthread.php?t=2017

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 332
1 Sascha Lefévre 200
2 Sergey Alexandrovich Kryukov 140
3 Maciej Los 135
4 ProgramFOX 130
0 Sergey Alexandrovich Kryukov 9,025
1 OriginalGriff 7,247
2 Maciej Los 3,525
3 Abhinav S 3,248
4 Peter Leow 3,059


Advertise | Privacy | Mobile
Web03 | 2.8.150414.5 | 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