ADODB.Connection.1 error '80004005'

[The69Pimp]

ADODB.Connection.1 error '80004005'

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


changed.asp, line 8


here are lines 1-10


<%
closed = 0
if closed = 0 Then
'///////////////////////////////////////////////////////////////////////////////////
'connection string

Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "getdata"


can someone PLEASE help me

[bostjank]

You need to specify the driver and the database after you create ADODB object and before you open it. If you use Access you can use

Set conn = Server.CreateObject("adodb.connection")
sConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source= " & Server.MapPath("FILE NAME")
conn. Open sConn


Bostjan

[The69Pimp]

same error different line it is now saying

ADODB.Connection.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
changed.asp, line 9



Set conn = Server.CreateObject("adodb.connection")
sConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source= " & Server.MapPath("finalchaos.mdb")
conn. Open sConn


conn. Open sConn is line 9

[bostjank]

Is your database in the same directory as the ASP page? Otherwise you must specify the path too.

If your page is in root folder and database in "db" folder you shoud specify path like "db/finalchaos.mdb"

Bostjan

[The69Pimp]

the db is right in the root directry!!!! :( please help me

[bostjank]

Then try this to open the database

sConn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("finalchaos.mdb")


Bostjan

[bostjank]

You may also check out this page - it deals with db errors
http://www.aspfaq.com/2009

Bostjan

[The69Pimp]

ok now i get this
i have


sConn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("finalchaos.mdb")
set MyConn = Server.CreateObject("ADODB.Connection")


in changed.asp
then i get


ADODB.Connection.1 error '800a0e78'
Invalid operation on closed object
/index.asp, line 10


on index.asp
this is what line 10 is on index


SQL = "SELECT ID FROM Members ORDER BY ID DESC"
Set RS = MyConn.Execute(SQL)


im executing it on line 10 whats wrong?????

[bostjank]

You forgot

MyConn.open sConn


Bostjan

[The69Pimp]

now i get


ADODB.Connection.1 error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

changed.asp, line 9


this is 7,8,9

sConn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("finalchaos.mdb")
Set Myconn = Server.CreateObject("adodb.connection")
MyConn.open sConn

[bostjank]

Two questions:
Does your ISP support MS Access?
Is your MDB file valid Access file?

Bostjan

[The69Pimp]

yes and yes
i made this game a few months ago, had it running then lost my isp and took it down, just got it back and now i cant run it because i cant get this to work

[bostjank]

If it woked I'd bet there is something wrong on the server of your ISP.

Bostjan

[aCcodeMonkey]

OLEDB is looking for a Provider not a driver.
Try this connection. Also if you look I am specifically telling Server.MapPath() to look in ght root directory by adding the "/" to the filename.



Dim oConn,oRs,sSQL
Set oConn = Server.CreateObject("ADODB.CONNECTION")
set oRs = Server.CreateObject("ADODB.RECORDSET")
oConn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" & Server.MapPath("/finalchaos.mdb")
oConn.Open
sSQL = "SELECT ID FROM Members ORDER BY ID DESC"
oRs.Open sSQL,oConn,2,1

Do While Not oRs.EOF
Response.Write(oRs.Fields("ID").value & "<BR>")
oRs.MoveNext
Loop



Hope this helps :cool: