473,322 Members | 1,496 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Classic ASP page will not connect to sql 64 bit

Recieving error

"ADODB.Connection error '800a0e7a'

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

/evalForm.asp, line 45"
where line 45 is the connection string to sql.
Expand|Select|Wrap|Line Numbers
  1. Set conn = Server.CreateObject("ADODB.Connection")
  2.      Set rs = Server.CreateObject("ADODB.Recordset") 
  3.      conn.open "driver={SQL server};server=<servername>;Uid=<username>;Pwd=<password>;Database=<databasename>;"
  4.  
situation:
website built with visual studio on xp sp 3, sql manahement console 32 bit.
server that will host is sql 64 bit. It works fine on the 32 bit. Afte much research online found a few links that suggest "provider={SQLOLEDB};server=<servername>;Uid=<user name>;Pwd=<password>;Database=<databasename>;"

Yet I still receive the same error message.
Jul 15 '08 #1
1 3100
DrBunchman
979 Expert 512MB
Hi thorn15,

Welcome to Bytes.com! I hope you find the site useful.

It sounds like you're missing the requisite dll files on this server. Has it got the latest version of the MDAC (Microsoft Data Access Components) on it?

Dr B
Jul 15 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

99
by: Jim Hubbard | last post by:
It seems that Microsoft not only does not need the classic Visual Basic developer army (the largest army of developers the world has ever seen), but now they don't need ANY Windows developer at a...
19
by: Adam Short | last post by:
I am trying to write a routine that will connect a .NET server with a classic ASP server. I know the following code doesn't work! The data is being returned as a dataset, however ASP does not...
5
by: Velvet | last post by:
Can someone tell me to what process I need to attach to be able to step through my classic ASP code in VS.net 2003. I'm working on an XP box with IIS installed. I also have VS.net 2005 (The...
3
by: MartyNg | last post by:
I have been looking online for pointers, and read mixed things. I was hoping if I post direct questions here, I could get some solid answers. I work for a small company with less than 10 web...
3
by: | last post by:
Hi All, I have several classic asp pages in site that were originally programmed with Visual Interdev (or Visual Web Developer Alpha... remember that?). The pages use the Script Library objects...
9
by: CK | last post by:
Good morning all, We have a classic asp application on our local intranet. Employees log in to and use the app. We recently added some additional functionality to the site and this was written in...
8
by: antonyliu2002 | last post by:
We are extending a web application written in classic ASP long time ago. We will add more components to this web application in ASP.NET 2.0. To use the web application, our web users will have...
6
by: =?Utf-8?B?UGFyYWcgR2Fpa3dhZA==?= | last post by:
Hi All, We have a requirement where we have to develop a custom Login Page which will accept user's NT credentials ( Username , password, domain name). This then needs to be passed to a website...
11
by: =?Utf-8?B?c2NodXJzdDMw?= | last post by:
Hi, I am currently trying to get back into ASP and have begun looking at an old webpage I developed some years ago, it was fully functional back in 2002 and I had it up and running with no...
7
by: David | last post by:
Hi, I am attempting to do URL ReWriting with .NET to my classic ASP app. (Too big to upgrade to .NET at the moment). However, those who have tried will know that classic asp when rewritten...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.