Re: Installing ODBC on Windows 95

Hey!

Yes, you are correct. You will need SQL*NET to connect with a unix oracle server. I did the same thing on a windows NT machine not to long ago. I used Oracle Client and it did everything for me. It will install in a directory called ORANT. One thing that you will need to know is the SID for the database that you are connecting to. This is done thru the Add Database Alias option that will appear during installation.. To someone who is somewhat familiar with Oracle it should be no problem getting it up and running. Yes, it does provide the ability to use Access with oracle. I do this on a daily basis and it works fairly well. The database I just designed had over half a million rows of data. ODBC seems to crash on data transfers of about 100,000 rows of data or more for some reason. Anything under that seems to work fine. By linking tables you have the ability to modify data residing on Oracle thru Access in realtime. This of course requires you to specify a key field when creating the link. Then of course you could import and export tables back and forth. I have also taken Excel spreadsheets into Access and then onto Oracle. Works great there also...

Good luck
Kevin

Ariel Kirson wrote:

> Hello all,
>
> My company works extensively with Oracle 7 running
> on various Unix-based machines. We would like
> to allow our end users to connect to our databases
> using their own third party tools and for this reason
> we would like to provide them with ODBC support
> at the time that we install our Client application on their
> PCs.
>
> What drivers, DLLs, files etc. do I need to install and where ?
> (I have been told that SQLNet is a must, how is this installed?)
> Is this task easily automated so as to allow for it's incorporation
> into our own installation scripts ?
> Where can I get detailed information on this topic ?
> Am I correct in assuming that installing ODBC will allow
> connection to our DB through Excel, Access etc. ?
>
> Thanks you for your time,
>
> Ariel Kirson
> Ex Libris.
Received on Tue Sep 29 1998 - 12:16:10 CDT