kemaren saya coba melakukan koneksi di mesin windows, kedua database (Oracle + Mysql) masih dalam 1 mesin. untuk melakukan koneksi saya install MyODBC sebagai konektor nya. Thx --- On Thu, 27/11/08, Miao M <[EMAIL PROTECTED]> wrote:
From: Miao M <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] koneksi oracle ke Mysql To: [email protected] Date: Thursday, 27 November, 2008, 2:24 PM Sory aku kan pake oracle 10G di Sun solaris.. kemudian pake mysql 5..kok aku coba g bs ya.. settingan tersebut apakah ada connector/aplikasi tambahan yang lain yg perlu diinstall Aku jg lg oprek ni.. ----- Original Message ----- From: musisi musisi <tc2681_2006@ yahoo.com. sg> To: indo-oracle@ yahoogroups. com Date: Thu, 27 Nov 2008 15:21:37 +0800 (SGT) Subject: Re: [indo-oracle] koneksi oracle ke Mysql > ok udah berhasil konek > Â > Â thx P. Yahya. > > --- On Thu, 27/11/08, bukhari yahya <bukhariyahya@ gmail.com> wrote: > > From: bukhari yahya <bukhariyahya@ gmail.com> > Subject: Re: [indo-oracle] koneksi oracle ke Mysql > To: indo-oracle@ yahoogroups. com > 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<bukhariya hya% > > 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] > > > 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]
