Connecting oracle- access
Date: Fri, 10 Mar 2000 19:13:09 +1000
Message-ID: <Pine.OSF.4.21.0003101912060.25213-100000_at_student.uq.edu.au>
hmm been playing around with this for a while now and keep hitting [Quoted] roadblocks....
I am running Personal Oracle 7.3.4.0.0 (windows version) on win98, and MSAccess 97.
I have previously been able to do a JDBC connection to a MSAccess database but am still fairly new to using ODBC/JDBC connections. (used the Bakery example on the sun java website)
I've been using an example provided by
http://www.netdynamics.com/support/manuals/nd30/database/
to get access - oracle to link together. I'm sure I've missed a step
somewhere so please feel free to jump in ....
following the steps from the link above... (my screen looks a bit different to the pics on the www page, suspect it must be w95)
control panel > 32 bit ODBC >
select System DSN panel,
if I try the intersolve 2.12 32 bit Oracle 7 driver, I get "setup routines
for .... ... could not be loaded due to system error code 1114", then
"could not load the setup or translator library"
I assume this means I havent got the driver loaded or located correctly... trying again, using the "Oracle73 ver 2.5" driver that appears in my selection box...
Now I enter the following
Data Source Name:MyNewTest
Description:some description
SQL Net Connect String: 2:
UserID: internal
MyNewTest = some name I make up to label the data source.
some description ...
2: = help tells me that I can enter "2:" here to connect to personal
oracle.
UserID: I'm not sure what to put here... At the moment I haven't been
mucking around with creating new users and tablespaces in oracle, just
using the default username "internal" when accessing Oracle Sql plus, so I
assume the oracle username is appropiate (??)
I'm pretty sure my problems are somewhere in the issue above, but anyway
the rest is...
open a new blank access database
file> get external data > link tables
select files of type "ODBC"
then presented with panels
"File Data Source" with green round icons for connections that are
available, nothing here that is oracle or my creation from above.
"Machine Data Source" panel,
selecting "MyNewTest" then results in ODBC call failed.
What doesnt make sense is that in the access connection I have to nominate the access file containing the database, seems strange the equivalent information is not required by the method I described above.
Any ideas?
Mat
s176226_at_student.uq.edu.au
Matthew Taylor
ph 0417 833 021 icq 59036149 Brisbane Australia
Received on Fri Mar 10 2000 - 10:13:09 CET