Hi all,
OK.... I wish to set up a linked server within MS SQL Server 2005 to access my PROGRESS DB for reporting purposes. The Linked Server will allow us to update the tables ect and then run our queries off of SQL Server.
Im having trouble in connecting to PROGRESS via SQL Server using ODBC and I was looking for advice
Here is what Im doing:
Right click on Server objects and select new linked server
Linked Server: PRO_SQL
Provider: Microsoft OLE DB Provider for ODBC Drivers
Product Name: MERANT 3.60 32-BIT Progress SQL92 v9.1D
Data Source: Linked_test
Provider String: DSN=linked_test;DB=Data1;UID=odbc;PWD=pass1234;HOST=reporttest;PORT=23400
Location: I HAVE THIS BLANK????
Catalog: I HAVE THIS BLANK????
The two last fields I have blank, is this the problem? what should go in there??
Here are the errors Im getting:
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access denied(Authorisation failed)".
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "PRO_SQL".
I have also tried it with another STRING and I get a separate error when I try and run a querry:
DRIVER={linked_test};UID=odbc;PWD=pass1234;DatabaseName=Data1;PORTNUMBER=23400;HOSTNAME=reporttest
Error:
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Error in Network Daemon".
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL".
As always any help greatly appreciated!
AK
OK.... I wish to set up a linked server within MS SQL Server 2005 to access my PROGRESS DB for reporting purposes. The Linked Server will allow us to update the tables ect and then run our queries off of SQL Server.
Im having trouble in connecting to PROGRESS via SQL Server using ODBC and I was looking for advice
Here is what Im doing:
Right click on Server objects and select new linked server
Linked Server: PRO_SQL
Provider: Microsoft OLE DB Provider for ODBC Drivers
Product Name: MERANT 3.60 32-BIT Progress SQL92 v9.1D
Data Source: Linked_test
Provider String: DSN=linked_test;DB=Data1;UID=odbc;PWD=pass1234;HOST=reporttest;PORT=23400
Location: I HAVE THIS BLANK????
Catalog: I HAVE THIS BLANK????
The two last fields I have blank, is this the problem? what should go in there??
Here are the errors Im getting:
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access denied(Authorisation failed)".
OLE DB provider "MSDASQL.1" for linked server "PRO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "PRO_SQL".
I have also tried it with another STRING and I get a separate error when I try and run a querry:
DRIVER={linked_test};UID=odbc;PWD=pass1234;DatabaseName=Data1;PORTNUMBER=23400;HOSTNAME=reporttest
Error:
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Error in Network Daemon".
OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "PRO_TO_SQL".
As always any help greatly appreciated!
AK