[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

query to paradox database(oledb/odbc) returning wrong results

srid

7/2/2007 12:20:00 PM

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\;CollatingSequence=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(a) (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
vijay2
2 Answers

Stephen

7/3/2007 12:58:00 PM

0



"srid" wrote:

> 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\;CollatingSequence=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(a) (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''


There is a driver for sale for this and as I remember back in 2004 it was 50
usd. The M$ driver did not work.

srid

7/3/2007 3:50:00 PM

0

thanks for the info. let me do a google search

"srid" wrote:

> 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\;CollatingSequence=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(a) (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
> vijay2