Board index » delphi » MS SQL Server 6.0

ch...@werple.mira.net.au (Glen J Stampoultzis)

Delphi Developer
Thu, 30 Jul 1998 03:00:00 GMT

MS SQL Server 6.0

I have heard that you can't use MS SQL Server 6.0 with the 16 bit version of Delphi.  
Is this true?  Would it be possible (or advisable) to connect to it with ODBC?

-- Glen Stampoultzis
-- ch...@werple.net.au

 
Julian Bon

Delphi Developer
Thu, 30 Jul 1998 03:00:00 GMT

Re:MS SQL Server 6.0


In article <4fjh9f$t8_...@mira.net.au>, Glen J Stampoultzis
<ch...@werple.mira.net.au> writes
Quote

>I have heard that you can't use MS SQL Server 6.0 with the 16 bit version of
>Delphi.  
>Is this true?  Would it be possible (or advisable) to connect to it with ODBC?

>-- Glen Stampoultzis
>-- ch...@werple.net.au

you can certainly access it via 16 bit ODBC. It also seems to work with
the sybase direct connection. There is no native direct connection
though, you have to wait for the Delphi 2 32 bit link.

--
=======================================================================
| <Julian Bond> jul...@shockwav.demon.co.uk                PGPKey@MIT |
| Quetzal & Q-Support, Help Desk and Inventory Management for Windows |
|                 "So many words, So little time"                     |
=======================================================================

Odd G|ran Orbak

Delphi Developer
Fri, 31 Jul 1998 03:00:00 GMT

Re:MS SQL Server 6.0


ch...@werple.mira.net.au (Glen J Stampoultzis) wrote:

Quote

>I have heard that you can't use MS SQL Server 6.0 with the 16 bit version of Delphi.  
>Is this true?  Would it be possible (or advisable) to connect to it with ODBC?

Well, I have tried the SQL-Links in the 16 bit C/S version with
MSSQLServer 6.0, and it works pretty well, but I've experienced some
problems. I'm a bit confused whether it is best to use the native
SQL-Link or the ODBC-driver, I've heard people recommend both of the
alternatives (over the other).
Manoj Champanerka

Delphi Developer
Wed, 05 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


Quote
>The good news is that the SQL Links for the 32-bit Delphi will have a
>driver specifically for MS SQL Server 6.0.

Is a SQL-Links update for MS SQL Server 6.0 for the 16-bit Delphi in the
pipeline ?

Manoj Champanerkar.

Sam Sto

Delphi Developer
Fri, 07 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


In <4fnm30$...@ratatosk.uio.no> Odd G|ran Orbakk
Quote
<o.g.orb...@dokpro.uio.no> writes:

>ch...@werple.mira.net.au (Glen J Stampoultzis) wrote:

>>I have heard that you can't use MS SQL Server 6.0 with the 16 bit

version of Delphi.  
Quote
>>Is this true?  Would it be possible (or advisable) to connect to it
with ODBC?

>Well, I have tried the SQL-Links in the 16 bit C/S version with
>MSSQLServer 6.0, and it works pretty well, but I've experienced some
>problems. I'm a bit confused whether it is best to use the native
>SQL-Link or the ODBC-driver, I've heard people recommend both of the
>alternatives (over the other).

I have had good luck with both desktop and C/S 16-bit Delphi and
SQLServer 6.0. The only exception is that stored proc output params and
return codes don't work. If you need an output param you must return it
as a result set. I had some success with Dan Daley's DirectODBC
(available on web) a few months ago and I'm going to download the
latest and re-evaluate.

Sam

Aughtly Aye

Delphi Developer
Sun, 09 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


Quote
Manoj Champanerkar <manoj_champaner...@alltel.com> wrote:
>>The good news is that the SQL Links for the 32-bit Delphi will have a
>>driver specifically for MS SQL Server 6.0.
>Is a SQL-Links update for MS SQL Server 6.0 for the 16-bit Delphi in the
>pipeline ?
>Manoj Champanerkar.

Called Borland today and got the answer I was not hoping for.  As of
right now there is no plans to provide a Native MS SQL Server 6.0
driver for IDAPI (BDE).

I was told to look into ODBC or use the Driver for Sybase.  Neither of
these will do the job we want.  (Without a lot of extra coding
anyway).

Anyway...it seems the answer is no for right now.

Aughtly Aye

Delphi Developer
Sun, 09 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


Quote
liquid_l...@usa.pipeline.com(Thomas L.H.) wrote:
>We have been having problems with page locking when using SQL Links  
>deivers to access a MS SQL Server 6.0 database.  If we only have one
>instance of an application everything works fine, but if we have  
>multiple instances of the application running the second one locks
>up and our DBM software says that the page is locked.  The really  
>interesting part is we do not have any of these problems when we  
>use the ODBC drivers.  Borland does not want to admit that SQL Links
>does not work with MS SQL Server 6.0, so we must not be good
>programmers.

>Anyone have any comments, suggestions, or points of order.

I found this article about SQL Server 6.0 that might give some insight
into the problem:

The following was written by Steve Koterski (Product Group Manager,
Borland International):

