Duh.. Ya udah berarti cobain :
ls_dsn='c :\Program Files\Common Files\ODBC\sna_db2.dsn'
SQLCA.DBParm =
"ConnectString='UID=dl2;PWD=xxx;CommLinks=SharedMemory,TCPIP{};FileDSN="+ls_dsn+"'"
Di improve dikit dong... :D
Apa mo ngetes nih??? ;)
----- Original Message -----
From: "Toto Ardiyanto" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, February 18, 2008 1:37 PM
Subject: [indopb] Re: Bagaimana caranya koneksi file dsn via odbc
Mungkin biar jelasnya gw kasih tahu :
1. Databasenya ada di mainframe dengan yaitu DB2 mainframe
2. Untuk menghubungkan PC dengan database yang di mainframe dipakai
sna server. File DSN dikasih nama sna_db2.dsn
3. Nach di sna serverlah file sna_db2.dsn dibuat dengan rincian
isinya adalah sbb :
[ODBC]
DRIVER=Microsoft ODBC Driver for DB2
UID=dl2
BT=NORM
MN=IBMRDB
LLU=DWCS1010
RLU=DB2CMS
NTL=SNA
BAC=1
DS=CMSP
PC=APPLPAR2
RDB=APPLPAR2
Misal IP sna server adalah 192.167.31.1 dan file sna_db2.dsn ada di
folder : \Program Files\Common Files\ODBC\sna_db2.dsn.
Mungkin ini dapat memperjelas persoalannya.
Brgds
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
