Search results

UPDATE I have found that if right after opening SSMS I run a select query that references the linked server, it runs and returns results. Then if I try to expand the linked server node, everything works fine. If I try to expand the linked server node before doing the select query, it locks up.

Well it worked right after I added the environment variable. I then tried restarting SSMS and the same problem is back. Go figure...... :furious:

I think I have found the answer! I found this and it works! The "DataDirect 4.20 32-BIT OpenEdge SQL v10.0B" ODBC driver that we are using comes with the Progress 10.0B CD that we have purchased, for the ODBC drivers that come with Progress 10.0B, they are not Unicode compliant yet (noted...

I am having a similar problem with SQL Sever 2005 Management Studio. I am using SQL Server 2005 with SP2 installed. I have a linked server setup in SQL 2000 using the OE10.1B ODBC driver and it works fine. I try to do the same in SQL 2005 it seems to work fine as testing the connection...