473,666 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP DB Connection Error 80004005

Fary4u
273 Contributor
Hi any body know's where is the problem in following code ?
it's so simple but can't figer it out ? giving this error ?

[PHP]
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
dbfile.asp, line 3
[/PHP]

[PHP]

dim db, strConn, Path
Path = Server.MapPath( db.mdb )
strConn = "PROVIDER=MICRO SOFT.JET.OLEDB. 4.0;DATA SOURCE=" & Path
Set db = Server.CreateOb ject("ADODB.Con nection")
db.open strConn

[/PHP]
Jul 7 '08 #1
10 3264
DrBunchman
979 Recognized Expert Contributor
Do you need to put quote marks around the name of your database? e.g.
Expand|Select|Wrap|Line Numbers
  1.  Path = Server.MapPath("db.mdb")
Dr B
Jul 7 '08 #2
Fary4u
273 Contributor
Thx for the reply i've tried it but now giving new error on line 5
i think so it's same line error

i've just put some " " but still

well actually it's works on the local host & giving error on the NET Hosting server
Jul 7 '08 #3
DrBunchman
979 Recognized Expert Contributor
Is it a new error? If so what is it?
Jul 7 '08 #4
Fary4u
273 Contributor
same error nothing else

[PHP]
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
dbfile.asp, line 5
[/PHP]
Jul 7 '08 #5
DrBunchman
979 Recognized Expert Contributor
What version of Windows and what version of IIS are you running on the server?

There is a known problem using JET with Windows Server 2003 and IIS 6.0 which intermittently doesn't return used database connections to the pool, causing it to run out of resources. If this is the case with your set-up the helpful advice from MSDN is to change your database to SQL Server!

Dr B
Jul 8 '08 #6
Fary4u
273 Contributor
it's working fine on windows xp iis 5 & DB is Access 2002

when i upload onto the webserver don't know why giving the same error ?
Jul 9 '08 #7
DrBunchman
979 Recognized Expert Contributor
What about the IIS and Windows versions on the server? What are they?
Jul 9 '08 #8
Fary4u
273 Contributor
iis 5 & windows server 2003
Jul 9 '08 #9
DrBunchman
979 Recognized Expert Contributor
Have you got another server you could try it on? Have you done any googling on that error message?

Dr B
Jul 10 '08 #10

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

Similar topics

13
2727
by: JIM.H. | last post by:
Hello I do not know anything about asb but I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files. MyODBC = "SQLODBC MyUsername = "sa MyPassword = "password Set objADODBConn = CreateObject("ADODB.Connection" strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";...
13
1857
by: Guy Hocking | last post by:
Hi there, i am creating a database driven login page. I am using code that has been successful in the past, however when i upload it to our web server it displys the following message in the page = ****** Microsoft OLE DB Provider for ODBC Drivers error '80004005' General error Unable to open
5
6659
by: Jesper Carstensen | last post by:
We are running an ASP application. That is fairly simple. It selects from one table (15.000 records), and updates into another table. But when we execute the ASP script, it reports the following error, after completing between 70%-80%. This varies each time it runs "Microsoft OLE DB Provider for SQL Server error '80004005'
5
4959
by: Brian Piotrowski | last post by:
Hi All, I almost have the connection working for my connection to the AS/400 from an ASP page. However, I have an error appearing, and I'm not sure how to fix it. The code I have for connecting to the AS/400 is this: <% Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=XXXX;Password=XXXX;Data Source=192.168.0.20;Catalog
2
2513
by: EDDIE | last post by:
Dear All, I have problem on data connection to a SQL Server by Asp Statement. It's Very strange that my asp statement can connect to one remote SQL server but can't connect to other remote SQL server. The statement written like this : Set DBLBX=Server.CreateObject("ADODB.Connection") DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"
2
1350
by: middletree | last post by:
First, here's my code(replaced some info with "foo": Dim strDBConnection strDBConnection = _ "Provider=SQLOLEDB;" & _ "Persist Security Info=False;" & _ "Data Source=w2003\ticketlog;" & _ "User ID=foo;" & _ "Password=foo;" & _ "Database=foo;"
1
2381
by: Shilpa Ginode | last post by:
Hi All, I have a problem regarding SQLXMLBulkLoad.3.0 and the DSN connection. I have created a object of SQLXMLBulkLoad.3.0 in my DTS package. The connection for this object is DSN connection. The connection string is "DSN=xx;uid=xxx;pwd=xxx". But while executing the DTS package i got the following error: Error: -2147467259 (80004005); Provider Error: 0 (0)
5
2522
by: rm | last post by:
When using ADO in a module inside an Access 2003 database do I need to open a db connection even though I am working with a table inside the same database? I am writing a bit of code to periodically import data from a text file to a table in a database. The capabilities of the import wizard are not sufficient to support what we need for manipulating/parsing the ascii text file.
2
2760
borisding
by: borisding | last post by:
Hi all, I have recently migrated ASP application from Windows server 2000 to 2003. But failed to connect to SQL Server 2000. (Both sql server and application are on the same server) I keep getting this error message when trying to connect to SQL Server 2000 from application: Microsoft OLE DB Provider for SQL Server error '80004005' Specified SQL server not found.
0
8356
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8640
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7386
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6198
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4369
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2771
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1776
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.