471,892 Members | 1,318 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,892 software developers and data experts.

Connecting to a SQL database & INSERT COMMANDS

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
Jul 11 '07 #1
1 1097
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.
Jul 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by John | last post: by
2 posts views Thread by bryja_klaudiusz[at]poczta[dot]fm | last post: by
4 posts views Thread by Jonathan Upright | last post: by
1 post views Thread by dirk van waes | last post: by
6 posts views Thread by Antonio | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.