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.
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
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: