Re: Problem using FoxPro OLE DB Connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dave Anderson (GTSPXOESSGOQ_at_spammotel.com)
Date: 01/08/05 

Date: Fri, 7 Jan 2005 21:58:13 -0600

Dr. Know wrote:
> The wizard creates this connection string:
> (which differs little from my original string)
>
> Provider=VFPOLEDB.1;Data Source=C:\DB2\DDMS;Password="";Collating
> Sequence=MACHINE
>
> It tests OK in the wizard, but refuses to work in ASP - although it
> and my original string work in VBA. Alternate DB formats, such as
> MDB, also work fine...

We had a similar problem with Oracle drivers above 9i, and the solution
involved propagating permissions in the Oracle directory structure. The
problem in that case was that IIS runs under a system account whose
permissions are either not set up correctly by the Oracle installation, or
were altogether nonexistent.

If I had to guess at this point, I'd say you have a file permission problem. 

-- 
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

Relevant Pages

  • Re: Imported text converts to dates!
    ... How do you import it, if it is a txt file the text import wizard should open and you can click next twice and under column data format select text and it will come in as txt, if not imported as txt file rename it to *.txt and it will trigger the text import wizard ... I want to keep the original string. ... I just can't find anything in Options, and Web Query Options dialog box doesnt have anything about importing data. ...
    (microsoft.public.excel)
  • Re: Oracle accent
    ... I modify the number of byte the problem is resolved. ... possible to format the string before inserting into oracle and not ... If you are looking for a way to remove special chars, ... original string holds. ...
    (comp.databases.oracle.misc)