How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server 2000 sp4?

Hi:

How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server 
2000 sp4?

It seems that the special connection inferface for "MSS Microsoft SQL 
Server" is canceled in PowerBuilder 10.5.

I do not want to via ODBC.

Thanks! 

0 Wu 1/9/2007 2:26:59 AM

Wu;

  No, MSS driver (actually Microsoft's NTDBLIB.dll) was cancelled by Bill
Gates in SQLServer v7. It was supported in 2000 - but ANSI only with limited
functionality and dropped for SS2000 and 2005 in the Unicode world.

  So your choices are: ODBC, OLE-DB and ADO.net. There is new SNC driver for
PB 11 that is similar to the MSS one. You can join the PB 11 beta and try
that out if you like (works very well for me and extremely fast too).

Regards ... Chris
PS: I would strongly suggest upgrading to PB 10.5.1.


"Wu Zhenqing"  wrote in message
news:45a30b83@forums-1-dub...
> Hi:
>
> How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server
> 2000 sp4?
>
> It seems that the special connection inferface for "MSS Microsoft SQL
> Server" is canceled in PowerBuilder 10.5.
>
> I do not want to via ODBC.
>
> Thanks!
>
>

0 Chris 1/9/2007 11:43:08 AM