DBI and Microsoft Access

nathaniel_welch · Mar 9, 2005

I need some help with connecting to a Microsoft Access database using
DBI. My files are stored on a remote server. I really don't have any
clue why I can't make this work. The error I get really has me
confused as well. I tried the following (where recruit is the DSN
name):

use DBI;
print "Content-type:text/html\n\n";
print "<html><head><title>Test Page</title></head><body>";
print "test1<br><br>";
$dbh = DBI->connect("dbi:ODBC:recruit");
print "test2</body></html>";
exit;

and the error I get is: "CGI Error The specified CGI application
misbehaved by not returning a complete set of HTTP headers.".

I also tried using a DSN less connection, but got the same error.

This exact code works fine in my old environment, but will not work
here. I checked and the DBI module is installed, so that's not the
problem.

Any help would be GREATLY appreciated!

Thanks,
Nate

nathaniel_welch · Mar 10, 2005

What happens when you remove $dbh = DBI->connect("dbi:ODBC:recruit");

from your code?

When I remove or comment that line, the code works fine. It prints
test1 and then test2 to the screen.

And, by the way, the error doesn't change whether I use single or
double quotes around the arguments for the connect.

Len

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption

=----

Fabian Pilkowski · Mar 11, 2005

* [email protected] said:
When I remove or comment that line, the code works fine. It prints
test1 and then test2 to the screen.

Hence there must be a problem with that line. So far you've posted the
error which will be displayed in your browser. This one was generated by
your webserver because your script hadn't returned a correct output.
Have a look into your webserver's errorlog to find out the errormessage
generated by your script.

Furthermore, you can add the line

use CGI::Carp qw( fatalsToBrowser );

to your script wherethrough all *your* errors will be redirected to your
browser. Especially while writing a script this could be helpful.

And, by the way, the error doesn't change whether I use single or
double quotes around the arguments for the connect.

When initializing a string you can use single or double quotes. Within
double quotes all vars will be interpolated (i.e. replaced by their
values), but not within single ones. Since you've no vars inside your
string you can't see any effect here.

regards,
fabian

nathaniel_welch · Mar 11, 2005

Fabian said:
Hence there must be a problem with that line. So far you've posted the
error which will be displayed in your browser. This one was generated by
your webserver because your script hadn't returned a correct output.
Have a look into your webserver's errorlog to find out the errormessage
generated by your script.

Furthermore, you can add the line

use CGI::Carp qw( fatalsToBrowser );

I added this to my code and realized that the DBD::ODBC driver was not
installed. I emailed the admin and he got it installed for me. Works
now.

Thanks,
Nate

iis and dbi	1	Jul 10, 2003
Fail extracting table from .mdb file using DBI module	6	Feb 10, 2008
DBI	2	Feb 8, 2009
Beginner DBI problem	10	Oct 19, 2005
Retrieving Data from Microsoft Access Database using Perl	4	Jul 21, 2003
iis dbi	0	Jul 10, 2003
DBI MS SQL connection error	2	Mar 28, 2007
Help with code	0	Jun 12, 2022

DBI and Microsoft Access

nathaniel_welch

nathaniel_welch

Fabian Pilkowski

nathaniel_welch

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads