Re: Connecting Oracle 19 to SQL Server Issue

Actually, that's a complete lie. I use the FreeTDS driver from the EPEL repository, so I am using an "SQL Server" driver.

Ignore me! :)

Cheers

Tim...

On Wed, Aug 14, 2019 at 8:01 AM Tim Hall <tim_at_oracle-base.com> wrote:

> Hi.
>
> I know you've already figured it out, but as a general rule, whenever I
> have a problem with this, I've always forgotten something, or screwed
> something up. I step through the setup steps, find my mistake, and it just
> works.
>
> I was a little confused by the mention of an SQL Server driver. I just use
> a straight ODBC on on Linux.
>
> https://oracle-base.com/articles/linux/create-an-odbc-dsn-on-linux
>
> I'm wondering whether your comment relates to you being on Windows maybe?
>
> Cheers
>
> Tim...
>
> On Tue, Aug 13, 2019 at 3:28 PM Scott Canaan <srcdco_at_rit.edu> wrote:
>
>> Ok, one of my co-workers figured this out. Apparently, dbua removed an
>> entry from the tnsnames.ora file that specified the port to listen on for
>> the ODBC connections. Once that was restored, all is working as it should.
>>
>>
>>
>> *Scott Canaan ‘88*
>>
>> *Sr Database Administrator *Information & Technology Services
>> Finance & Administration
>>
>>
>> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>>
>> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>>
>> *CONFIDENTIALITY NOTE*: The information transmitted, including
>> attachments, is intended only for the person(s) or entity to which it is
>> addressed and may contain confidential and/or privileged material. Any
>> review, retransmission, dissemination or other use of, or taking of any
>> action in reliance upon this information by persons or entities other than
>> the intended recipient is prohibited. If you received this in error, please
>> contact the sender and destroy any copies of this information.
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Scott Canaan
>> *Sent:* Tuesday, August 13, 2019 9:06 AM
>> *To:* 'oracle-l_at_freelists.org' <oracle-l_at_freelists.org>
>> *Subject:* Connecting Oracle 19 to SQL Server Issue
>>
>>
>>
>> I just upgraded an Oracle database from 12.1.0.2 to 19. Now the
>> connections via the heterogeneous connections don’t work. I’ve copied all
>> of the .ora files into the new $ORACLE_HOME/hs/admin directory. I’ve
>> updated the listener.ora file to use the new 19c Oracle home and restarted
>> the listener.
>>
>>
>>
>> I did not have a new SQL Server ODBC driver installed. From what I can
>> see that hasn’t changed, the most recent one is “ODBC Driver 17 for SQL
>> Server”. If there’s a newer one, I can’t find it.
>>
>>
>>
>> When I do a tnsping, I get “TNS-12541: TNS: no listener”, but there is a
>> listener. I can see the entries when I do a status.
>>
>>
>>
>> What have I missed? Obviously there’s something.
>>
>>
>>
>> *Scott Canaan ‘88*
>>
>> *Sr Database Administrator *Information & Technology Services
>> Finance & Administration
>>
>>
>> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>>
>> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>>
>> *CONFIDENTIALITY NOTE*: The information transmitted, including
>> attachments, is intended only for the person(s) or entity to which it is
>> addressed and may contain confidential and/or privileged material. Any
>> review, retransmission, dissemination or other use of, or taking of any
>> action in reliance upon this information by persons or entities other than
>> the intended recipient is prohibited. If you received this in error, please
>> contact the sender and destroy any copies of this information.
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l