<div>
&gt;&gt; syntax for the linked server<br />
<br />
Do it in steps so you can verify what works and what doesn't.<br />
<br />
1. Connect from within ODBC manager and test that it works<br />
2. Create a blank file called with an extension of .UDL, double click it, select your DSN from step one, fill in the details and test it.<br />
3. Open your UDL file in notepad - there's your connection string (the second line)<br />
<br />
<br />
<br />
&gt;&gt;&nbsp;confirm I am unable to use MS SQL 2005 because the DataDirect driver is a 32 bit driver?<br />
<br />
As long as SQL 2005 is the 32 bit edition then it should be fine. <br />
<br />

</div>


<div>
Well I successfully completed 1-3. &nbsp;Here is my provider string:<br />
Provider=MSDASQL.1;Persist<wbr /> Security Info=False;User ID=sysprogress;Data Source=Suncoast ODBC<br />
<br />
So i tried this:<br />
<br />
exec sp_addlinkedserver @server = 'TEST8' , <br />
@srvproduct = 'MSDASQL',<br />
@provider = 'MSDASQL.1;Persist Security Info=False;User ID=sysprogress;Data Source=Suncoast ODBC', <br />
@datasrc = 'Suncoast ODBC', <br />
@location = 'crash3',<br />
@catalog = 'production'<br />
<br />
EXEC sp_addlinkedsrvlogin 'TEST8', 'false', null, 'SYSPROGRESS', 'password'<br />
<br />
I get an error: &nbsp;The OLE DB provider &quot;&quot;&nbsp;has not been registered.<br />
<br />
Please help
</div>


<div>
That worked. &nbsp;Thanks a bunch! &nbsp;The UDL syntax did not work but I was able to find the correct string.<br />

</div>


<div>
<div class="content wysiwyg-content">
I am trying to set up an MS SQL Linked Server to a Progress 9.1E database using a DataDirect 4.10 odbc driver. &nbsp;I am having trouble with the syntax for the linked server. &nbsp;Can someone assist me?<br />
<br />
I also want to confirm I am unable to use MS SQL 2005 because the DataDirect driver is a 32 bit driver?
</div>
</div>


I am trying to set up an MS SQL Linked Server to a Progress 9.1E database using a DataDirect 4.10 odbc driver.  I am having trouble with the syntax for the linked server.  Can someone assist me?

I also want to confirm I am unable to use MS SQL 2005 because the DataDirect driver is a 32 bit driver?

SQL Linked Server to Progress 1.9E database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.