Home about IT Motivation Course Sales Project About Me

Sunday, April 12, 2009

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: *****

No comments: