Member Avatar for pardeep3dec

Hi friends,
Please tell me how can i create database and user id through below code
i am gotting problem of user login failed. I don't know how can i create database,user through vb.net


Dim conn As New SqlConnection("Server=localhost;user id=;database =;")
Dim comm As New SqlCommand
comm.Connection = conn
comm.CommandType = CommandType.Text
Dim sql As String
sql = "CREATE DATABASE testDB"
comm.CommandText = sql
conn.Open()
comm.ExecuteNonQuery()
conn.Close()


Please help.

  • 2 Contributors
  • 1 Reply
  • 129 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by ptaylor965
Member Avatar for ptaylor965

The database connection string should be like this

Dim conn As New SqlConnection("Data Source=SERVER_NAME;Initial Catalog=DATABASE;uid=USERNAME;pwd=PASSWORD;")

If in your code you will be creating a database in SQL then you will have to connect to another database (in the connection string) first.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.