C# Paradox Database odbc

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
I'm an amateur programmer and I have been using Delphi but want to start
using C#.

I need to connect to some existing Paradox database tables but I'm not
having any luck with it using VS 2005 Beta 2. I've searched with google and
on MSDN but still can't get it working.

I set up the connection using the wizards and in Server Explorer I can see
the table fields. If I do a SQL Query, I can see the data. The problem is
when I go to create a Data Source so I can use the data in a grid it doesn't
work, I get the following error with every table:
<'C:\DBTEST'..'MODULE'>
Error in SELECT clause: expression near '''.
Missing FROM clause.
Unable to parse query test.

I can't find where I would be able to modify these sql queries to try and
fix it. I've spent hours reading up on connecting with OLEDB or ODBC but
haven't been able to get it working. Any suggestions? Thanks.

Regards-Michael G.


.

Relevant Pages

  • Re: C# Paradox Database odbc
    ... "Could not find installable ISAM" when I try and test the connection. ... If I do a SQL Query, ... > Error in SELECT clause: ... > Unable to parse query test. ...
    (microsoft.public.data.odbc)
  • Re: Error 1541 - connection busy
    ... Any comment on my questions about the SHARE clause? ... > the connection is not busy, which may be just a micro second longer. ... > Microsoft FoxPro Technical Support ... Some views were created in the view designer, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Reusing the result of an expression in select query
    ... Orlando Amador schrieb: ... This has created a very big SQL query. ... Looks like With clause is for 10.2? ... Any suggestions for Oracle 9? ...
    (comp.databases.oracle.server)
  • Re: Reusing the result of an expression in select query
    ... DA Morgan wrote: ... This has created a very big SQL query. ... Looks like With clause is for 10.2? ... Any suggestions for Oracle 9? ...
    (comp.databases.oracle.server)
  • Re: Change query from application on the fly?
    ... I build the SQL query and pass it to the Crystal ... What happens when you use parameters in the where clause? ... options in the the report options. ... overwrite the command though. ...
    (microsoft.public.vb.crystal)