Question What it is wrong with my paradox files??

therealzeta

Member
Joined
Aug 9, 2008
Messages
19
Programming Experience
5-10
Hello, I need to link a paradox tables to a sql server. I use the following instrction to create the linked server, but I received this error.


VB.NET:
EXEC sp_addlinkedserver 'pdox',
'',
'MSDASQL',
'SMS'

EXEC sp_addlinkedsrvlogin 'pdox',
'false',
null,
'admin',
''

OLE DB provider "MSDASQL" for linked server "pdox" returned message "[Microsoft] [ODBC Paradox] The table has no external format expected.."
Mens. 7350, Level 16, State 2, Line 1
Unable to get the information column of OLE DB provider "MSDASQL" for linked server "pdox.

I also try to link this paradox tables in acces an and I received the same error. Can anybody tell me what is wrong with my paradox files?? I receive the same error on slq 2000, sql 2005 express and access 2003.

Thanx
 
Last edited by a moderator:
Back
Top