hehe baru mau gw bales, nih lengkapnya dari help filenya tuh: Example connection string for Applications that use the ODBC function * SQLDriverConnect*:
1. Open("*DSN*=myDb;")
2. Open("*DSN*=myDb; *UID*=MCSSITE; *PWD*=mcssite;")
3. Open("*DSN*=myDb; *UID*=MCSSITE; *PWD*=mcssite; *DBNAME*=172.17.2.10:
/usr/local/db/myDb.fdb;")
4. Open("*DRIVER*=Firebird/InterBase(r) driver; *DBNAME*=172.17.2.10:
/usr/local/db/myDb.fdb;")
5. Open("*DRIVER*=Firebird/InterBase(r) driver; *UID*=MCSSITE; *PWD*=mcssite;
*DBNAME*=172.17.2.10:/usr/local/db/myDb.fdb;")
also
6. Open("*DRIVER*=Firebird/InterBase(r) driver; *UID*=MCSSITE; *PWD*=mcssite;
*DBNAME*=dummy;")
nih tempet donlotnya (paling bawah):
http://www.firebirdsql.org/index.php?op=files&id=odbc
2011/4/4 Hermawan Dephe <[email protected]>
>
>
> Hehe.. dah ketemu nih..
> Thanx...
>
> pakenya gini
> SQLCA.DBParm = "ConnectString='Driver=Firebird/InterBase(r)
> driver;Uid=SYSDBA;Pwd=masterkey;DbName=localhost:C:\Program
> Files\firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB'"
>
>
> Hermawan Dephe wrote:
>
> Pak donny..
> Saya tetep gak bisa tuh, pake db profil gini ?
>
> SQLCA.DBParm = "ConnectString='DSN=Firebird/InterBase(r)
> driver;UID=SYSDBA;PWD=masterkey;dbq=localhost:C:\Program
> Files\firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB'"
> apa yg salah ya ??
>
> kalo bikin dns dulu emang bisa.. misal saya coba bikin dengan nama "fb"
> SQLCA.DBParm = "ConnectString='DSN=fb'"
> kalo yg cara ini emang jalan.. tp kan gak enak kalo kudu setting odbc
> segala
>
> Pls help..
>
> Thanx
> DP
>
>
>
>
> Donny Irsandi Azas wrote:
>
>
>
> males bikin odbc waktu distribusi yah? :D
>
> bikin aja di dbparmnya yg lengkap:
> sqlca.DBParm = "ConnectString='UID=dba;PWD=sql;DRIVER=(nama driver spt yg
> tertulis di ODBC);DBF=" + as_filename + "'")
>
> Native itu bawaan dari vendor, PB gak ada native firebird deh
>
>
> 2011/3/10 Denny Rusman <[email protected]>
>
>>
>>
>> Selain pakai ODBC .. ada lagi tidak cara lain…misal pakai native database
>> (seperti oracle)..
>>
>>
>> ------------------------------
>>
>> *From:* [email protected] [mailto:[email protected]] *On Behalf
>> Of *Kotaro Minami
>> *Sent:* 10 March 2011 12:33
>> *To:* [email protected]
>> *Subject:* Re: [indopb] Connect Database menggunakan Firebird v2.5
>>
>>
>>
>> Bisa lebih spesifik PAK, koneksi ke FireBird dari apa?
>>
>> kalo dari powerbuilder, bapa mesti install firebird ODBC driver setelah
>> itu buat ODBCnya
>> dan ini syntax dari PBnya
>>
>> // Profile Northwind
>> SQLCA.DBMS = "ODBC"
>> SQLCA.AutoCommit = False
>> SQLCA.DBParm = "ConnectString='DSN=NORTHWIND;UID=IB;PWD='Admin"
>>
>>
>> ------------------------------
>>
>> *From:* Denny Rusman <[email protected]>
>> *To:* [email protected]
>> *Sent:* Thu, March 10, 2011 9:06:23 AM
>> *Subject:* [indopb] Connect Database menggunakan Firebird v2.5
>>
>>
>>
>> Salam rekan-rekan PB…
>>
>>
>>
>> Mohon pencerahannya nih….ada yang tahu nggak cara koneksi database
>> FIREBIRD.. ??? Penulisan script nya bagaimana..??
>>
>>
>>
>> Thank’s
>>
>>
>>
>
>
>
>
>
<<image/gif>>
