Recent content by bknox

Everyone: Thanks for your help on the problems that I have been facing. I have solved the problem posted in this request. Evidently, all of my scripts have been accesing the DB under my user account on my local machine, except the one that was giving me the problems. I modified the access...

The connecttodsn function assigns the DSN to $db. I use is throughout my scripts (about 8 or so). It has worked up until know, so I don't think this is the problem. Thanks for the observation, Ben

I copied you code into the script and I still got the same error. I have printed out the resulting SQL statment as just a plain text string and it shows the value is getting inserted fine. I have even copied this printed SQL statement and placed it into my Access DB as a Query and it executed...

I tried the code you posted, and I am still getting the same error. It is in the Execute phase that it throws the error. Ben

I am developing a web page that will create purchase orders for me using HTML and Perl. I am using the DBI:ODBC module to interface into an Access DB that holds all the purchase order information. I am running IIS on my local machine to test and debug the code before I place it into...

print <<EOF; stuff.......... EOF That should do the trick. Ben

Thanks Paul for all your help. I got the script to script error's solved by transforming all my DSN connections to DBI connections instead of Win32::ODBC. All the data is coming from a form that is submitted. The form is simply two text fields that need to be added to a DB table. Ben

I have minor question regarding perl and ODBC. I have multiple scripts that access, query, and modify an Access DB. I am using DBI:ODBC to accomplish this. Everything is working perfectly, except that I have found a minor quirk in PERL, and was wondering if anyone had any insight into the...

I have managed to get Perl to move from script to script without throwing the 1032 ODBC Error (Only for so long though) I have been able to move to 5 scripts without once getting this error, however on the 6th script it gives me the same error. I have tried moving the DB somewhere else...

I don't understand please clairfy. Guninees Over IP?

It is not in production yet, so it is not working in testing stages. I have set up a DSN through XP under the admistrator tools within the control panel. It is a System DSN with a Access driver being used, and named po. I have the latest version of active perl installed, and are running the...

correction: shipInfo.pl: #!c:\Perl\bin\perl.exe -w use Win32::ODBC; use CGI ':standard'; use CGI::Carp qw(fatalsToBrowser); require 'functions.lib'; print "content-type: text/html \n\n"; $db; connecttodsn($db); print "In Script"; $db->close();

Here you go Paul: Script1: #!c:\Perl\bin\perl.exe -w use Win32::ODBC; use CGI ':standard'; use CGI::Carp qw(fatalsToBrowser); require 'functions.lib'; print "content-type: text/html \n\n"; $db; connecttodsn($db)...

$_[0] indicates the first value passed to the subroutine. I call it with connecttodsn($db) so $_[0] is a reference to $db. I am not sure what you mean by check the po on the machine. It is working, b/c I can use it in one script just not in another. I get the same error message even if I...

No Sir. I just have the Web program running in IE.