I am an Access and SQL Server developer. I need to bring print
accounting from 3 different applications including a Topspeed database
into SQL Server for consolidation and reporting.
I bought Topspeed ODBC drivers over the weekend and received the
downloads today.
I have set up an ODBC DSN:
I am now able to see tables and query data in Excel:
Although I'm having trouble withthe SQL syntax - just using trial and
error, I am able to work out the structureof the database.
I'm having less success with SQL Server.
I'm trying to set up a linked server:
/****** Object: LinkedServer [DRPRO] Script Date: 03/03/2008
18:37:19 ******/
EXEC master.dbo.sp_addlinkedserver @[EMAIL PROTECTED]
= N'DRPRO', @[EMAIL PROTECTED]
=
'', @[EMAIL PROTECTED]
'MSDASQL', @[EMAIL PROTECTED]
'DRPRO'
/* For security reasons the linked server remote logins password is
changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin
@[EMAIL PROTECTED]
'DRPRO',@[EMAIL PROTECTED]
'False',@[EMAIL PROTECTED]
I can't query any tables
SELECT * FROM DRPRO...CAPACITY
Returns the error
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "CAPACITY". The OLE DB provider "MSDASQL"
for linked server "DRPRO" indicates that either the object has no
columns or the current user does not have permissions on that object.
Any suggestions or references?
Thank you
Stephen Solt
Planchest Ltd
|
