Doubt on database connection!!

[sania21]

hi all

i have a doubt regarding database
programming in VB,actualy i want to know
how can we create a database in SQL
and then connect the database with VB
application so that by using sql queries we can
access the tables in database.............

i am a bit familiar with programming in VB
like using connection object we execute
the queries

as below
str="select * from table1"
conn.execute(str)

but mainly i want to know

how we create database in SQL
How we connect to that database in VB
so that we can access tables and all!!!


any help on the above will be realy
helpful thnx in advance.............!!!!!

[TcM]

VB 6.0 or VB .NET?

[sania21]

Hi thr

It is in VB 6.0


Sania:>Its too soon to quit!!!!

[sania21]

Hi all

can anyone please please help
me with my doubts which
i have mentioned above.......


any help will be realy kinda of you


thanks in advance.