Question SQL Database

[AdamR]

Hey,

I am upto the stage in vb.net of interacting with databases, only i have one problem, and its a biggy.

I know the sytnax of SQL as i used to used it with coding php 4.1 years ago, but the problem is with the databse creation.

How do i create it? do i create the database through Visual Studio, or alternativly (i want a SQL Server Database).

I have tried both and have serious problems with open().

Also, when i created it i was, nowhere, prompted for to enter a username or password, and i have been told i should have been.

All help is highly appreciated, Thanks.

 

[Tom]

You can create the database right in Sql Server and it may already be set up for windows authentication which is why it isnt prompting for login & password

 

[cjard]

And what kind of database are you creating?