Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

how to create sql database in visual basic

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
[321 byte] By [luca90] at [2007-11-11 10:10:08]
# 1 Re: how to create sql database in visual basic
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.
vbdll at 2007-11-11 23:43:26 >
# 2 Re: how to create sql database in visual basic
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 Weller at 2007-11-11 23:44:26 >
# 3 Re: how to create sql database in visual basic
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
luca90 at 2007-11-11 23:45:25 >