hi all ,

i m trying to coneect to a access database Using DSN , but when i try to connect i get an error

Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

. i m not getting iy , how to solve it .

please help me

Rajiv

Did you specify the provider name in the connection string?
It would be easier to trap the problem if you paste the
code which gives you the error

Regards,
Spacy

 dim rcon
    set rcon = server.CreateObject("ADODB.CONNECTION")
    rcon.ConnectionString ="DSN=report"
    rCon.Open

Check out this link:

http://www.aspfaq.com/show.asp?id=2301

it is still not working dear

 dim rcon
    set rcon = server.CreateObject("ADODB.CONNECTION")
    rcon.mode = 1 ' adModeRead
    rcon.ConnectionString ="DSN=report"

    rCon.Open

please suggest me how to solve it

;;;it is still not working dear
Still not working isnt going to get you a solution. Whats you error, is it the same, is it different...

For all your connectionstring troubles:

http://www.connectionstrings.com/

Wind is your friend
Matt

it was the same error ,