dari jawaban mas agung, saya coba tambahkan lagi mungkin 
biar lebih mudah dan komplex :)

klu bisa koding ini ditaruh dimodule
public  servernya, databasenya, usernya, passwornya, 
kodesqlnya as string

servernya = "nama_server"
databasenya = "namadatabase"
usernya = "namausernya"
passwornya = "namapasswordnya"

    db.ConnectionString = "Provider=SQLOLEDB.1;Persist 
Security Info=False;User 
ID=[usernya];password=[passwordnya];Initial 
Catalog=[databasenya];Data Source=[servernya]"


On Mon, 14 Nov 2005 21:51:01 -0800 (PST)
  Asral Sukma <[EMAIL PROTECTED]> wrote:
> Hi....
>  saya coba bantu ya..dan saya yakin smua anggota milis 
>dah gape bnget ama code ini..
>  
>  coba gunakan :
>      db.ConnectionString = "Provider=SQLOLEDB.1;Persist 
> Security Info=False;User 
>ID=[username];password=[password];Initial 
> Catalog=[database name];Data Source=[com name]"
>  
>  semoga membantu
>  
>  --aL--
> 
> agung supriyanto <[EMAIL PROTECTED]> wrote:          Para 
>senior gw mo nanya, gimana caranya coneksi
>  program vb ke data base sql server, selama ini gw
>  belajar koneksi ke accsess aja.
>  
>  Terima Kasih.
========================================================================================
Ikuti Lomba Foto Wisata 2005, kirimkan foto-foto terbaik Anda. Pengiriman mulai 
1 November s.d 31 Desember 2005. Keterangan lengkap ada di 
http://lombafoto.telkomnetinstan.com/ dan dapatkan hadiah jutaan rupiah!! 
(khusus Jawa Timur)
========================================================================================
 


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~-> 

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/
 


Kirim email ke