Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Bhavbhuti Nathwani
  Where is Bhavbhuti Nathwani?
 Rajkot
 India
 Bhavbhuti Nathwani
 Tags
Subject: RE: ODBC returns 'not a table' error
Thread ID: 268968 Message ID: 269128 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Friday, July 16, 2010 12:58:59 PM         
   


> I am not sure if Report Manager will use OLE DB. I use "Microsoft DAO" and then provide "Provider=MSDASQL.1;Persist Security Info=False;Data Source=C18_Temp_2442" such a string to it for DSN connection for development purposes. At runtime I pass a connect string to Report Manager's ActiveX component something like
>
> Never used OLE DB before so will "Microsoft DAO" be able to handle this in Report Manager. Can I have the OLE DB equivalent of DNS and DSN-Less connections?
>
> Thanks for the Advantage Database Server suggestion will keep it in mind to later try if requried.
>
> Please advise
>
> Thanks and regards
> Bhavbhuti

You confused me:) It is DAO or ADO? And you are already initially using OLEDB in report manager but using "Microsoft OLEDB Provider for ODBC" MSDASQL as the provider and then add VFP ODBC connection. Why don't you simply use VFPOLEDB instead of MSDASQL? Something like:

"Provider=VFPOLEDB;Data Source=c:\My FreeOrDatabaseTablesFolder\"

Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)

ENTIRE THREAD

ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/15/2010 6:17:40 PM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/15/2010 10:19:18 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 7:16:02 AM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/16/2010 12:58:59 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 2:11:21 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 5:19:19 PM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/16/2010 10:28:52 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/17/2010 6:40:04 AM