Board index » delphi » Are there SQL links for MS SQL 2000 ?

Are there SQL links for MS SQL 2000 ?

It seems that the current version of BDE does not support SQL SERVER 2000

any plans to support it?

Best regards

John

 

Re:Are there SQL links for MS SQL 2000 ?


John,

   M$ has not updated their DbLib (which the BDE uses) for MSSQL 7 or 2000.
The M$ preferred way to connect to a MSSQL database is ADO.  ADOExpress
comes with D5 Enterprise or you can buy it separately for D5 Professional.

Good luck,
krf

Quote
johnvr wrote in message <3a6ece7f_1@dnews>...
>It seems that the current version of BDE does not support SQL SERVER 2000

>any plans to support it?

>Best regards

>John

Re:Are there SQL links for MS SQL 2000 ?


It does. It just doesn't support new data types, because MS won't update
DBLIB to force everybody to use ADO.

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying
email: robert.qwe.ce...@neosys.xrs.qwe.si

No questions via email, unless explicitly invited.

Quote
johnvr wrote in message <3a6ece7f_1@dnews>...
>It seems that the current version of BDE does not support SQL SERVER 2000

>any plans to support it?

>Best regards

>John

Re:Are there SQL links for MS SQL 2000 ?


Cheers Kevin,

Have been having a surf about and found the following on the Borland web
site
http://pso.inprise.com/devsupport/WelcomePage.html
This advises of the server 7 problem but says should use the CT-LIB
instead, using CT-LIB will allow use of NVARCHAR, NCHAR etc

am not sure how to determine whether db-lib or ct-lib, or indeed if I
found it were db-lib how to change to ct-lib!!

cheers
john

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:3a6edfd7$1_2@dnews...
Quote
> John,

>    M$ has not updated their DbLib (which the BDE uses) for MSSQL 7 or
2000.
> The M$ preferred way to connect to a MSSQL database is ADO.  ADOExpress
> comes with D5 Enterprise or you can buy it separately for D5 Professional.

> Good luck,
> krf

> johnvr wrote in message <3a6ece7f_1@dnews>...
> >It seems that the current version of BDE does not support SQL SERVER 2000

> >any plans to support it?

> >Best regards

> >John

Re:Are there SQL links for MS SQL 2000 ?


This page is wrong, CT-LIB is a Sybase protocol.

-Euan

Quote
"john williams" <jwilli...@armstronglaing.co.uk> wrote in message

news:3a6ee953_2@dnews...
Quote
> Cheers Kevin,

> Have been having a surf about and found the following on the Borland web
> site
> http://pso.inprise.com/devsupport/WelcomePage.html
> This advises of the server 7 problem but says should use the CT-LIB
> instead, using CT-LIB will allow use of NVARCHAR, NCHAR etc

> am not sure how to determine whether db-lib or ct-lib, or indeed if I
> found it were db-lib how to change to ct-lib!!

> cheers
> john

> "Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> news:3a6edfd7$1_2@dnews...
> > John,

> >    M$ has not updated their DbLib (which the BDE uses) for MSSQL 7 or
> 2000.
> > The M$ preferred way to connect to a MSSQL database is ADO.  ADOExpress
> > comes with D5 Enterprise or you can buy it separately for D5
Professional.

> > Good luck,
> > krf

> > johnvr wrote in message <3a6ece7f_1@dnews>...
> > >It seems that the current version of BDE does not support SQL SERVER
2000

> > >any plans to support it?

> > >Best regards

> > >John

Re:Are there SQL links for MS SQL 2000 ?


DBLIB is very old (Sybase switched from using it to using CT-LIB so they did
not support it for long either), to connect to SQL7/2000 you can use ODBC,
OLE DB or ADO. You are not forced into anything.

-Euan

Quote
"Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote in message

news:94mre6.25c.1@neosys.xrs.si...
Quote
> It does. It just doesn't support new data types, because MS won't update
> DBLIB to force everybody to use ADO.

> --
> ----------------------
> Regards
> Robert Cerny
> Remove both qwe when replying
> email: robert.qwe.ce...@neosys.xrs.qwe.si

> No questions via email, unless explicitly invited.
> johnvr wrote in message <3a6ece7f_1@dnews>...
> >It seems that the current version of BDE does not support SQL SERVER 2000

> >any plans to support it?

> >Best regards

> >John

Re:Are there SQL links for MS SQL 2000 ?


Actually you are. With ODBC it does support new data types, but handles
cursors like DBLIB (=you can have only one pending result set per
connection), which makes it practically useless, unless you use a separate
connection for each result set, but then you have other limitations (temp
tables).
So, you have to use ADO.

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying
email: robert.qwe.ce...@neosys.xrs.qwe.si

No questions via email, unless explicitly invited.

Quote
Euan Garden wrote in message <94n6p2$ab...@bornews.inprise.com>...
>DBLIB is very old (Sybase switched from using it to using CT-LIB so they
did
>not support it for long either), to connect to SQL7/2000 you can use ODBC,
>OLE DB or ADO. You are not forced into anything.

Re:Are there SQL links for MS SQL 2000 ?


You can use OLE DB if you want, strange you have so many issues with ODBC,
all of the SQL Tools with the exception of DTS use ODBC in 7.0 and 2000 and
they don't have any issues.

-Euan

Quote
"Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote in message

news:94nf3a.1m0.1@neosys.xrs.si...
Quote
> Actually you are. With ODBC it does support new data types, but handles
> cursors like DBLIB (=you can have only one pending result set per
> connection), which makes it practically useless, unless you use a separate
> connection for each result set, but then you have other limitations (temp
> tables).
> So, you have to use ADO.

> --
> ----------------------
> Regards
> Robert Cerny
> Remove both qwe when replying
> email: robert.qwe.ce...@neosys.xrs.qwe.si

> No questions via email, unless explicitly invited.
> Euan Garden wrote in message <94n6p2$ab...@bornews.inprise.com>...
> >DBLIB is very old (Sybase switched from using it to using CT-LIB so they
> did
> >not support it for long either), to connect to SQL7/2000 you can use
ODBC,
> >OLE DB or ADO. You are not forced into anything.

Re:Are there SQL links for MS SQL 2000 ?


cheers
Quote
"Euan Garden" <euan.gar...@spicedham.usa.net> wrote in message

news:94n6n2$ab911@bornews.inprise.com...
Quote
> This page is wrong, CT-LIB is a Sybase protocol.

> -Euan

> "john williams" <jwilli...@armstronglaing.co.uk> wrote in message
> news:3a6ee953_2@dnews...
> > Cheers Kevin,

> > Have been having a surf about and found the following on the Borland web
> > site
> > http://pso.inprise.com/devsupport/WelcomePage.html
> > This advises of the server 7 problem but says should use the CT-LIB
> > instead, using CT-LIB will allow use of NVARCHAR, NCHAR etc

> > am not sure how to determine whether db-lib or ct-lib, or indeed if I
> > found it were db-lib how to change to ct-lib!!

> > cheers
> > john

> > "Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> > news:3a6edfd7$1_2@dnews...
> > > John,

> > >    M$ has not updated their DbLib (which the BDE uses) for MSSQL 7 or
> > 2000.
> > > The M$ preferred way to connect to a MSSQL database is ADO.
ADOExpress
> > > comes with D5 Enterprise or you can buy it separately for D5
> Professional.

> > > Good luck,
> > > krf

> > > johnvr wrote in message <3a6ece7f_1@dnews>...
> > > >It seems that the current version of BDE does not support SQL SERVER
> 2000

> > > >any plans to support it?

> > > >Best regards

> > > >John

Other Threads