Web Hosting Talk







View Full Version : Possible Mystery Database, lol.


nEMESIS4
09-10-2001, 02:25 PM
Well I have a very odd question for everyone, and need some assistance. We have a client who will be moving their site over to our RAQ4 due to problems with their current host. Their site right now is hosted on a WinNT machine. The site is ASP which uses a file.mdb file. I'm not too familiar with databases on RAQ's, and can't figure out how to get this database working. The ASP works perfectly fine, but here is the error message on the database portion. Any help would be greatly appreciated, thanks.

------------------------------

ADODB.Connection.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified


searchbusiness.asp, line 33

sbrad
09-10-2001, 02:36 PM
A Microsoft database will not work on a Unix/Linux system. This is going to have to be ported over to something like MySql or Postgres.
This link might be of some help to you:
http://www.accessmysql.com/

Marty
09-10-2001, 03:07 PM
Yea, that file.mdb file is a Microsoft Access database. It will not run on a Linux system. You will either have to convert it to a MySQL or PostgreSQL database or host the database remotely on a Windows server.

nEMESIS4
09-13-2001, 11:05 AM
Ok thanks very much for the help. Umm before anybody shoots me I just have one quick question, lol.

After I convert the access file into a MySQL data base, then what do I do to get it working on the site? ;)