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! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
