Dear Temen2 Milis..
Cara dari bung Sila Yoga & Adi Santoso sudah berhasil, terima
kasih....4 All
Mo nanya lagi nih bagaimana cara nge-LAN-nya.
Sebagai informasi aku pakai Con ODBC, Driver MyODBC 3.5 dan MySQL 5.0
dim rs as adodb.recordset
SQLString ="Select....."
Set Rs = CreateObject("adodb.recordset")
Rs.CursorLocation = adUseClient
Rs.Open SQLString, "DATABASE=Main;DSN=SKI Supadio Pontianak;" &_
"OPTION=�~~�c~;PWD=*****;PORT=0;SERVER=localhost;UID=root",
adOpenStatic, adLockReadOnly
Apa saja yang perlu ditambahkan dan Perubahan Setting Mysql nya?.
Thanks atas Jawabannya....
safrullah
[EMAIL PROTECTED]
--- In [email protected], sila yoga <[EMAIL PROTECTED]>
wrote:
> coba RsReport.CurcorLocation = aduseclient
>
> RsReport.CursorLocation = aduseclient
> RsReport.Open StrSql, Con, adOpenStatic, adLockReadOnly
>
> Adi Santoso <[EMAIL PROTECTED]> wrote:
> Coba mas Open keyset dan Lock nya diganti
>
> misal
>
> RsReport.Open StrSql, Con, adOpenStatic, adLockReadOnly, adCmdText
>
>
> regard,
> Adi
>
> safrullah <[EMAIL PROTECTED]> wrote:
> Halo temen2 milis smua..
> mohon maaf klo udah pernah ditanyakan.
> Aku mo nanya kenapa pd mysql properti recordcount selalu hasilnya -
1.
> mungkin ada sintaks lain.Selama ini aku pakai rs.recordcount.
> atas atensi dan respon saya ucapkan trima kasih
>
>
> Safrullah.
> [EMAIL PROTECTED]
>
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> 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 the Yahoo! Terms of
Service.
>
>
>
> ---------------------------------
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour
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/
