Problems with MSSQL and Progress

arupi

New Member
Hello,
I'm new here in this forum and a newbie in Progress.

I want to read a table (Progress) copy data to MSQSQL table and after processing in MSSQL and MSAccess update the Progress table.

Environment:
Windows (Server 2003 and Windows7 both x64):
Progress we're using OpenEdge 10.1B ODBC driver x86 (pgoe1022.dll --> just this is usable for our ERP)
MS SQL server 2005 Express (x86)

T-SQL:
Connctionserver:
EXEC sp_addlinkedserver
@server = N'DBSRVREAD',
@srvproduct=N'Progress',
@provider=N'MSDASQL',
@datasrc=N'pA-Test_R'
GO
-->It works!
EXEC sp_addlinkedsrvlogin
@rmtsrvname = N'DBSRVREAD',
@useself = N'False',
@locallogin = NULL,
@rmtuser = N'username',
@rmtpassword = N'password'
GO
-->It works (no errors received, I cant' see anything)
select * from PUB.tablename
--> Error?? - (message 208, level 16, status 1, row 16 invalid objectname 'pub.tablename')

Is anybody out there to help me. Every description tells me, that it should work in this kind, but I can't see tables or something else.

Thanks
Best regards
Andreas
 
Top