access connection

 
Post new topic   Reply to topic    Aprelium Forum Index -> Classic ASP
View previous topic :: View next topic  
Author Message
~paolo~
-


Joined: 16 Jul 2004
Posts: 2

PostPosted: Fri Jul 16, 2004 11:48 pm    Post subject: access connection Reply with quote

hi all, i read some topic about ms access connection but i didn't understand nothing :( ...

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ="& Server.Mappath("..\Database\WebScu.mdb")
Conn.Open

it doesn't work and give me this error

Microsoft OLE DB Provider for ODBC Drivers- Error '80004005'

[Microsoft][Driver ODBC Microsoft Access] "(unknown)" it isn't a valid path. Make sure that the path's name is right and to be connected to the server where there is the file.

/html-ASP/procRegistra2.asp, line 10

i have XP Home Edition, but i didn't know how to resolve this problem...
i don't know the ways to config a connection in Data sources.. i tried :(
Back to top View user's profile Send private message MSN Messenger ICQ Number
iNaNimAtE
-


Joined: 05 Nov 2003
Posts: 2381
Location: Everywhere you're not.

PostPosted: Sat Jul 17, 2004 8:22 am    Post subject: Reply with quote

It is possible that you don't have the ODBC drivers installed. Do a search to find them and install them.
_________________
Bienvenidos!
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
~paolo~
-


Joined: 16 Jul 2004
Posts: 2

PostPosted: Sat Jul 17, 2004 5:09 pm    Post subject: Reply with quote

i have them... but nothing works
Back to top View user's profile Send private message MSN Messenger ICQ Number
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sat Jul 17, 2004 5:19 pm    Post subject: Re: access connection Reply with quote

~paolo,

The problem is related to the use of Server.MapPath(). ActiveHTML needs an extra configuration to make this function work as expected.
Please read http://www.aprelium.com/forum/viewtopic.php?t=4759 , http://www.aprelium.com/forum/viewtopic.php?t=4469 for similar topics.
Read also http://www.aprelium.com/forum/viewtopic.php?p=24625#24625 to know how to fix it (by doing the extra configuration steps in ActiveHTML.)
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Classic ASP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group