Board index » delphi » Help: Delphi 16 bit client to MS SQL Server 6.0

Help: Delphi 16 bit client to MS SQL Server 6.0

Hi,

I'm trying to find out (Borland tech. support is useless) if there is
a Borland 16 bit interface that supports Microsoft's SQL Server 6.0.

I have discovered that Borland's SQL Links 2.5 (16 bit) is only
certified to be compatible with SQL Server 4.21 and that Borland have
released a 32 bit version of SQL Links which is compatible with SQL
Server 6.0.  However, I actually need a 16 bit interface (because the
client program is running on Windows 3.1 boxes) to my SQL Server 6.0
which is running on an NT Server 3.51 box.

Can somebody please fill me in on what's going on with Borland with
regard to this software.  If there is currently no such product, is
there one being released soon?  (For how much $$ ?)  If you email me,
please mark it Attn: Mike Hodgson.

--
Regards,
        Mike

'It has been proved that research causes cancer in rats.'

 

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


Quote
dco...@planet.ch (Daniel Cohen-Dumani) wrote:
>In article <4ieh9i$...@oznet03.ozemail.com.au>, hand...@ozemail.com.au says...

>SQL Links 2.5 works fine with SQL Server 6.0. I haven't encountered any
>problems for the moment. The other way to connect is to use a 16 bit ODBC
>driver.

>Daniel

Are you using stored procedures on the server (via SQL links 2.5)? Delphi
/ BDE is unable to enumerate the stored procedures (like a list of
tables). Similary, parameters of stored procs. have problems with string
fields (input & output).

Vimal.

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


We are in the same situation, Borland tech support refuses to answer
queries about a 16-bit version of SQL links with MS-SQL 6.0
compatibility. Hopefully the volume of the clients in the same situation
will cause Borland to ship out a version soon.

Vimal

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


Quote
Vimal Swaroop wrote:

> dco...@planet.ch (Daniel Cohen-Dumani) wrote:
> >In article <4ieh9i$...@oznet03.ozemail.com.au>, hand...@ozemail.com.au says...

> >SQL Links 2.5 works fine with SQL Server 6.0. I haven't encountered any
> >problems for the moment. The other way to connect is to use a 16 bit ODBC
> >driver.

> >Daniel

> Are you using stored procedures on the server (via SQL links 2.5)? Delphi
> / BDE is unable to enumerate the stored procedures (like a list of
> tables). Similary, parameters of stored procs. have problems with string
> fields (input & output).

> Vimal.

Oh boy, just what I signed on for!  Yet another Borland Delphi question!!!
Folks, this is for the ONLINE SERVICE called Delphi, NOT the windows development
package Delphi.  Please direct these questions elsewhere.
--
Tim

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


Vimal Swaroop <Vimal_Swar...@alltel.com> wrote :
Quote
>dco...@planet.ch (Daniel Cohen-Dumani) wrote:
>>In article <4ieh9i$...@oznet03.ozemail.com.au>, hand...@ozemail.com.au says...

16 bit native MS SQL 6 access.

To add to the noise, we have many customers who are not yet ready to go
to 32 bit but are ready to use MS SQL 6. How hard can it be to migrate
the 32 bit native drivers back to 16 bit?

--
=======================================================================
|          WorkGroup Systems Ltd <W...@shockwav.demon.co.uk>           |
|      Quetzal & Q-Support, Help desk and Inventory management        |
|             "The Art of Support Centre Management"                  |
=======================================================================

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


Quote
John Hartung <lgepwris*...@ntr.net> wrote:
>We have been using 16 bit Delphi connecting to SQL Server 6.0 quite
>successfully for a couple of months.  We had a problem with null values
>from within Delphi forms, but no other major problems.  We just received
>our 2.0 version and it runs at an unacceptable speed.  Apparently they
>rewrote the driver (but it should be at least as fast, not 3 times
>slower!!)  We are working with Borland technical support to resolve the
>problem.  Is anyone else having the same problem?  I will post Borland's
>response when they come back to us.

Are you using the ODBC driver or SQL Links ?

Jonathan Tee

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


We had to use 16 bit ODBC...yuuch..

Kelly

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


It's entirely possible that Vimal Swaroop <Vimal_Swar...@alltel.com>

Quote
last wrote:

#We are in the same situation, Borland tech support refuses to answer
#queries about a 16-bit version of SQL links with MS-SQL 6.0
#compatibility. Hopefully the volume of the clients in the same situation
#will cause Borland to ship out a version soon.

Unlikely.  I spoke to Borland tech. support yesterday and they said
the next version, due out in the "first or second quarter" (ie.
sometime around mid-tear), will support Sybase 10 but no mention of
Microsoft SQL Server 6.0.  That's funny, I thought they used the same
driver.

        Mike

Re:Help: Delphi 16 bit client to MS SQL Server 6.0


The standard 16 bit (delphi 1.0 C/S) works fine with
SQL 6.0.
Just use the SYBASE driver .

Other Threads