Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Connecting to SQL Server 2000 from PB 10

1 view
Skip to first unread message

Deva

unread,
Oct 6, 2004, 1:37:47 AM10/6/04
to

Currently im using PB 6.5 with MS SQL Server 2000 as backend. In PB 10,
interface has not been provided in the database profiles to connect to MS SQL
Server. Please advice me.

Thanks

Deva
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

EChapa

unread,
Oct 6, 2004, 7:54:02 AM10/6/04
to
Which version of 10 do you have? If you're looking for the PB's native
drivers, they're only in the Enterprise version.

http://www.sybase.com/products/internetappdevttools/powerbuilder/pb10_featurematrix


--
Evita Chapa
Senior Systems Analyst II
Command Technologies, Inc.
"Deva" <deva_na...@rediffmail.com> wrote in message
news:416384a7$1@forums-2-dub...

Chris Pollach

unread,
Oct 6, 2004, 8:14:26 AM10/6/04
to
Deva;

Neither Sybase or Microsoft now support the old native driver
(DBLib.dll). You must move to either: ODBC, OLE-DB or ADO.net to be more
current.

Regards ... Chris


"Deva" <deva_na...@rediffmail.com> wrote in message
news:416384a7$1@forums-2-dub...
>

Tyler Cruse

unread,
Oct 8, 2004, 1:44:44 PM10/8/04
to
I would recommend ole_db or ADO.net. Both of these seem to be stable and
perform well. For ADO.Net you will need to set "CommandTimeout" and
"Timeout" in the connection string if you expect to have long running
connections. (recommend build 5032 for ADO.net because of the timeout
issue)


"Chris Pollach" <Poll...@SCC-CSC.gc.ca> wrote in message
news:4163e1a2@forums-1-dub...

0 new messages