What to Use for Server Name on Oracle Connection

From: stevebell821 <u34924_at_uwe>
Date: Sun, 10 Jun 2007 15:02:18 GMT
Message-ID: <7374ed6665dcb_at_uwe>

[Quoted] I am trying to use the Microsoft OLE DB Provider for Oracle to establish a connection to an Oracle database. When using this provider the Data Link Properties dialog box prompts me for a server name. I have been entering the server name as the "alias" for that instance of Oracle that is defined in the tnsnames.ora file. However, this does not work. Is the alias the proper thing to be entering into this field? When I click on Test Connection, the error I get is a timeout.

[Quoted] To describe the situation a little more completely: I am attempting to connect to an Oracle server at work from home. We have to VPN into the work network (which is happening with no problem). It is at this point that I am attempting to establish the connection to the Oracle server.

[Quoted] I've also attempted the same thing from my computer at work (again supplying the alias as the server name) and there I get an error saying the TNS could not resolve the server (even though other applications are able to do so).

[Quoted] Any guidance would be helpful and appreciated. I am a SQL Server programmer and it all "just works" and I am not very familiar with the Oracle world (can you tell?).

-- 
Steve Bell
Liberty Software Solutions
steve_at_liberty-solutions.com

Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle-tools/200706/1

Received on Sun Jun 10 2007 - 17:02:18 CEST