Re: personal oracle net80 connect string; access

Hi,

i don't know if this is your problem but you might need to start the database listener service on your pc to connect to it.

How it work is that tools like SQL*PLUS can connect through default SID without specifying it but for some other circumstances, mine were connecting the older tools to PO8 you need the listener.

Requirements
1. create a fixed ip address in the c:\windows\hosts file (there should be a hosts.sam file you can copy) and allocate an alias 2. use the net8 easy config to create an entry for your database i assume ORCL - check your $ORACLE_HOME\network\admin\tnsnames.ora it may already have an entry.
3. from the command line run the following :

     lsnrctl80 start
4. now try connection

i hope it helps
Mark

John Tannahill wrote in message ...
>I am having similar problem trying to use ODBC driver have tried:
>- blank
>- 2: (for loopback)
>- 2:ORCL (default SID)
>- t:ORCL (tcp/ip)
>but not having any success and cannot find anything in Oracle 8
>documentation about the connect string.
>
>Regards, John
>Farnk Habets wrote in message <7g4iul$70f$1_at_gps4.ndhq.dnd.ca>...
>>
>>I get the error message 'invalid net string!'.
>>
>>I go through the documentation, but I can't find ANY examples of what the
>>string should look like.
>>
>>Would someone PLEASE (I ask pleadingly) tell me how these connect strings
>>work????????
>>
>>
>>
>>In article <3725A490.18505E92_at_vnl.nl>, f.van.bortel_at_vnl.nl says...
>>>
>>>IF you used a default installation with database, you can leave this
empty
>>>
>>>freeed wrote:
>>>
>>>> I'm a newbie at this, so please bear with me....
>>>>
>>>> When migrating an access database to personal oracle, the last screen
>asks
>>me
>>>> for to 'enter the Net8 connect string for Oracle8'.
>>>> (The database will be sitting on my C drive)
>>>>
>>>> What do I put there?
>>>> Please help! My job depends on this!
>>>
>>>--
>>>Met vriendelijke groet,
>>>kind regards,
>>>
>>>Frank van Bortel
>>>Technical consultant Oracle
>>>V&L Informatica BV
>>>-----------------------------------------------
>>>Work Home
>>>Postbus 545 Hunzestraat 4
>>>7500 AM Enschede 7555 WB Hengelo
>>>(31)53.434.1500 (31)74.242.5046
>>>
>>>
>>
>
>
Received on Wed Apr 28 1999 - 16:50:40 CDT