Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 how to create sql database in visual basic

Author  Topic 

sal21
Starting Member

8 Posts

Posted - 2007-01-11 : 09:21:04
First i am newbie in vb and Sql server...

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

Database name: mydatabase
Database Table: mytable

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

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-11 : 09:49:15
Do you want to attach existing database file or you want to create new database along with some table structures?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

sal21
Starting Member

8 Posts

Posted - 2007-01-11 : 09:52:42
quote:
Originally posted by harsh_athalye

Do you want to attach existing database file or you want to create new database along with some table structures?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"


Tks from Italy
Yes... create database and table with the fileds in first post described, and after the creation, attach in instance....
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-11 : 10:02:08
You can create script file (.sql) to create database and tables and execute it by using osql utility. Why do you want to do it in the front-end?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -