> I have a view set up as a remote data source into an Oracle table. This
> view
> works great if I browse it from the project manager. On my old computer
> it
> even works great as a data source for a form.
>
> Just before it fails, the Oracle log-in screen pops-up. This is strange
> since
> I have built the username and password into the view definition.
>
> I've reloaded ODBC drivers from Oracle and from Microsoft. Nothing seems
> to kill
> this problem. I even checked today to see if the view still works on my
> old system.
> It does.
You installed the ODBC stuff; did you also install the SQL*Net stuff?
What about the network protocol stack (TCP/IP in most cases)?
Can you use the Oracle tools to see the data source? If so, then this
is a FoxPro <-> SQL*Net problem. If not, then it's a SQL*Net (locally)
<-> SQL*Net (server) problem.
--
--
Paul Russell
Software Kinetics Ltd. | Phone: (902) 481-4582 Fax: (902) 468-3679
201 Brownlow Avenue | Office: Paul.Russell@SofKin.ca
Dartmouth | "The best evidence that time travel will never
be
Nova Scotia, Canada | possible is that we have not been invaded by
B3B 1W2 | hordes of tourists from the future." - S.
Hawking
"Use technology because it's appropriate -- except in the case of 'Java'
then just use it 'cause it's cool!" - Paul Russell