Win32::ODBC doesn't connect on browser

ckim06 has asked for the wisdom of the Perl Monks concerning the following question:

I have my scripts set up to open a database, and it opens it fine on the command line, but not in the browser. Here's some code.

require "c:/vcanew/cgi-bin/cgi-lib.pl";

print  &PrintHeader;
print  &HtmlTop();

if (!($db = new Win32::ODBC("MyDSN")))
    {
        print Win32::ODBC::Error();
        print &HtmlBot;
        exit();

    }
    else
    {
        print "Works";
        print &HtmlBot;
    }
[download]

So it runs fine from the command line, but not anywhere else. I saw the FAQ at www.roth.net and I saw this question on here, but I didn't understand it very well. So please don't just copy and paste from the roth FAQ.

Comment on Win32::ODBC doesn't connect on browser Download Code

Replies are listed 'Best First'.
Re: Win32::ODBC doesn't connect on browser by andreychek (Parson) on Jun 30, 2001 at 06:06 UTC
Hmm... by any chance, do you have an error message you could paste into here? That might be helpful. Also, it looks like you are running on Windows. Do you know what web server you are running.. such as IIS or Apache? Lastly, do any other scripts on this server work when run by a browser, or is this the only one which seems to break? Thanks, -Eric Update: Okay, after reading that FAQ you refered to, I do understand the question they answered, assuming it is the same problem you are having. They say: When you create a DSN it is created under a particular account, which is not accessable from other accounts. If you are logged in as Administrator and you create a DSN called "Foo Database" then only processes running under the Administrator account can access "Foo Database". They claim the only two ways to fix this problem are to create the DSN as the user the web server runs as, or create a system DSN. Okay, so what does this mean for you? It sounds like creating a System DSN will be your best bet. The problem they are describing basically is saying that not every user has access to the DSN set up for your database. The DSN is basically a "pointer" that applications can use to find your database. A system DSN is one which is available to all users of your system. Do you have administrative rights to this web server? If so, make sure you have a System DSN set up for this database. You can find out by clicking Start->Settings->Control Panel->ODBC on your server. If you don't have administrative rights, talk to you administrator, and have him verify that he does indeed have a system DSN set up for you. If he doesn't, tell him to add one :-) Good luck!	[reply]
Re: Re: Win32::ODBC doesn't connect on browser by Anonymous Monk on Jul 03, 2001 at 02:02 UTC
Yeah, the problem described in the FAQ is exactly the problem that I'm getting. I already have a system DSN set up, called MyDSN. I checked for duplicate names, but still the same problem. The error that I'm getting is `.-1032[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet data +base engine cannot open the file '(unknown)'. It is already opened ex +clusively by another user, or you need permission to view its data.` [download] And it is running on Windows NT, IIS 4.0. And ActivePerl.	[reply] [d/l]