Re: Need Help with PO7 ODBC on Windows 95

Wallace Jones wrote:
> =
 

> I have been trying to set up Personal Oracle 7 for Windows 95 on my
> standalone machine. I can get the database up and running just fine,
> but I can=92t attach Microsoft Access 2.0 tables using the ODBC. I have
> tried the following to setup the ODBC:
> 1 - After I setup the ODBC Data Source (I selected Oracle as the
> ODBC Driver and used "2:" in the Network Address field) it gave me an
> error "CONFIG environment variable not found. SQL*NET must be installed
> for the Oracle connection to function". I=92m not using a remote databas=
 e
> so I have no idea what protocol to use (TCP/IP? SPX? or Named Pipes?) ,
> also how do I start the listener in order for SQL*NET to work?
> 2 - I dialed into www.oracle.com and downloaded their latest
> Windows 95 ODBC driver. It is the same version that I already have.
> =
 

> Can anyone give me some ideas about what I=92m doing wrong, or where =
 I
> can get a Windows 95 driver that will run on a local database.

 I have set up my dialup adapter with TCP/IP protocol and assigned myself a= n ip address (this caused a problem when I dialed into my IPS). =

 Then, I installed SQL*Net and chose the TCP/IP as the protocol to be used.=   Using the Easy config, I have created and alias (which you =

provide the IP address that you have assigned to your machine). On the ODB= C driver, I have used this alias name and it worked! Another =

thing that you can do is, instead of permenantly assigning yourself an IP a= ddress, you can dial into your ISP and you will be assigned an =

IP addres. After you get connected, go to start and then run the following=  program with the following option "NBTSTAT -N". This will =

tell you your IP address. Run easy config, change your IP address for the = alias in question. Then run "LSNRCTL" listener control and =

stop the listener and start it again. By doing this you can be on line on = the internet and use SQL*net at the same time!!!

I hope this helps....

Hakan Egeli
hegeli_at_ix.netcom.com Received on Fri Aug 16 1996 - 00:00:00 CEST