Home » Infrastructure » Windows » SQL Server error 7399 trying to connect to Oracle
SQL Server error 7399 trying to connect to Oracle [message #100731] Wed, 25 June 2003 04:49 Go to next message
David V
Messages: 2
Registered: August 2002
Junior Member
... Through OLEDB/ODBC

Has anyone experienced this problem?

Best Regards,

David.
Re: SQL Server error 7399 trying to connect to Oracle [message #100977 is a reply to message #100731] Tue, 09 March 2004 11:00 Go to previous messageGo to next message
Kenenth Christie
Messages: 1
Registered: March 2004
Junior Member
Did you ever get any replies to this or were you
able to resolve it yourself?
Re: SQL Server error 7399 trying to connect to Oracle [message #101004 is a reply to message #100731] Fri, 19 March 2004 20:30 Go to previous messageGo to next message
Sarabjeet Singh
Messages: 1
Registered: March 2004
Junior Member
yes, i am currently facing this issue while connecting to an orcale db from sql server as a linked server.
pls suggest a solution
sql ver 2000
oracle version 8.1.7

Awaiitng response
Re: SQL Server error 7399 trying to connect to Oracle [message #101015 is a reply to message #100977] Fri, 26 March 2004 06:06 Go to previous messageGo to next message
Ricardo Rendn Meza
Messages: 2
Registered: March 2004
Junior Member
I have exaclty the same problem :(...
...I will solve it TODAY.

Wait for an answer.
Re: SQL Server error 7399 trying to connect to Oracle [message #101018 is a reply to message #101015] Fri, 26 March 2004 13:21 Go to previous messageGo to next message
Ricardo Rendn Meza
Messages: 2
Registered: March 2004
Junior Member
Here is the solution, install latest MDAC, install Oracle client tools ()

http://otn.oracle.com/software/htdocs/devlic.html?http://otn.oracle.com/software/products/oracle9i/htdocs/winsoft.html
Re: SQL Server error 7399 trying to connect to Oracle [message #101225 is a reply to message #101004] Sun, 27 June 2004 01:46 Go to previous messageGo to next message
kamal
Messages: 12
Registered: February 2002
Junior Member
To work around this problem, follow these steps:
Log on to the computer by using the SQL Server start up account.
Create a folder named Temp in the operating system installation directory.
Permit full access to a non-administrator account on the Temp folder.
Set the value of the TEMP and TMP user variables of the SQL Server startup account to the newly created Temp folder. To do so, follow these steps:
Right-click My Computer, and then click Properties.
Click the Advanced tab, and then click Environmental Variables.
In the User variables for Logon User list, click TEMP, and then click Edit.
In theVariable Value box, type C:Temp as the location of the new Temp folder, and then click OK.
Repeat steps c and d to set the value of the TMP variable.
Click OK two times.
Log off, and then log on to the computer by using SQL Server startup account.
Restart the SQL Server services.
Re: SQL Server error 7399 trying to connect to Oracle [message #101228 is a reply to message #101225] Mon, 28 June 2004 02:18 Go to previous message
Brijesh
Messages: 8
Registered: January 2002
Junior Member
What Kamal is saying is bullshit, i have tried thsi option and i had to reinstall my windoews. It screwed up my system Insted of that create a new DSN and try.
Previous Topic: ORA-012541 TNS No Listener
Next Topic: create a process in Win2k
Goto Forum:
  


Current Time: Fri Mar 29 00:57:24 CDT 2024