|
james1415
Starting Member
1 Posts |
 Posted - 22 August 2001 : 18:23:08
|
Hi,
Ive got a database connection error...
This is the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/uniqueuk/index.asp, line 29
It shows the rest of the page, because that is a news database its trying to connect to...
The ASP source code for the database connection that im using is:
<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver 2000 (*.mdb)};dbq=" & Server.Mappath("dbase/news.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
view = "SELECT * FROM News ORDER BY ID DESC"
RecSet.Open view, Connect, adOpenStatic, adLockOptimistic
Do Until RecSet.EOF
%>
The path to the database is correct, the directroy setup is:
\htdocs > \uniqueuk | \dbase
Obviously theres others in the htdocs (pulic so to speak) directory, im just trying some code out.
This is pretty urgent, as I need it all done by Saturday and I have about 4 more of these to sort out, the others work!
The address to the problem is: www.unique-hardware.co.uk/uniqueuk/index.asp its an old site of mine, and I am going to use the ASP code from it to intregrate it into my new site (unique-hardware.co.uk)
PLEASE HELP!!
Edited by - james1415 on 22 August 2001 18:24:29 |
|
Topic Locked
