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!

In reply to Re: Win32::ODBC doesn't connect on browser by andreychek
in thread Win32::ODBC doesn't connect on browser by ckim06

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.