From: user@domaininvalid.com   
      
   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:   
   > 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 (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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)