Board index » delphi » MS SQL 6.5 and Delphi 2.01 problems

MS SQL 6.5 and Delphi 2.01 problems

I have some trouble using Delphi 2.01 with MS SQL Server 6.5 using
MS 32bit ODBC drivers. We are using P133 machines running NT as clients
and a NT server running on a P90. Perhaps there is somebody out
there who had the same problems and can help.
Reply via email would be much appreciated.

    dirk

--------------------------------------------------------------------

1. Error messages from the SQL Server don't get communicated to Delphi
   clients or the Borland Database Explorer (BDE). For example, if
   I type the SQL command to drop an index that doesn't exist (typo
   in the index name), BDE just freezes up instead of giving me a
   message that I did something wrong.

2. As a little test, I have created a table with two char(255) fields.
   Using Delphi, I built a little "application" that has a TDataSource,
   a TTable and a TDBNavigator. Everything is connected properly, and
   the ODBC drivers and aliases have been set up properly using the
   Control Panel and the BDE Configuration tool.

   When the table contains about 10 records, the application works fine.
   I can browse, edit, insert and delete. When the table contains 300
   records, I get some error messages in the SQL Server error log, the
   application displays the data, and I can scroll back and forth. As soon
   as I commit any changes (edit, insert or delete), the application
   freezes up.

   The error messages on the SQL server are:

   ods     Error: 17824, Severity: 10, State: 0
   ods     Unable to write to ListenOn connection '\\.\pipe\sql\query', loginname 'sa', hostname 'POS91110'.
   ods     OS Error: 109, The pipe has been ended.
   ods     Error: 17824, Severity: 10, State: 0
   ods     Unable to write to ListenOn connection '\\.\pipe\sql\query', loginname 'sa', hostname 'POS91110'.
   ods     OS Error: 232, The pipe is being closed.
   spid11  Error: 1608, Severity: 21, State: 2
   spid11  A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.

   When I use the Borland Database Explorer to access the same database, I
   get the same behaviour. On the other hand, I have no problems working
   with the database using MS Access or MS ISQL/w as front ends.

   Recently I reduced the field size to 254 chars (BDE displayed a field lenght
   of 255 characters and a physical size of 256, and the 256 disturbed me...).
   Since then, the application _seems_ to be ok.

3. Now a bigger test that is closer to my first real application. I have a
   table with several integer fields that are foreign keys and point
   to four tables with two fields each (one integer primary key and one memo
   field) and to three tables with two fields each (one integer primary key and
   one char[50]). Then I created a view to link everything together
   and I built a little Delphi app with a TDataSource, a TTable and a
   TDBNavigator. When I click the Refresh Data Button on the Navigator,
   Delphi complains that there is no index. I tried to create an index
   in MS SQL (using ISQL/w), but it won't let me create an index on a
   view. It wants a table.

4. Same app as in 3. When I scroll up and down in the view, things are fine.
   When I jump to the last record, things are still fine. When I scroll back
   a few records, at some point all memo fields display "memo too long".
   When I go back to the end, things are fine again. The Borland Database
   Explorer behaves in the same way. Then I created a real table with the same
   fields and data as the view. Same thing. Then I created an index on that
   table. Same thing. By the way, each memo field is well below 1kB.

--------------------------------------------------------------------

 

Re:MS SQL 6.5 and Delphi 2.01 problems


Hi Dirk,

Quote
You wrote:
> I have some trouble using Delphi 2.01 with MS SQL Server 6.5 using
> MS 32bit ODBC drivers. We are using P133 machines running NT as
> clients and a NT server running on a P90. Perhaps there is somebody
> out there who had the same problems and can help.
> Reply via email would be much appreciated.

As the top development house in South Africa, the first thing we dumped
when moving to Delphi was the BDE!!  Especially since we settled on ODBC
as the best standard data access protocol around.

Would you consider using *another* access method??  We wrote ODBCExpress
(a BDE replacement), which provides straightforward but BLINDING access
to ODBC datasources.  I believe that it is the ONLY serious
industrial-strength data access tool around for Delphi.

We also had numerous problems with SQL Server and the BDE - the essence
being that the middleware becomes the measure of the stability of your
application - something we could not afford to compromise.

I suggest that you avoid SQL Server 6.5 - we've just gone through an
extremely painful & time-consuming migration to and back from 6.5 ->
6.0.  Microsoft acknowledges various problems which we encountered:
basically the product just isn't ready.  Our stuff DID work just fine
with 6.5 however, the problems we had were specifically back-end related
(eg. connect a 6.0 client to 6.5 and SQL Server DIES!! Microsoft
acknowledges some core problems with the TCP/IP implementation that is
still extremely wobbly...).

If you're interested, you can check out ODBCExpress at
http://www.adam.co.za

The 16bit version is freeware while the 32bit is shareware.

Regards,

Rob
--
Rob McGillivray
Manager, Client/Server Software Development
Compustat - 'Voted Top Development House in South Africa 1994'

Re:MS SQL 6.5 and Delphi 2.01 problems


I seem to rember getting a similar error message with Interbase while using
NT 4.0 beta 1 as a test client and NT 3.51 sp3 on the server.  It only
happened when using NetBeui to connect to NT.  TCP/IP was fine, if I
remember correctly.  

We have since upgraded our server to service pack 4 and downgraded the NT
4.0 beta 1 machine to Win95 due to problems between Delphi and NT 4.0
beta2.

Dirk HOELTJE <d...@marge.cs.mcgill.ca> wrote in article
<4uqrhk$...@sifon.cc.mcgill.ca>...

Quote

> I have some trouble using Delphi 2.01 with MS SQL Server 6.5 using
> MS 32bit ODBC drivers. We are using P133 machines running NT as clients
> and a NT server running on a P90. Perhaps there is somebody out
> there who had the same problems and can help.
> Reply via email would be much appreciated.

>     dirk

>    The error messages on the SQL server are:

>    ods     Error: 17824, Severity: 10, State: 0
>    ods     Unable to write to ListenOn connection '\\.\pipe\sql\query',

loginname 'sa', hostname 'POS91110'.
Quote
>    ods     OS Error: 109, The pipe has been ended.
>    ods     Error: 17824, Severity: 10, State: 0
>    ods     Unable to write to ListenOn connection '\\.\pipe\sql\query',

loginname 'sa', hostname 'POS91110'.
Quote
>    ods     OS Error: 232, The pipe is being closed.
>    spid11  Error: 1608, Severity: 21, State: 2
>    spid11  A network error was encountered while sending results to the

front end. Check the SQL Server errorlog for more information.

- Show quoted text -

Quote

Other Threads