SQL Native Client And DATADIRECT Drivers

Hello,

I am having trouble with configuring a linked server in SQL 2005 Std SP2. (On Win2003 SP2 64bit)
i am linking to a PROGRESS db and here is an example of my connection string:
DRIVER={DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E};DSN=MyDsn;DB=MyDb;UID=UserName;PWD=;HOST=192.168.0.1;PORT=2501

I use the SQL native client provider. here is my error message:



OLE DB provider "SQLNCLI" for linked server "lk_server" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "lk_server" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 2, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [2].
OLE DB provider "SQLNCLI" for linked server "lk_server" returned message "Invalid connection string attribute".




The funny thing is if I use the same connection string with SQL 2005 Express SP2 (Win XP SP2 32bit ) I get my linked server to work and I am able to query the progress DB. Here's the twist. It will only work if I use OLE ODBC drivers for SQL. It even works if I don't specify a connection string and only give the DSN name.

But SQL Native Client is incapable of returning anything even on my SQL express install (Win XP SP2 32bit)
here is my SELECT statement:

SELECT * FROM OPENQUERY(LK_SERVER,'SELECT * FROM PUB.MYTABLE')


I would have no problems with using the OLE ODBC drivers for SQL in my SQL std. Trouble is, it's not available as a choice in the provider list on Win2003. I checked all the required services and made sure that I allow remote connections. But I always get the same error message.

I would appreciate if anybody could help me with this issue.


Thanks