Halo, Kawan2, mau tanya dong... saya pemula banget nih di VB (telat ya ?... :( ) Saya mau coba install SQL 2000 di pc kantor saya. Sedangkan PC saya OS nya WinXP. Katanya gak bisa ya install SQL2000 di XP ?. Solusi nya gimana ya ?... please....
Pada tanggal 12/29/05, A. Numairullah <[EMAIL PROTECTED]> menulis: > > Dear All Pakar² VB, > > Sy sedang buat program dengan VB 6 db SQL Server 2000, > Connection String/script yang sy gunakan sbb : > > Dim WithEvents dbPO As ADODB.Connection > Dim WithEvents rsPO As ADODB.Recordset > > Set dbPO = New ADODB.Connection > dbPO.CursorLocation = adUseClient > > dbPO.Open "PROVIDER=SQLOLEDB;" & _ > "Data Source=" & ServerName & ";" & _ > "Initial Catalog=" & DatabaseName & ";" > & _ > "User Id=" & dbUserName & ";" & _ > "Password=" & dbPassword & ";" > > dbPO.Execute "set dateformat dmy" > > Set rsPO = New ADODB.Recordset > rsPO.Open "Select * From PORDERS Order By NOSO", > dbPO, _ > adOpenDynamic, adLockBatchOptimistic > > 'fungsi utk seeting header datagrid dan > menampilkan data ke > 'data grid > SetHeaderDataGrid > > Table PORDERS tsb mempunyai ± 16.000 record, mengapa > saat load recordset sampai di tampilkan ke datagrid > prosesnya lumayan lambat ± 2 menit. Bagaimana jika > jumlah recordnya > 100.000 ? Wah pasti lebih lambat > :-( > Apakah ada script yang perlu ditambah. Mohon rekan² > ada yang bisa membantu memberikan solusi. > > Utk informasi : > PC sy P4 2.4GHz, Ram 512 MB, OS Win98 > Server sy memang sudah renta sih :-) HP Netserver E800 > 900Mhz, Ram 256 MB > > > Thanks before & Happy New Year 2006. > > > rgds > > > > > > __________________________________ > Yahoo! for Good - Make a difference this year. > http://brand.yahoo.com/cybergivingweek2005/ > > > > Untuk berhenti berlangganan kirim email kosong ke : > [EMAIL PROTECTED] > > Ikuti juga forum diskusi VB.net dengan > mengirim email kosong ke [EMAIL PROTECTED] > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-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/
