Wow! This is news to me! I've been using Win32::ODBC and was very worried
about portability. Now I try perldoc and cannot find anything about using
DBI with ODBC. However, I search CPAN and I find this:
"3.3 Is DBI supported under Windows 95 / NT platforms?
Finally, yes! Jeff Urlwin has been working diligently on building DBI and
DBD::ODBC under these platforms, and, with the advent of a stabler perl and
a port of MakeMaker, the project has come on by great leaps and bounds.
The DBI and DBD::Oracle Win32 ports are now a standard part of DBI, so,
downloading DBI of version higher than 0.81 should work fine as should using
the most recent DBD::Oracle version."
This is GREAT! But being a beginner, I don't know what to do next. Do I
download the source? Is there a PPM module? Where can I find an example that
accesses Microsoft Access?
Thanks,
Siegfried
-----Original Message-----
From: Wiggins d Anconia [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 7:33 AM
To: Rearick, Kenneth N.; '[EMAIL PROTECTED]'
Subject: Re: ODBC
>
>
>
> I have a CGI program in which I am trying to access a database. When I
run the code in active state feeding it the input from the form it runs
fine. When I try to run it as a cgi from IE using Apache web server the
data from the form comes in fine but it can not seem to attach to the
database.
>
> Is there anyway to see the errors that the DBI:ODBC is generating when
the application is being run from the server? Any ideas why the ODBC
connect is failing?
>
You can use CGI::Carp and 'fatalsToBrowser' to have fatal messages
thrown to the browser, alternatively error messages are generally sent
to the Apache error log. Check there for what they have to say. You
could also turn off DBI's automatic exceptions and catch them yourself,
but this is a fair amount more work (at least while prototyping).
> $dbh = DBI->connect("DBI:ODBC:$SERVER", $USER, $PASSWORD);
>
>
Sorry can't help with the connect issue, I suspect if you can find the
error output it will. If not you might try the dbi-users group or maybe
someone else with ODBC experience will chime in.
http://danconia.org
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
