Ceriwis  

Go Back   Ceriwis > HOBI > Komputer & Teknologi > Programming

Programming Share, tanya jawab, saling bantu antar programmer dengan berbagai macam bahasa pemrograman.

Reply
 
Thread Tools
  #1  
Old 20th November 2011
Guesuper Guesuper is offline
Ceriwiser
 
Join Date: Nov 2011
Posts: 408
Rep Power: 14
Guesuper mempunyai hidup yang Normal
Default [ASK] mengkoneksikan vb6 ke database macces 2003 & menampilkannya di MSHFlexGrid

Para sesepuh VB6



tolong gan ajarin cara mengkoneksikan vb6 ke database macces(.mdb). Dan ditampilkan lewat form di dalam MSHFlexGrid....



ane dah nyoba koneksi seperti ini

wat koneksinya dengan membuat procedure tampil


Code:

Dim con As New adodb.Connection
Sub tampil()
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\SIA\akuntansi.mdb"
End Sub



menampilkannya di flexgrid


Code:

Dim rsakun As New adodb.Recordset
Private Sub Form_Load()
tampil
rsakun.Open "SELECT * FROM Akun", con, adOpenKeyset, adLockOptimistic
Set grid1.DataSource = rsakun
End Sub

grid1= MSHFlexGrid



pas di run muncul


Spoiler for Pesan Eror:
















mohon pencerahannya



thx b4 gan



maap klu threadnya kurang berkenan



Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


 


All times are GMT +7. The time now is 03:28 PM.


no new posts