How do i connect to MS Access mdb file using Perl on 1and1 web host?

J

Jeff

New member
I have this perl script:

#!/usr/bin/perl
print "Content-type: text/html\n\n";
use Win32::ODBC;
$db1 = new Win32::ODBC("DATABASE");
$db1->Sql("SELECT * FROM Contact");
while($db1->FetchRow()){
%F1=$db1->DataHash();
print "$F1{CompanyName}<br>";
}
$db1->Close();

## END ##

But when i execute this, the page does not display anything. The MS Access *MDB file is located in the db folder where it should be. i'm not sure how to setup an ODBC DSN, because there is no option for that in the control panel. I browsed through their help manual and FAQ file but i could not find a solution, except to put my MS Access files in the db folder.

Win32::ODBC may not be supported on 1and1. Is there an alternative to get my script to work?

My Hosting plan is MS Beginner Package, which supports MS Access and Perl.

I have been emailing their support for almost a week now but i'm not getting a response at all.
 
Back
Top