July 27, 2005 at 4:28 am
Hi, could anyone shed any light on this error msg I am receiving. I can only assume it is to do with permissions.?
---
EXEC sp_dropserver 'OPERA_SERVER'
EXEC sp_addlinkedserver
@server='OPERA_SERVER',
@srvproduct='',
@provider='VFPOLEDB',
@datasrc='c:\temp\Comp_W.dbc'
Select * From OPERA_SERVER...ssale
---
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'OPERA_SERVER' does not contain table 'ssale'. The table
either does not exist or the current user does not have permissions on that table.
---
The VB ADO string I used to connect previously is this:
OperaConn.ConnectionString = "Driver=Microsoft Visual Foxpro Driver; UID=; SourceType=DBC; SourceDB=c:\temp\Comp_W.dbc"
July 27, 2005 at 4:34 am
Sounds like permissions alright. Research sp_addlinkedsrvlogin to add credentials for who the linked server should connect as...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
July 27, 2005 at 5:13 am
Not permissions, just me being an arse.
Failed to copy ALL required files to testing directory. Did that and all works fine.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply