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

DB profile of Powerbuilder to database

below example database profile of power builder to some database:

Ms SQl2005:
// Profile absensi
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "absensi"
SQLCA.LogPass = <***>
SQLCA.ServerName = "server"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""


Sybase ASA 7
// Profile tms7 use ODBC
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=tms;UID=user;PWD=password'"

MySQL
// Profile detik use ODBC and need install MySQL for ODBC
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=detik;UID=root;PWD=password'"

Oracle
//from clients PC to server
profile name: SID name
server: @global.database.name
login ID: scott
password: *****

migrasi database oracle9i, Win Server 2K3 to Win XP

e.g. database name HRIS, from Win Server2003, oracle 9i server:

• stop services oracle 9i then
  
• copy folder database at oradata\hris
  
• copy file init.ora at folder pfile
  

at Win XP, please install same Oracle version at same drive then:

• create same Global Database name and SID
  
• stop service oracle 9i
• copy folder database to oradata\hris
  
• copy file init.ora to folder pfile

personal Oracle 8 (tanpa i): restore database

untuk restore database Oracle 8 (tanpa i) dari PC lain ke PC lainnya adalah sebagai berikut: Copy file backup yang dari PC lainnya , biasanya di folder ORANT - BACKUP ke folder ORANT-BACKUP di PC yang baru, lalu pilih option no 2 pada menu restore.. udah deh