how to create sql database in visual basic

[luca90]

Is possible to create, via vb classic or VBA, a sql database in this instance:\\DVD377-14D9E48C\SQLEXPRESS...
I have Sql Express.

Database name: mydatabase
Database Table: mytable

fileds:
fiedl1 text
fiedl2 text
fiedl3 text
fiedl4 date
fiedl5 number
fiedl6 text

[vbdll]

as my limited knowledge, you can create db in vb.net, not sure if you can do in pre Net vb. How about mdb?

How about XML or flat file, or you can try call store procedure.

[Ron Weller]

Here is a link to sample code for creating a SQL Server database. Which SQL Express essentually is.
http://www.freevbcode.com/ShowCode.Asp?ID=3211

[luca90]

Here is a link to sample code for creating a SQL Server database. Which SQL Express essentually is.
http://www.freevbcode.com/ShowCode.Asp?ID=3211

Ron excellnet link!
But sorry me, where i insert the name of my instance/SERVER, assumed is called:CL259F4500

... and i have not pass and user asssigned (i use Windows autentication)
Tks for all.
Sal, from Italy