Jadi yg best practice yg bagaimana?
tolong di share disini dunk.. :)
On Thu Jun 17th, 2010 5:11 AM EDT johan max wrote:
>
>
>Sekedar komentar kode dibawah ditekankan untuk sekedar jalan tapi tidak
>mendukung best practices :
>1. tidak ada configuration manager (sql connection dihardcode)
>2. password disimpan dalam plain text
>3. tidak terminate gracefully.
> Connectionnya tidak ditutup dalam kondisi apapun
> (baik error atau tidak)
>4. timeout tidak diset
>5. ui akan frezee dengan kode ini. harus pake thread
>
>
>
>________________________________
>From: Edy WIYONO <edy.wiy...@yahoo. co.id>
>To: programmer-vb@ yahoogroups. com
>Sent: Wed, June 16, 2010 10:52:58 PM
>Subject: RE: [programmer- vb] Compact Sql Server 2005
>
>
>Mungkin seperti ini:
>
> Dim cnn As New ADODB.Connection
> Dim strConnect As String
>
> strConnect = "DRIVER={SQL
>SERVER};SERVER= PC_ANESS; DATABASE= DB_ANESS; UID=USER_ SQL_SERVER_ ANESS;PWD=
>PASSWORD_ ANESS"
>
> ‘contohnya
> ‘strConnect=DRIVER= (SQL
>SERVER);SERVER= PS001;DATABASE= DB_LATIHAN; UID=sa;PWD=’’”
>
> cnn.ConnectionStrin g = strConnect
> cnn.Open
> cnn.Execute "DBCC SHRINKDATABASE( NAMA_DBMU)",
>False, True
>
> Set cnn = Nothing
>
>
>Ganti PC_ANESS dengan nama SERVER
>DB_ANESS dgn nama DATABASE
>UID_SQL_SERVER_ ANESS dgn nama login ke SQL
>Server , misalnya sa
>PASSWORD_ANESS dgn password dari login
>tsb.
>
>
>
>Salam Hangat dan Jabat Erat
> EdyWiyono
>
>
>
>________________________________
>
>From:programmer-vb@ yahoogroups. com [mailto: programmer-vb@ yahoogroups. com
>] On Behalf Of Anez Story
>Sent: Thursday, June 17, 2010
>10:10
>To: programmer-vb@ yahoogroups. com
>Subject: Re: [programmer- vb]
>Compact Sql Server 2005
>
>
>dear johan max,
>
>iya ada. pesan nya :
>compile error :
>sub or function not defined
>
>tapi kalau saya coba jalankan di query analyzer di sql server 2005 sukses..
>
>
>
>________________________________
>
>From:johan max
><johans...@yahoo. com>
>To: programmer-vb@ yahoogroups. com
>Sent: Wed, June 16, 2010 7:45:57
>PM
>Subject: Re: [programmer- vb]
>Compact Sql Server 2005
>
>
>Ada pesan kesalahan ?
>
>
>
>________________________________
>
>From:Anez Story
><anez_st...@yahoo. com>
>To: programmer-vb@ yahoogroups.
>com
>Sent: Thu, June 17, 2010 8:02:26
>AM
>Subject: Re: [programmer- vb]
>Compact Sql Server 2005
>
>
>dear johan max,
>
>terima kasih atas tanggapan nya..
>saya sudah coba jalanin lewat vb 6 kok ga bs ya?
>mohon pencerahan nya..
>
>
>
>________________________________
>
>From:johan max
><johans...@yahoo. com>
>To: programmer-vb@ yahoogroups.
>com
>Sent: Wed, June 16, 2010 12:20:55
>PM
>Subject: Re: [programmer- vb]
>Compact Sql Server 2005
>
>
>
>DBCC SHRINKDATABASE( NAMADATABASE) ,.
>harus dba atau sysadmin atau storageadmin
>
>
>________________________________
>
>From:Anez Story
><anez_st...@yahoo. com>
>To: Programmer VB
><programmer-vb@ yahoogroups. com>
>Sent: Wed, June 16, 2010 10:17:36
>AM
>Subject: [programmer- vb] Compact
>Sql Server 2005
>
>
>dear all,
>
>ada yang tau cara compact database sql server 2005 melalui coding vb 6?
>thanks
>
>best regrads,
>
>story
>
>
>
>
>
>
>
>
>
>
