im showing data in gridview from access database .
Problem is tables in mdb file are linked to some Visualfoxpro dbf files.Below How It look like ,it works in LocalServer but not in Remote Server.Any Ideas???????Error Comes As: Server Error - CouldNot Execute Query Could Not Link To the Table
developer27
Member
396 Points
205 Posts
How To Connect to linked table in MS Access
Apr 25, 2011 10:32 AM|LINK
im showing data in gridview from access database .
Problem is tables in mdb file are linked to some Visualfoxpro dbf files.Below How It look like ,it works in LocalServer but not in Remote Server.Any Ideas???????Error Comes As: Server Error - CouldNot Execute Query Could Not Link To the Table
<
asp:AccessDataSource ID="AccessDataSource1" runat="Server" DataFile="~/PR2.mdb"SelectCommand
="SELECT * FROM m1 WHERE idnumb = @idnumb">
<SelectParameters>
<asp:Parameter Name="idnumb" /> </SelectParameters>
</asp:AccessDataSource>hans_v
All-Star
35986 Points
6550 Posts
Re: How To Connect to linked table in MS Access
Apr 25, 2011 07:28 PM|LINK
That meand that the drivers need to be installed on the server. And are you sure that the path to the dbf files in the linked tables are OK?
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: How To Connect to linked table in MS Access
Apr 27, 2011 01:42 AM|LINK
Hi：）
Besides what hans_v said, have you confirmed that your VisualFoxPro's files' links are valid, Can your programm find them through these links?
Thx again