This may be a simple thing to do but I don't know how. So any information will be appreciated. I have a little internal website that uses a System DSN ODBC Data Source which I use like:
$db = new Win32::ODBC("odbc_name");
But when I have people acceess the site and try to do things, it can't find the files specified in the ODBC connector because it looks for the ODBC conbfiguration on their computer instead of the server.
I'm hoping this is making sense.
To try to get around this, in the website, I tired to make a system call to the script instead of imbedding it in the webpage --- same problem.
Could someone pleae help. I can explain more if it is needed and post code, but I'm trying to be clear as possible.