Apache2Triad Help, Support and Development Forum Index Apache2Triad Help, Support and Development
The apache2triad help , support and development forums
 

asp can not connect to MS Access database
Click here to go to the original topic

 
       Apache2Triad Help, Support and Development Forum Index -> Programming
View previous topic :: View next topic  
Author Message
khanhsma



Joined: 16 Sep 2006
Posts: 2

Posted: Sat Sep 16, 2006 11:37 am    Post subject: asp can not connect to MS Access database  

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!
Back to top  
Vlad Alexa Mancini



Joined: 07 Jul 2003
Posts: 1538

Posted: Wed Sep 20, 2006 8:14 pm    Post subject:  

you can not use microsoft ASP functions in Apache::ASP
Back to top  
khanhsma



Joined: 16 Sep 2006
Posts: 2

Posted: Thu Sep 21, 2006 3:50 am    Post subject:  

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
Back to top  
Vlad Alexa Mancini



Joined: 07 Jul 2003
Posts: 1538

Posted: Fri Sep 22, 2006 7:19 pm    Post subject:  

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.
Back to top  
Joshua Meadows (DemoRic)



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

Posted: Sat Oct 14, 2006 11:28 pm    Post subject:  

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.
Back to top  
 
       Apache2Triad Help, Support and Development Forum Index -> Programming
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.13 © 2001, 2002 phpBB Group