Sorry nih nyelak Pake Subject yang sesuai donk, biar tertib and enak bacanya, biar milis ini tambah rame, kemarin milis ini hampir2 ditinggalin membersnya karena ya.. hal-hal kecil kaya gini. Apalagi moderatornya lagi pasif nih sekarang...Sory Pak Moderator (nyenggol dikit ah...) Padahal kita semua bisa dapat banyak ilmu dan informasi dari tanya jawab semacam ini. GRATIS lagee.... :-)
Sorry nih cuma masukan aja :-) --- eko suharto <[EMAIL PROTECTED]> wrote: > Ada 2 cara pak........ > - Install SQL Server 2000 versi personal > edition..........bukan enterprise........soalnya > kalo enterprise minta platform OS nya win 2000 or > 2003 > - Install MS virtual server trus baru install sql > server 2000 enterprise edition di atas virtual > server tersebut............. > > Kenapa nggak langsung aja ke sql versi 2005, khan > ada yang versi express edition..........itu bisa > langsung di install di XP....... > Free and legal...... > > Regards, > Eko Suharto > ----- Original Message ----- > From: Sony Aryo > To: [email protected] > Sent: Wednesday, December 28, 2005 8:38 PM > Subject: Re: [indoprog-vb] Load Recordset Lambat > ??? > > > 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] > > > > Untuk berhenti berlangganan kirim email kosong ke > : [EMAIL PROTECTED] > > Ikuti juga forum diskusi VB.net dengan > mengirim email kosong ke > [EMAIL PROTECTED] > > > > > SPONSORED LINKS > Computer internet security > Computer internet business > Computer internet access Computer > internet privacy securities Computer > internet help > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "indoprog-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. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! DSL Something to write home about. Just > $16.99/mo. or less > > [Non-text portions of this message have been > removed] > > __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/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/
