Di PB 9 ke bawah, pake sql server native connection : SQLCA.DBMS = "MS SQL SERVER" SQLCA.Database = "MYDB" SQLCA.ServerName = "MYSERVER" SQLCA.LogID = "MYUSER" SQLCA.LogPass = "MYPASS" SQLCA.DbParm = "AppName='MY APP NAME'" SQLCA.AutoCommit = TRUE SQLCA.Lock = "RU" CONNECT USING SQLCA;
Di PB 10 ke atas, pake OLE DB : SQLCA.DBMS = "OLE DB" SQLCA.LogID = "MYUSER" SQLCA.LogPass = "MYPASS" SQLCA.DbParm = "PROVIDER='SQLOLEDB',DATASOURCE='MYSERVER',PROVIDERSTRING='DATABASE=MYDB'" SQLCA.AutoCommit = TRUE SQLCA.Lock = "RU" CONNECT USING SQLCA; rgds, Andi F. ----- Original Message ----- From: Ruthdie To: [email protected] Sent: Wednesday, December 05, 2007 5:29 PM Subject: Re: [indopb] gimana cara bikin connection database via koding thank you bro atas balasanya, tapi yg gwe maksud tuh, "katanya" ada oledb juga di pb. nah gmn cara koneksinya kalo pake oledb? katanya lagi nih, harus bikin file .ini atau gimana gitu lah maklum bener2 ga tau sih. jadi kasusnya spt ini, gwe ada form login dgn 3 sle 1. nama server 2. nama user 3. password misal kasusnya spt ini - nama server : myServer - database : myDB - nama user : myUser - passwordnya : myPass gmn caranya spy bikin connectionstringnya "ala" oledbnya pb? dgn catatan server, user, dan pass berdasarkan sele2 diatas hehehe makanan kali sele, sorry mksdnya sle. jadi sifatnya dinamis sekali lagi thank you. salam ruthdie .
