Chris,
Can you elaborate a little further. If you are speaking of the System DSN setup, they are exact with the exception of the driver (name, port, server...etc.).
Jeff
Can you elaborate a little further. If you are speaking of the System DSN setup, they are exact with the exception of the driver (name, port, server...etc.).
Jeff
--- In vantage@yahoogroups.com, "redrhyno13" <cwineinger@...> wrote:
>
> Make sure you have the same ODBC settings in the 64bit ODBC and the 32bit ODBC on the 2008 server. Needs both to work.
>
> Regards,
>
> Chris Wineinger
> ERP Specialist
> Interior Systems, Inc.
>
> , "jplehr" <jlehr@> wrote:
> >
> > Anyone working with SQL Linked Servers to their OpenEdge DB?
> >
> > My scenario: Running SQL Server 2008; ODBC using x64 DataDirect (OpenEdge) Driver.
> >
> > When I test my Linked Server connection it verifies without problem. However, when I try to pull data the query runs and never completes. I am just trying to pull a simple test from the 'Customer' table.
> >
> > I have successfully done this from SQL 2000 and SQL 2005 Express.
> >
> > I am questioning if this is a 64 Bit issue.
> >
> > Anyone?
> >
> > Thanks, Jeff
> >
>