Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

PB7 to PB11, need DBMS for MS SQL Server 2000

3 posts in Database Last posting was on 2008-08-06 23:29:40Z
MarkH Posted on 2008-08-06 15:44:37Z
Sender: 65f3.4899c452.1804289383@sybase.com
From: MarkH
Newsgroups: sybase.public.powerbuilder.database
Subject: PB7 to PB11, need DBMS for MS SQL Server 2000
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4899c6e5.664a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Aug 2008 08:44:37 -0700
X-Trace: forums-1-dub 1218037477 10.22.241.41 (6 Aug 2008 08:44:37 -0700)
X-Original-Trace: 6 Aug 2008 08:44:37 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29389
Article PK: 311611

In PB7, I used a parameter dbms="MSS Microsoft SQL Server
6.x" to connect PB7 application to MS SQL Server 2000.

Upgraded application to PB11. When run, I get DBMS MSS
Microsoft SQL Server 6.x is not supported in your current
installation .

What do I substitute in the DBMS parameter for "MSS
Microsoft SQL Server 6.x" to get it to connect to MS SQL
Server 2000 ?


M. Searer Posted on 2008-08-06 17:46:18Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.powerbuilder.database
References: <4899c6e5.664a.1681692777@sybase.com>
In-Reply-To: <4899c6e5.664a.1681692777@sybase.com>
Subject: Re: PB7 to PB11, need DBMS for MS SQL Server 2000
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4899e36a$1@forums-1-dub>
Date: 6 Aug 2008 10:46:18 -0700
X-Trace: forums-1-dub 1218044778 10.22.241.152 (6 Aug 2008 10:46:18 -0700)
X-Original-Trace: 6 Aug 2008 10:46:18 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29390
Article PK: 311612

OLEDB

"MarkH" wrote in message news:4899c6e5.664a.1681692777@sybase.com...
> In PB7, I used a parameter dbms="MSS Microsoft SQL Server
> 6.x" to connect PB7 application to MS SQL Server 2000.
>
> Upgraded application to PB11. When run, I get DBMS MSS
> Microsoft SQL Server 6.x is not supported in your current
> installation .
>
> What do I substitute in the DBMS parameter for "MSS
> Microsoft SQL Server 6.x" to get it to connect to MS SQL
> Server 2000 ?


Chris Pollach Posted on 2008-08-06 23:29:40Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.database
References: <4899c6e5.664a.1681692777@sybase.com>
Subject: Re: PB7 to PB11, need DBMS for MS SQL Server 2000
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <489a33e4$1@forums-1-dub>
Date: 6 Aug 2008 16:29:40 -0700
X-Trace: forums-1-dub 1218065380 10.22.241.152 (6 Aug 2008 16:29:40 -0700)
X-Original-Trace: 6 Aug 2008 16:29:40 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29391
Article PK: 311613

Hi Mark;

Microsoft no longer supports the native interface for SS. The "MSS"
setting in PB invoked the NTDBLIB.dll native driver. However, MS never
ported this dll to Unicode and left it as a deprecated feature in SS2000.
They did remove the dll in SS2005 - but the only way you could still use it
in SS2000 was to have an ANSI based application (like those produced from PB
versions up to 9.x).

For PB 10 and higher being Unicode, you have the choices of ODBC,
OLE-DB, ADO.Net and SNC. I would personally have a look at the new SNC (SS
Native Driver) as this is the best connectivity and performance option that
I have used when you get to SS2005 or 2008. In the meantime, OLE-DB might be
your best backwards choice for SS2000.

FYI:
http://chrispollach.pbdjmagazine.com/sqlserver2005__who_redesigned_this_release.htm

Good luck with this ... I feel your pain (been there done that).

--
Regards ... Chris
Blog: http://chrispollach.pbdjmagazine.com

<MarkH> wrote in message news:4899c6e5.664a.1681692777@sybase.com...
> In PB7, I used a parameter dbms="MSS Microsoft SQL Server
> 6.x" to connect PB7 application to MS SQL Server 2000.
>
> Upgraded application to PB11. When run, I get DBMS MSS
> Microsoft SQL Server 6.x is not supported in your current
> installation .
>
> What do I substitute in the DBMS parameter for "MSS
> Microsoft SQL Server 6.x" to get it to connect to MS SQL
> Server 2000 ?