Pak, saya dulu pernah pake MySQL yg 3.5, jalan 100% Pak ... Coba MySQL nya waktu install jangan pake password Pak, di blank saja... Terus waktu buat nama database di ODBC nya, coba di system DSN, jangan di User DSN...
--- In [email protected], Rully Arfan <[EMAIL PROTECTED]> wrote: > > Mas Ivan, saya hampis sudah melakukan semua, > 1 create database menggunakan mysql melalui php myadmin, > 2.membuat contoh tabel > 3. dan MYSQL ODBC 3.51 Driver sudah ada di odbc > 4. saya membuat file odbc database mysql saya menggunakan driver tsbt diatas > 5. saya mengisi Server : localhost password : root database dengan datbase yang saya buat diatas port : 3306 > 6. saya tes = success: connection : was made > 5. saya membuat blank database di Ms Access 2003 > 6. saya membuat LInk Tables , file of Type nya menggunakan ODBC Database, maka tampilah file odbc yang saya buat, lalu say klik dua kali >> Oke > 7. lalu keluar pesan..:] ODBC call Failled > > [MySql][ODBC 3.5][mysqld-4.1.14-nt]Not Database Selected(#1046) > > > mungkin ada step yang kelewAt ya mas... > > maafkan say yang lalai.. > > regards, > > newbie > > > > > ----- Pesan Asli ---- > Dari: Ivan Leonardo <[EMAIL PROTECTED]> > Kepada: [email protected] > Terkirim: Selasa, 29 Juli, 2008 11:35:40 > Topik: Re: Bls: [belajar-access] Re: Koneksi Databse MySQKL menggunakan Access > > > 1. Waktu buat DSN di ODBC-Adm Tools kan bisa test connection dulu, sudah > berhasil belon ? kalo belon berhasil apalagi link table dari access > pasti ga bisa. > 2. Mysql install dimana ? localhost ato remote ? kalo local servername > isi localhost, user = root, password = yg diisi waktu install mysql. > Kalo di remote server = no ip si server. Oh iya sebelumnya coba create > database dulu misal "coba" jadi di database option pilih "coba". Nah > coba klik Test, kalo sukses akan ada pesan connection success. > 3. Kalo test sudah berhasil, hapus password baru klik Ok kalo password > diisi siapapun akan bisa konek ke database mysql tanpa ditanya password. > > 4. Open port 3306 di firewall kedua PC > > Akan lebih mudah jika punya aplikasi Navicat for Mysql utk management > Mysqlnya > > ------------ --------- --------- --------- --------- --------- - > This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. > > > > > ___________________________________________________________________________ > Dapatkan nama yang Anda sukai! > Sekarang Anda dapat memiliki email di @ymail.com dan @rocketmail.com. > http://mail.promotions.yahoo.com/newdomains/id/ >
