Paradox Database Connection

[Michael Gerbasio]

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 C# 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.

If I try and create a TableAdapter I get the following error:
An unexpected error has occurred.
Error Message: ERROR [HYC00][Microsoft][ODBC Paradox Driver] Optional
feature not implemented.

If I try and create a data server using OLEDB, I get a error message saying
"Could not find installable ISAM" when I try and test the connection.

I think I'm close as I can connect to the database and view the data, I just
can't seem to get it in a container I can use in the program. I'm really
lost and even just a point in the right direction, a web page, book anything
would be helpful. Thanks.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

try to run a query ( using Command.ExecuteReader ) using ODBC to connect.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Michael Gerbasio" <mw********@hotmail.com> wrote in message
news:uT**************@TK2MSFTNGP09.phx.gbl...

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 C# 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.

If I try and create a TableAdapter I get the following error:
An unexpected error has occurred.
Error Message: ERROR [HYC00][Microsoft][ODBC Paradox Driver] Optional
feature not implemented.

If I try and create a data server using OLEDB, I get a error message
saying "Could not find installable ISAM" when I try and test the
connection.

I think I'm close as I can connect to the database and view the data, I
just can't seem to get it in a container I can use in the program. I'm
really lost and even just a point in the right direction, a web page, book
anything would be helpful. Thanks.

[D. Yates]

Michael,

As a Delphi programmer that made the move to C# a couple of years ago (I
still do some work in Delphi 7), I hate to suggest it, but you might also
consider converting your Paradox tables into MS Access tables. The MS
Access program can easily import and convert them to the mdb format.

Dave