The SQL Links driver in Delphi 1.x that can be used with MS SQL Server
is actually the Sybase driver. This driver was designed around version
4.x of Sybase. MS SQL Server 4.x was basically a licensed copy of
Sybase 4.x, so the driver works with both.

However, later versions of MS SQL Server deviated and evolved from the
original sufficiently that the SQL Links driver cannot fully support
it. Most operations will work, some (primarily added features and
operations) will not. For this reason, Borland does not support the
use of the Sybase driver with versions of MS SQL Server beyond version
4.x, the only officially accepted means of accessing this database
being through ODBC.

The good news is that the SQL Links for the 32-bit Delphi will have a
driver specifically for MS SQL Server 6.0.

Steve Koters

Delphi Developer
Sun, 09 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


On 15 Feb 1996 15:58:10 GMT, liquid_l...@usa.pipeline.com(Thomas L.H.)
wrote:

Quote
>We have been having problems with page locking when using SQL Links  
>deivers to access a MS SQL Server 6.0 database.  If we only have one
>instance of an application everything works fine, but if we have  
>multiple instances of the application running the second one locks
>up and our DBM software says that the page is locked.  The really  
>interesting part is we do not have any of these problems when we  
>use the ODBC drivers.  Borland does not want to admit that SQL Links
>does not work with MS SQL Server 6.0, so we must not be good
>programmers.

>Anyone have any comments, suggestions, or points of order.

The only native driver for MS SQL Server in the SQL Links for Delphi 1.x is
the Sybase driver. That driver was designed for use with version 4.x of
Sybase. MS SQL Server 4.x was essentially a licensed repackage of the same
version of Sybase, so the SQL Links Sybase worked with it, too. However,
for versions of MS SQL Server after that, they deviated away from the
original designs to cause the SQL Links Sybase driver to longer be able to
support it. For this reason, use of the Delphi 1.x SQL Links Sybase driver
with any version of MS SQL Server beyond 4.x is not supported by Borland.
ODBC access to databases from this version is supported.

That is the bad news. Now the good. Delphi 2.0 will come with a new 32-bit
SQL Links, one that has a native driver specifically designed for MS SQL
Server 6.0. No official word at this time on whether that will be added to
the 16-bit SQL Links.

**************************************************************************
Steve Koterski                  "Results! Why, man, I have gotten a lot of
Product Group Manager           results. I know several thousand things
Delphi Technical Support        that won't work."
Borland International, Inc.                    -- Thomas Edison, 1847-1931

Charles Lombard

Delphi Developer
Tue, 11 Aug 1998 03:00:00 GMT

Re:MS SQL Server 6.0


Quote
Steve Koterski wrote:

> On 15 Feb 1996 15:58:10 GMT, liquid_l...@usa.pipeline.com(Thomas L.H.)
> wrote:

> >We have been having problems with page locking when using SQL Links
> >deivers to access a MS SQL Server 6.0 database.  If we only have one
> >instance of an application everything works fine, but if we have
> >multiple instances of the application running the second one locks
> >up and our DBM software says that the page is locked.  The really
> >interesting part is we do not have any of these problems when we
> >use the ODBC drivers.  Borland does not want to admit that SQL Links
> >does not work with MS SQL Server 6.0, so we must not be good
> >programmers.

> >Anyone have any comments, suggestions, or points of order.

> The only native driver for MS SQL Server in the SQL Links for Delphi 1.x is
> the Sybase driver. That driver was designed for use with version 4.x of
> Sybase. MS SQL Server 4.x was essentially a licensed repackage of the same
> version of Sybase, so the SQL Links Sybase worked with it, too. However,
> for versions of MS SQL Server after that, they deviated away from the
> original designs to cause the SQL Links Sybase driver to longer be able to
> support it. For this reason, use of the Delphi 1.x SQL Links Sybase driver
> with any version of MS SQL Server beyond 4.x is not supported by Borland.
> ODBC access to databases from this version is supported.

> That is the bad news. Now the good. Delphi 2.0 will come with a new 32-bit
> SQL Links, one that has a native driver specifically designed for MS SQL
> Server 6.0. No official word at this time on whether that will be added to
> the 16-bit SQL Links.

> **************************************************************************
> Steve Koterski                  "Results! Why, man, I have gotten a lot of
> Product Group Manager           results. I know several thousand things
> Delphi Technical Support        that won't work."
> Borland International, Inc.                    -- Thomas Edison, 1847-1931

Well we were told by the Director of Borland in Australia that the is in
fact a sql6.0 native driver on in delphi 1.02 which ships on the
delphi2.0 cd. We will have it in a couple of days and will keep you
posted!!!
Charles Lombardo

Other Threads

1. Delphi, Banyan, Windows 95, and MS SQL Server 6.0

2. Creating Data Dictionary on MS SQL Server 6.0

3. Help: Delphi 16 bit client to MS SQL Server 6.0

4. Problem with MS SQL Server 6.0/TTable/Sybase driver

5. MS SQL Server 6.0 Extended Stored Procedures

6. Delphi & MS SQL Server 6.0

7. MS SQL SERVER 6.0 - Fill Factor???

8. I can not store Blob data more than 32KB to MS SQL SERVER 6.0

9. "Connection is in use by another statement" error message using Delphi 1.0 against MS-SQL Server 6.0

10. Delphi 6.0 and MS SQL Server