Razzak, I have sqlserver on my SBS2003 server. I copied a table from an RBase db containing 79,000 rows to a SqlServer test DB. When I execute an update on a single column in the sqlserver, it flops after only updating about 500+ rows. When I execute the Update using SSQL passthrough, the update completes on all rows without error.
I didn't do anything beyond this. I didn't expect the standard RB7 driver to be Read/Write to the extent it would be in competition with, or as a replacement for Oterro, but the SSQL passthrough worked as I would expect. That's all I can add to this thread. ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, May 18, 2005 5:46 PM Subject: [RBG7-L] - Re: MS SQL SCONNECT PROBLEM > > At 06:14 PM 5/18/2005, Victor Leach wrote: > >>Hi Razzak >> >>I sent this question once, could you please reply. If it's a problem >>with the MS SQL driver then I can tell the client. Its just the UPDATE >>command that does not work on a MS SQL tables with 8000 rows of data but >>is okay on the same table with 20 rows of data. >>Regards Victor > > > Victor, > > Unfortunately, I'm not in a position to verify either, as neither myself > nor any member of my Dream Team (Local, Northwest, Europe or Asia) uses > MS SQL server nor have any intention of using/installing it. > > You know we are very easy to get hold of and very prompt at fixing anything > we can on our end, but have no control over anyone else. > > You may send the SQL -ERROR- log, if you wish, for our review and we'll > be happy to take a look at it and do everything we can to help. > > Very Best R:egards, > > Razzak. >
