OK I have a project I got assigned. To make a web interface for a specific client that will use the Remedy's ODBC driver connection to pull data.

Here is where the fun part starts. I have successfully done this via PHP. However I am now having to create an Excel Spreadsheet and well the best way to do this I am finding is to use Perl. That is cool however I can not for the life of me figure out how to connect to this ODBC and run SQL commands against it pull data back and print it. I have tried using the Win32::ODBC module as well as the DBI/DBD::ODBC Module(s). Can you all give me any help on how I can interface Perl with the Remedy ODBC Driver and pull data back to dumb to a Excel Spreadsheet?

Anyone got any examples I can view?? Any help will greatly be appricated.

Regards,

Billy S.

I did it once with DBI, using the snippet

$source = <Insert the name of the ODBC setup here>
$dbi = DBI->connect("DBI:ODBC:$source", "$user", "$password", {RaiseError=>1, AutoCommit=>1});

It ran slowly, but it ran.

stefan.cords@lhsysnet.com