Problem connecting linked server sql server 2008 using progress merant driver 3.60

[kkmickey]

Hi:

I don't even know if this is possible or not. I am trying to create a linked server to access progress database. The sql server is 2008 r2 (64 bit version) and progress database is using merant driver 3.60. (32 bit version)

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "xxx".
OLE DB provider "MSDASQL" for linked server "xxx" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)

I received this error. Even though I specify the dsn.

Product Name: MERANT 3.60 32-BIT PROGRESS
Data Source: xxx (Data source name in odbc administrator)
Provider: Dsn=xxx;databasename=xxxx;uid=xxxx;pwd=xxxx
Location: Blank
Catalog: (Database Name)

Any idea.

Thanks,
kkmickey

 

[Stefan]

Re: Problem connecting linked server sql server 2008 using progress merant driver 3.6

You cannot use a 32-bit ODBC driver as a linked server from a 64-bit SQL Server.

See Progress Knowledge base P172200.

Alternatively you could tried the first Google hit on search x64 sql server linked server odbc 32-bit

 

[kkmickey]

Re: Problem connecting linked server sql server 2008 using progress merant driver 3.6

Thanks for the reply. I don't have to waste my time on it.