>
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only