"Keyword not supported: " error in ASP .NET

Question

i get a Keyword not supported: '192.168.1.1;initial catalog'. error when trying to do this

Dim cn As New SqlConnection(str)

where str is the connection string starts with '192.168.1.1;initial catalog' ... I have not specified the provider in the connection string

Answer 1

you need to provide a properly formatted connectionstring such as:

Dim str As String
str = "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"

Dim cn As New SqlConnection(str)

Answer 2

You have to specify the database with the keyword "Data Source" or "Server". Here's an example:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Answer 3

how do you creat an user id and pssword????