Re: personal oracle net80 connect string; access

Thanks for response - I solved problem (based on advise from other newsgroup) - used beq-local from tsnames.ora as service name rather than 2: This works.

Regards, John

Mark Gornicki wrote in message <7g7vo6$tnr$1_at_news4.svr.pol.co.uk>...
>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 - 18:51:19 CDT