>
>I have been working on this all after noon, and still can't get it to work. Unfortunalty there is no example of exactally what I want to do, all the samels are for linking to another SQL server or linking to an Accessdata base.
>
>This is really wierd... If I use the View designer in Ent Manager I am able to drag the table from the linked server to the view. In the designer it creates a query like...
>
>With me putting a catalouge name into the linkedserver...
>
>SELECT eemast1.* FROM
>NJDATA.BOB. .eemast eemast1
>
>The table box in the designer doesn't have any of the field names listed. When I run this query I get the error message:
>
>OLE DB Provider 'MSDASQL' doesn't contain the table "'BOB'\'eemast'"
>
>*****************
>
>If I don't put a catalouge name when draging the table to the view designer I get a query like this...
>
>SELECT * FROM
>NJDATA.\\svrhomer\TotalHr\Data. .eemast
>
>Now, I do get all the field names in the designer. But, if I select to run the query I get....
>
>Syntax error in FROM calse near \.
>
>I tried to escape all the back slashes with a back slash but still get the syntax error.
>
>************
>I don't know how you got it to work... Did you use the VFP Driver with FREE tables.
>
>What version of the driver did you use?
>
>Do you have SQL7 SP1 ???
>
>Ug.. I really apreciate the help.
>
>BOb
Bob, no I was accessing VFP tables via the DBC, and yes I applied SP1. My Steps:
At the SQL Server Server machine:
Control Panel, define User DSN with ODBC manager dsn name=ecn
Linked Server, New Linked Server,...
Linked Server = ecnlinked
Provider Name = Microsoft OLE DB Provider fo ODBC Driver
Product Name = Visual FoxPro
Data Source = ecn <---- from above
Catalog = ecncatalog
[OK]
At workstation via ISQL/W or Query Analyzer
select * from ecnlinked.ecn..cstpart
Works for me.
Mike
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement