Connecting to a SQL database & INSERT COMMANDS

[machina12]

Familiar with linking to sql using php and java.
Is it much different with VB?

Have a SQL database.
Know the UID, PSWD, Server Name & Database

What is code format for linking to SQL Database corrcetly?
Are "Dim"s needed?


Then, I am familiar with INSERT commands, but what special tags does it require to run normal sql queries? Very important!


Need to know both answers, but connecting to the database is the first step.
Thanks for any feedback.

-machina12

[SkinHead]

What version of VB are you using ?

If its VB6, Then check out the ADODB.Connection & ADODB.Command objects

If you haven't got the MSDN library installed, then Run Google searches.