ok udah berhasil konek thx P. Yahya. --- On Thu, 27/11/08, bukhari yahya <[EMAIL PROTECTED]> wrote:
From: bukhari yahya <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] koneksi oracle ke Mysql To: [email protected] Date: Thursday, 27 November, 2008, 8:00 AM dsn odbc mysqlnya sudah test connect? On 11/26/08, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote: > > saya coba googling oracle HS dan menemukan, kemudian saya ikuti > step-by-stpe nya, setelah saya coba ada error di TNS nya saat saya lakukan > select, untuk informasi mysql server yang saya gunakan masih versi 3 dan > oracle 10 G running di windows XP. nama DNS mysql nya 'buku_mysql' > > untuk database link nya saya buat spt ini : > create database link bk_mysql using 'BK_MYSQL'; > > untuk configurasi initbk_mysql. ora sbb: > HS_FDS_CONNECT_ INFO = buku_mysql > HS_DB_NAME = buku_mysql > HS_FDS_TRACE_ LEVEL = ON > > untuk listener nya : > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = C:\oracle\product\ 10.2.0\db_ 1) > (PROGRAM = extproc) > ) > (SID_DESC= > (PROGRAM = hsodbc) > (SID_NAME = bk_mysql) > (ORACLE_HOME = C:\oracle\product\ 10.2.0\db_ 1) > ) > ) > LISTENER = > (DESCRIPTION_ LIST = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) > (ADDRESS LIST = > (ADDRESS = (PROTOCOL =TCP) (HOST=192.168. 1.22) (PORT=1524)) > ) > ) > ) > > dan untuk TNS nya : > BUKU_MYSQL= > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.22) (PORT = 1524)) > ) > (CONNECT_DATA = > (SID = bk_mysql) > ) > (HS=OK) > ) > > > ada kesalahan dimana ya ?? > tolong pencerahannya. > > thx > > > --- On Wed, 26/11/08, bukhari yahya <bukhariyahya@ gmail.com<bukhariyahya% > 40gmail.com> > > wrote: > > From: bukhari yahya <bukhariyahya@ gmail.com <bukhariyahya% 40gmail.com> > > Subject: Re: [indo-oracle] koneksi oracle ke Mysql > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Date: Wednesday, 26 November, 2008, 10:29 AM > > pakai HS > > On 11/26/08, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote: > > > > dear master, > > > > ada yang pernah sukses melakukan koneksi dari oracle ke MySQL server, klo > > ada sharing dong, apa aja yang dipersiapkan and langkah apa yang harus > > dilakukan. > > > > Thx > > > > New Email names for you! > > Get the Email name you've always wanted on the new @ymail and > > @rocketmail. > > Hurry before someone else does! > > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > New Email names for you! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
