VB'ers
saya mau nanya nih, saya lagi coba buat koneksi dr VB ke Oracle nih..
saya sudah coba buat adodc trus di pasang di salah satu datagrid dan datanya
muncul semua..
tapi sewaktu saya mau konek dr Vbnya via connection string kok error ya?
error messagenya "Object Variable or with blockvariable not set"
syntaxnya...
---------------------------------------------------------
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strConn As String
strConn = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User
ID=hr;Data Source=orcl;Password=hr"
conn.Open strConn
rs.Open "select * from employees"
-----------------------------------------------------
saya conn stringnya saya ganti jadi
strConn = "Provider=OraOLEDB.Oracle.1;User ID=hr;Data Source=orcl
tapi masih error jg
mohon pencerahan.
GBU
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
