Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Win32::ODBC doesn't connect on browser

by andreychek (Parson)
on Jun 30, 2001 at 06:06 UTC ( #92863=note: print w/ replies, xml ) Need Help??


in reply to Win32::ODBC doesn't connect on browser

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!


Comment on Re: Win32::ODBC doesn't connect on browser
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.
    And it is running on Windows NT, IIS 4.0. And ActivePerl.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://92863]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (8)
As of 2014-08-29 23:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (289 votes), past polls