Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 asp can not connect to MS Access database
Google
Post new topic Reply to topic
Author Message
khanhsma
 
 


Joined: 16 Sep 2006
Posts: 2

PostPosted: Sat Sep 16, 2006 11:37 am Reply with quoteBack to top

I use
Quote:
Apache/2.2.0 (Win32) PHP/5.1.2 mod_perl/2.0.3-dev Perl/v5.8.7


I enable asp and mod_perl
asp works but when i can not connect to MS Access database
Code:
set conn=server.createObject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open "driver={microsoft access driver (*.mdb)}; dbq=" & server.mappath("data/data0211.mdb")
rs.open "select * from baihat;",conn


Always show this error
Code:

Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500
localhost
09/16/06 18:36:47
Apache/2.2.0 (Win32) PHP/5.1.2 mod_perl/2.0.3-dev Perl/v5.8.7


I setup MS Office 2000 full

Did i do something wrong?

I need a help. Please tell me exactly what i have to do, plz. I'm trying to learn the way to create a webserver. Thank you in advance!
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Wed Sep 20, 2006 8:14 pm Reply with quoteBack to top

you can not use microsoft ASP functions in Apache::ASP
View user's profileSend private message
khanhsma
 
 


Joined: 16 Sep 2006
Posts: 2

PostPosted: Thu Sep 21, 2006 3:50 am Reply with quoteBack to top

Vlad Alexa Mancini wrote:
you can not use microsoft ASP functions in Apache::ASP


Thanks for your answer.
Can you tell me the way to connect to a MS Access DB, i really need it now, plz. A lot of thanks
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Fri Sep 22, 2006 7:19 pm Reply with quoteBack to top

Perl database access is handled through the DBI layer, check out: http://dbi.symbolstone.org/

With Apache::ASP + mod_perl you may get an ADO object through the $Server->CreateObject() API.
View user's profileSend private message
Joshua Meadows (DemoRic)
support
support


Joined: 29 Dec 2004
Posts: 783
Location: S.E. Kansas

PostPosted: Sat Oct 14, 2006 11:28 pm Reply with quoteBack to top

If you would like you could try:
ftp://jaydium.servehttp.com/Extreme-mod_aspdotnet.rar

It's a modified package from another wamp
Build is:
mod_aspdotnet 2.2.2004 -- July 2006 source

If you do try please reply.
View user's profileSend private messageYahoo MessengerICQ Number
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
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
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT