473,383 Members | 1,952 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,383 software developers and data experts.

How can I check whether the Server has database drivers installed?

Hello,

Is there a simple way to check whether a database driver is available
on a remote server? I only have ftp access so I can only run ASP
scripts.

An ASP application on a host has died again.

I'm getting either:

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.
/news_archive.asp, line 21

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application
recognizes, or the file may be corrupt.
/news_archive.asp, line 23

depending on which driver I try to get it working with.

The last time it died it was because the host changed the server,
directory path and killed the JET driver, replacing it with ODBC.

Now, by the look of it, the ODBC driver may have vanished too.

Is there a simple way for me to check what drivers are available?

I've just tried it on my local machine and it works with either
driver.

Jul 19 '05 #1
6 4565
Tried simply asking your host?

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"mark4asp" <ma****************@ntlworld.com> wrote in message
news:d7********************************@4ax.com...
Hello,

Is there a simple way to check whether a database driver is available
on a remote server? I only have ftp access so I can only run ASP
scripts.

An ASP application on a host has died again.

I'm getting either:

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.
/news_archive.asp, line 21

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application
recognizes, or the file may be corrupt.
/news_archive.asp, line 23

depending on which driver I try to get it working with.

The last time it died it was because the host changed the server,
directory path and killed the JET driver, replacing it with ODBC.

Now, by the look of it, the ODBC driver may have vanished too.

Is there a simple way for me to check what drivers are available?

I've just tried it on my local machine and it works with either
driver.

Jul 19 '05 #2
Have you tried getting a copy of the MDB and opening it with Access ?
Perhaps it is corrupted?
"This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. 2003 Microsoft Corporation. All
rights reserved."

Richard Marr
Microsoft IIS Support Professional

Jul 19 '05 #3
On Sat, 03 Jul 2004 10:54:59 GMT,
richard[MS]@online.microsoft.com (Richard Marr) wrote:
Have you tried getting a copy of the MDB and opening it with Access ?
Perhaps it is corrupted?
Thanks. I FTPed it over locally and opened it. It was OK but it
is an earlier version, '97. So I had to open that with Office
2002 but it opened OK. I could scroll the records and view the
latest data.

I think the host must've been messing about with the server
again. I wouldn't be the first time. I wouldn't mind except ...
if they move our application to a new location on a different
server you'd think they'd have the decency to tell me which
version of Windows, service packs, database drivers, ASP they'd
installed.

I'd thought that would be standard practice.
"This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. 2003 Microsoft Corporation. All
rights reserved."

Richard Marr
Microsoft IIS Support Professional


Jul 19 '05 #4
try TELNETing to it on the listening port - it should connect but if you are
unsure, open up another command sesh and use netstat to see the established
connection

so for MS SQL:

telnet <remote IP> 1433

then in another window, type

netstat -na | find "1433"

you should see something like this:

G:\>netstat -na | find "1433"
TCP 192.168.0.101:1181 192.168.0.100:1433 ESTABLISHED

"mark4asp" <ma****************@ntlworld.com> wrote in message
news:d7********************************@4ax.com...
Hello,

Is there a simple way to check whether a database driver is available
on a remote server? I only have ftp access so I can only run ASP
scripts.

An ASP application on a host has died again.

I'm getting either:

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.
/news_archive.asp, line 21

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application
recognizes, or the file may be corrupt.
/news_archive.asp, line 23

depending on which driver I try to get it working with.

The last time it died it was because the host changed the server,
directory path and killed the JET driver, replacing it with ODBC.

Now, by the look of it, the ODBC driver may have vanished too.

Is there a simple way for me to check what drivers are available?

I've just tried it on my local machine and it works with either
driver.

Jul 19 '05 #5
Not sure if you got this resolved yet but you could try the code against
another database.
If that fails as well the issue could be with the installation of Mdac.
For that you wil have to workk with yur Isp .
"This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. 2003 Microsoft Corporation. All
rights reserved."

Richard Marr
Microsoft IIS Support Professional

Jul 19 '05 #6
On Tue, 06 Jul 2004 16:21:52 GMT,
richard[MS]@online.microsoft.com (Richard Marr) wrote:
Not sure if you got this resolved yet but you could try the code against
another database.
If that fails as well the issue could be with the installation of Mdac.
For that you wil have to workk with yur Isp .
"This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. 2003 Microsoft Corporation. All
rights reserved."

Richard Marr
Microsoft IIS Support Professional


The ISP have fixed it now but they haven't bothered telling me.
Ah, the perils of free hosting!

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: hitendra15 | last post by:
How to Deploy SQL server Database to another PC, How to create a package that craetes Database as well as ODBC driver for accessing data at enduser PC, using .Net VB
2
by: adam | last post by:
hello What query shoul I send to SQL serwer ( in transact SQL language ) to check does some database exist on serwer ? It similar to problem "does some table exist in database" - resolve to it...
3
by: NWx | last post by:
Hi, I write an ASP,NET application who uses SQL Server (MSDE) as Back-end I'm an experienced developer, but haven't used SQL server before and I need some help. Since I don't have full SQL...
5
by: zimmy | last post by:
Hi, Is it possible to check whether ASP.NET is installed on a machine, within a program that I'm writing in C#? And if it's installed, can I check if it is enabled? How? Thanks
4
by: EMW | last post by:
How can I create a SQL server database in my VB.NET program? I've MSSQLServer installed and running. If a database is created, where is it stored? I used the following code, didn't get any...
0
by: jsausten | last post by:
I am having this ridiculously frustrating problem, migrating an existing web app to VS.2005. Initially I was able to successfully convert my VS 2002 app, by opening the Localhost site using the...
9
by: TC | last post by:
Like a lot of database developers, I often choose Jet for the back- end. I'm starting to worry about what will happen when Jet is deprecated. Ostensibly, Jet users like me must switch to SQL Server...
12
by: foolsmart2005 | last post by:
There are 10 webpages on the host, e.g. 001.html, 002.html, 003,html, 004.html, ......010.html I want to check whether the page is the last page. How can I do. In the index.html -Go to last...
1
by: Just D | last post by:
All, Returning to WinForms - what is the current situation with the MS SQL Server database access? Did anybody see any good review or can just give us his own impression about that? I'd like to...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.