Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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,

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

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://92863]
[Corion]: Weird - this "Install our backdoor SDK" spam is persistent. And I get the feeling it's not even automated, as it seems to be a re-forward of each mail, maybe even manually. Ah well, a quick rule in Thunderbird will move them to Spam automatically now :D
[Corion]: (the "backdoor SDK" is for distributing my software with an included backdoor, not for backdooring my own machine)
[marto]: ask for a trial
[marto]: then trick them into running your app
[marto]: once you have access, remove your email address from their system :P
[shmem]: why just that email address? why filtering?
[Corion]: shmem: I use email for contact, so I'd still like to receive emails from other people. Hence, I filter my email.
[Corion]: marto: Sneaky :) But I think I don't want to even give them the impression that anybody reads their mail :)

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (8)
As of 2018-05-25 14:05 GMT
Find Nodes?
    Voting Booth?