I have a pretty plain vanilla Perl script where I try to connect to a FoxPro database via Microsoft Visual FoxPro driver. My Foxpro server is on a different machine than my web server, where my Perl script is. When I try to run it, I get "Cannot Connect." When I put the Foxpro data on the same server as my Perl script, then it works. It also seems to work from the DOS command line. Only when I am running the Perl script from my browser do I get the "Cannot Connect" message. My FoxPro DSN uses a UNC path to point to the FoxPro data. I can read and write to this data server from my web server, having browsed to it and entered the necessary network user id and password. Any suggestions would be helpful... thanks, bill chicago,il

In reply to ODBC Cannot Connect by roscomputing

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.