SQL Server Management Studio and OpenEdge

vantage@yahoogroups.com wrote:
> 64-bit or 32-bit O/S?

32-bit 2008 Server.

I just got it. You have to click on the Security Tab (SSMS 2008) and put in
the username and password for the ODBC connection.

<sigh>

Thanks!!!

Mark W.
I created a System DSN (Read Uncomitted) for my Epicor 9 database and I can
test the connection with no problem. Now I want to create a Linked Server in
SQL Server Management Studio so I can write a Stored Procedure against it
but I cannot get the Linked Server to connect for the life of me. I get
various errors including "OLE DB Provider not registered" or feature not
implemented depending on what I do.

Anybody have any luck doing this?

Thanks!

Mark W.
64-bit or 32-bit O/S?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Monday, August 03, 2009 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Server Management Studio and OpenEdge





I created a System DSN (Read Uncomitted) for my Epicor 9 database and I
can
test the connection with no problem. Now I want to create a Linked
Server in
SQL Server Management Studio so I can write a Stored Procedure against
it
but I cannot get the Linked Server to connect for the life of me. I get
various errors including "OLE DB Provider not registered" or feature not
implemented depending on what I do.

Anybody have any luck doing this?

Thanks!

Mark W.





[Non-text portions of this message have been removed]