Hi Stephen,
Try the news.softvelocity.com newsgroup. There is a lot more activity on
that one.
--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)
<stephen.solt@[EMAIL PROTECTED]
> wrote in message
news:fe286688-de47-4e06-95b8-a629e8a11680@[EMAIL PROTECTED]
>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 re****ting.
>
> 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]
>
> But 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
|
