On Sun, 28 Mar 1999 17:26:10 GMT, nbcouch_at_envisionet.net (Nicholas
Couch) wrote:
> We use Oracle ODBC quite a bit, under Win95 and NT4, with MS Access
> front-ends. One common problem I've run into is SQL*Net not being
> set up properly. Make sure you can ping the host name you've used
> in the database alias. Be certain you've got the correct database
> instance. In the ODBC setup, make sure you've used the SQL*Net
> database alias as your connect string.
Perhaps I should've mentioned this in my previous message. It's
not quite that simple. Using the Oracle 7 ODBC driver...
- connect
- get a list of tables in Access or Excel
- choose a table
- table opens
and I see the rows and columns I expect... except that every last
single value in every row and column is "#ERROR". The Intersolve
driver has a bunch of "Workarounds" entries that have to be made
manually in the registry (ugh). But at least it works.
The good news is that this problem with Oracle 7 might be moot.
After a couple of weeks of fiddling around with an Oracle 8 install
that GPF'd when I clicked the "Install" button, I bit the bullet.
I formatted my C: drive at work, marked all other partitions hidden,
and re-installed Win95. Then I installed the Oracle 8.0.4 client
(and 8.0.4.0.3 patch) and ODBC with no problems at all. And the
the bleeping thing actually works all around! It looks like Oracle
may have solved the issues they had in the Oracle 7 ODBC driver. I
can access our Oracle 7 databases, both with PL/SQL and ODBC from
Access/Excel. I'll stick with it for now, and be a few months
ahead of other people when we cut over to Oracle 8 for Y2K reasons.
I only did the first ODBC connect on Monday morning so I don't
have an absolute guarantee that it works. One booby-trap I noticed
is that if you have a read-only account on a database, do *NOT*
check the "read-only" tick-box in the Oracle 8 ODBC configuration.
Weird error message results.
While I'm talking Oracle 8 ODBC config... does anybody have any
guidelines on how much memory overhead is involved with the
"pre-fetch" option in ODBC config? I have 32 maegs of RAM on my
work machine.
--
Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter
http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm
Why a fiscal conservative opposes Toronto 2008 OWE-lympics
http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htm
Received on Tue Mar 30 1999 - 05:39:12 CST
