ni kakang kasih contoh connect SQL server + pemanggilan Query sql nya coba aja:
tentukan data source=nama server;Initial catalog=nama Database;User Id=nama user admin;password=password admin;
ok semoga berhasil:saya sedang mengembangkan proyek ini juga di PT.PIL cikampek
Dim sSQL As String
'#===========Connect Provider SQL Server===================================
Set connsetting = New adodb.Connection
connsetting.CursorLocation = adUseClient
connsetting.Open "PROVIDER=SQLOLEDB;" & _
"Data Source=pgserver;" & _
"Initial Catalog=InspYN_Test;" & _
"User Id=sa;" & _
"Password=peliguna;"
Set rssetting = New adodb.Recordset
rssetting.Open "Select * from OrderIn", connsetting, adOpenDynamic, adLockBatchOptimistic
'#===========Connect Provider SQL Server===================================
Set connsetting = New adodb.Connection
connsetting.CursorLocation = adUseClient
connsetting.Open "PROVIDER=SQLOLEDB;" & _
"Data Source=pgserver;" & _
"Initial Catalog=InspYN_Test;" & _
"User Id=sa;" & _
"Password=peliguna;"
Set rssetting = New adodb.Recordset
rssetting.Open "Select * from OrderIn", connsetting, adOpenDynamic, adLockBatchOptimistic
Set gridppc.DataSource = rssetting
gridppc.Refresh
larry_marz <[EMAIL PROTECTED]> wrote:
gridppc.Refresh
larry_marz <[EMAIL PROTECTED]> wrote:
Guys gimana caranya hubungin VB6 sama SQL yah..?
trims.
Send instant messages to your online friends http://uk.messenger.yahoo.com
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
