Re: Connecting oracle- access

still having problems here.

I think my problem may be related to not having the driver in my path, at dos prompt
path does not include c:\orawin95 (my personal oracle location)

Being a previous win3.1 dos user I thought adding the path to my autoexec.bat file would do the trick but under w98 autoexec.bat only seems to affect my path when I boot into dos. I am now hitting a total mental blank, tried win help files etc, suspect it must be a win registry setting, really how no idea now, any suggestions??

I found the odbc driver on technet.oracle (10 meg, suprisingly large) and will try that after I get the path thing sorted out.

Mat

BARRIE TAYLOR wrote:
>
> hmm been playing around with this for a while now and keep hitting
> 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 17 2000 - 00:34:17 CET