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 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...
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...
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...
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...
I can establish two connections with my script as well, it is just when I call another script from my script. I.E. I have a perl script that access a DB to fill in drop down lists on a web page. All the HTML is outputed by Perl. When I click the submit button I move to another script, it is...
I have created a System DSN for the file I wish to open. However, whenever I move to another script to handle other processing tasks, it gives me the following error:
couldn't open Purchase Order DB: po because -1032[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine...
They should be in the lib subdirector under the Perl folder. The Perl folder was installed to where you told the installation program to install it to (by default it should be under c:/perl/lib.
Have fun....
I have created a System DSN for the file I wish to open. However, whenever I move to another script to handle other processing tasks, it gives me the following error:
couldn't open Purchase Order DB: po because -1032[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine...
I am using Win32::ODBC to connect to a database located on the C: drive of my computer. I have set up a file dsn through the administrator tools->ODBC tool in the control panel to point to the database with the microsoft access driver. Everytime I use the code
$DSN = "po.dsn";
#Connect to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.