Hello -
First time post and I'm pulling my hair out. I've already searched many posts but found no luck.
OS: Windows 2003 x64
DBMS: SQL Server EE 64-bit
System DSN: DATADIRECT 4.10 32-bit Progress SQL-92 v9.1E
I made the System DSN using the 32-bit ODBC Admin tool found in WOW. And the Test Connection is successful everytime. No issues.
But for the life of me I cannot get SQL 2005 to recognize the driver. I know that Microsoft did away with the 64-bit MSDASQL.dll, but there HAS to be a way to connect to Progress via SQL 2005 Linked Server or OPENROWSET, etc. MSDASQL is not available and there's no other Provider in the SQL 2005 Provider list under Linked Servers folder that seems applicable. I've tested this in SQL 2005 32-bit with no issues.
Do I need to upgrade the DATADIRECT driver to 64-bit? Am I missing a step here?
Thanks for any help!
Andy
MCDBA
First time post and I'm pulling my hair out. I've already searched many posts but found no luck.
OS: Windows 2003 x64
DBMS: SQL Server EE 64-bit
System DSN: DATADIRECT 4.10 32-bit Progress SQL-92 v9.1E
I made the System DSN using the 32-bit ODBC Admin tool found in WOW. And the Test Connection is successful everytime. No issues.
But for the life of me I cannot get SQL 2005 to recognize the driver. I know that Microsoft did away with the 64-bit MSDASQL.dll, but there HAS to be a way to connect to Progress via SQL 2005 Linked Server or OPENROWSET, etc. MSDASQL is not available and there's no other Provider in the SQL 2005 Provider list under Linked Servers folder that seems applicable. I've tested this in SQL 2005 32-bit with no issues.
Do I need to upgrade the DATADIRECT driver to 64-bit? Am I missing a step here?
Thanks for any help!
Andy
MCDBA
