> Yes, I've been abled to get at the data using Oracle tools and other
> applications designed to access the same data. Where do I go from here.
> The MS Knowledge Base also pointed to a possible SQL*Net problem, but I
> don't really know how to diagnose this. I don't even know what SQL*Net
> is.
ODBC is what Microsoft put together to help applications access data
using a common set of function calls.
As far as Oracle is concerned, ODBC can't get to the real data, but it
can get to the driver that gets to the data. And in doing so it can
pass the requests and the results back and forth. The driver that is
used in Oracle's case is SQL*Net. The connection works like this:
1 Application
| ^
V |
2 Request |
| |
V |
3 ODBC
| ^
V |
4 SQL*Net(client)
| ^
5 {Network (TCP/IP, or whatever)}
V |
6 SQL*Net(server)
| ^
| |
7 | Results
V |
8 Oracle RDBMS
Thus it is really SQL*Net that enables the data to get across the
network, not ODBC. You can use the SQL*Net tools to get to the data
from level 3 or 4 above, and this is a huge relief. This means that
it's a configuration thing with Visual FoxPro, rather than with SQL*Net
(and VFP is a _whole_ lot easier to work with).
Now my knowledge starts to wane. I've dealt with 2.6 getting to Oracle
quite a bit, but I've not yet tried to connect VFP to Oracle.
But since it's an ODBC problem, not an Oracle problem, there should be
others here that can help.
--
--
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