From: srivijayasri@yahoo.com   
      
   thanks for the info Bjorn   
      
   "Bjorn Sagbakken"  wrote:   
   >"vijay1"  wrote in message   
   >news:46819cc3$1@pnews.thedbcommunity.com...   
   >>   
   >> 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   
   >   
   >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   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)