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.
