I am writing an application in vb.net 2005 to insert/update/select data to
paradox database file(.db---bde 5.01)
1)what is the best way to go about it?
Note:
I have tried to connect to paradox database via odbc or oledb
a)Dim odbcconnstr As String = "Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox
5.X;DefaultDir=I:\pardoxData;Dbq=I:\pardoxData\;Co llatingSequence=ASCII"
b)Dim oledbconnstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=I:\pardoxData;Extended
Properties=Paradox 5.x;"

The problem with (a)odbc.net is unable to select data from memo/blob field.
the application is crashing

The problem with (b)oledb is : select query returning wrong results.for instance,follwing
query(exact case) dispalying correct results.
select * from mytable where firstname='JOHN'

however, following query(lower case) displaying all the records firstname
starts with 'j' or 'jo' or .....
select * from mytable where firstname='john'

thanks in advance
vijay1

You would be better off asking your question on a vb.net newsgroup.

This group is about Paradox the Application rather than Table Format.

There may be someone who attends here who is able to help, but you'd be far
more likely to get answers on a vb.net group.

--
------------------------------
Tony McGuire

I've done this with ADO but this was back in VB6. You have to use the
ODBC drivers that come with Paradox and connect via ODBC. The MS drivers
didn't work. Was a long time ago.

Tom K


vijay1 wrote:

thanks for the info.I will post the question in vb.net news group

vijay1

"vijay1" <srivijayasri (AT) yahoo (DOT) com> wrote

Are you designing a Windows application or a WEB application?

If this is a WEB application, there will be a challenge to access the
NET-file in Paradox, because the anonymous default web user has the lowest
access possible, and the IT-manager will explode if you try to assign
extended rights for this user. There are workarounds however, if this
approach is to be followed.

If this is a Windows application, it should be possible. I did this with VB
6 for a test some time ago, and this worked well enough, but was very slow
compared to host the data on an SQL server, at least 10 times slower. I have
also used VBA code with Excel to connect to Paradox, but this is like 20
times slower than connecting to an SQL server.

Here is the connection string I used with the VBA:
Dim ConStr as String
ConStr="Provider=MSDASQL.1;DBQ=g:\data\paradox\db; DefaultDir=g:\data\paradox\db;Driver={Microsoft
Paradox Driver (*.db )};DriverID=538;ParadoxNetPath=g:\data\paradox;"

->Note the ParadoxNetPath part if the Pardadox application is shared.

At the time I am trying to convert a Paradox application to ASP.NET 2.0
using Visual Studio 2005. The steps are small, like table by table and
feature by feature, form by form, but what slowly is emerging at the other
end is looking good.
I too, need to read Paradox data from the .NET application, but I have
decided to replicate the essential data from Paradox to the MS SQL server
with a small Paradox application scheduling for updates every 5 minutes.
Because of the NET file problem decribed above, I never went further on
connecting directly to Paradox.

Maybe not much of a help, but if there is any comfort: With one leg on the
riverbank of Paradox and one leg on the riverbank of .NET there is a good
chance of getting real soaking wet one day. There are moments I feel the
river beneath is getting a bit too wild for keeping a calm mind, but - there
are solutions to most issues.

Bjorn

thanks for the info Bjorn

"Bjorn Sagbakken" <bjo-sag (AT) online (DOT) no> wrote: