PB connection to Ms SQL 2005

sometime we got problem when connected PB application to Ms. SQL Server 2005. Please use below some example that you can use at file ini connection:


[Absensi]
DBMS=MSS Microsoft SQL Server
Database=dbname
UserId=sa
DatabasePassword =xxxxxxxx
LogId=
LogPassword=
ServerName=192.168.100.5,1433
//DbParm=CommitOnDisconnect='No'

or

[Absensi]
DBMS=MSS Microsoft SQL Server
Database=dbname
UserId= sa
DatabasePassword = xxxxxxxxxx
LogId=
LogPassword=
ServerName= XYZ
//DbParm=CommitOnDisconnect='No'

or

[Absensi]
DBMS=MSS Microsoft SQL Server
Database=dbname
UserId=sa
DatabasePassword =xxxxxxxxxxxxx
LogId=
LogPassword=
ServerName=XYZSQL\XYZ_SQL
//DbParm=CommitOnDisconnect='No'

or

you can use ODBC-DNS connection,
please add sql server driver.

same above setting if you set dbrofile at PB software