Kira Kira Mungkin Begini Sintax nya ...
Dim conrevrwi As New ADODB.Connection
Dim comresetrwi As New ADODB.Command
Dim rstreset As New ADODB.Recordset
Dim rstrevi As New ADODB.Recordset
conrevrwi.Open
"Provider=SQLOLEDB.1;Password=<Password>;Persist
Security Info=True;User ID=sa;Initial Catalog=<nama
databasenya>;Data Source=<nama servernya>"
comresetrwi.ActiveConnection = conrevrwi
comresetrwi.CommandText = <"nama store procedure">
comresetrwi.CommandType = adCmdStoredProc
Set rstreset = comresetrwi.Execute
untuk belajar lebih jauh buka saja msdn nya ....
--- edi putra <[EMAIL PROTECTED]> wrote:
>
>
> Dear All.....
>
> Saya baru belajar menggunakan database sql server
> melalui VB.6, Di SQL server saya membiat suat store
> Procedure trs gimana ya caranya mengakses atau
> mengaktifkan Store Procedure tersebut dari VB,
> seperti
> dari delphi
>
> Mohon pencerahan
>
> Saya Ucapkan trima kasih sebelumnya.....
>
> Best Regard
>
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
