| 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 |
|
| |