using sql server together with vb

[kucing]

hi guys....can someone expert guide me how to connect a database in sql server with visual basic, ive read other tutorial but seems its hard to understand and failed to applying in my program. should i use the odbc instead of jet or else. all help and opinion are welcome and thanks. :P :confused:

[ammo]

Check out ADO (ActiveX Data Objects)
There are plenty of examples on the web.

Ammo

[99¢]

ammo is correct, you would most likely use a DLL reference...
"Microsoft ActiveX Data Objects *.* Library"