Lunarpages Web Hosting Forum

Scripting Languages Hosting Help => ASP Support => Topic started by: calabus on June 17, 2002, 01:13:00 AM

Title: ASP database problem
Post by: calabus on June 17, 2002, 01:13:00 AM
Well I uploaded all the files need for a picyure gallery page. I added the following string in constring.asp:
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("fpdb/gallery.mdb")

This points to the correct folder and file. I did a CHMOD to the .mdb file to 777 , but I am getting the following error: 506 ASP Not Available

Any help ???



Ok looks like I had the permissions for the .asp files wrong. I changed them to 777 and now I get this error:

ADODB.Connection.1 error '80004005'

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

include/constring.asp, line 16


[ June 17, 2002: Message edited by: calabus ]

Title: ASP database problem
Post by: TWebMan on June 17, 2002, 01:52:00 PM
Although asp is available, I don't know if the microsoft jet ODBC engine is available.  You may have to connect using a different linking method.  The CPanel sql entrance page lists the connection strings/types available.

ASP is nice and I've been using it for years, but when it comes to a mysql database, you're much better off using php, at least to make the connection.  At that point I'm sure you can give it a name and hand it off to asp- never done it quite that way, but I don't see why there would be a problem.  Hope this helps.   (http://images/smiles/icon_wink.gif)
Title: ASP database problem
Post by: Max on June 17, 2002, 04:36:00 PM
This fall we will introduce NT hosting, Access and other kinds of database connectivity will be supported then, and you will be able to use ODBC connections.