Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 21, 2012 08:54 PM by zevian
Nov 21, 2012 08:17 PM|LINK
Private Sub SqlClientPermission(value As Boolean)
allowBlankPassword = True
Function CreateCommand() As SqlCommand
Dim sqlconnectionCommand As New SqlConnection("
Dim sqlqueryString As String = "SELECT ColorTable.* FROM ColorTable"
Dim sqlqueryCommand As New SqlCommand(sqlqueryString, sqlconnectionCommand)
'Printing Out the SQL Result
Does anyone have suggestions to accomplish a database connection by the code above?
I am getting the error message:
Login failed for user 'xxxx_user-PC\xxxx_user'.
By the current version of .NET 4.5 and Microsoft SQL Server Express I do not have an
executeable program in the programs menu for the Microsoft SQL Server, since I often have gotten recommended to check the
access permissions in the security settings.
Also, are there any alternatives I could try to accomplish an established database connection?
The Tools Used: Visual Studio 2012, VB .NET 4.5 MVC 4, Microsoft SQL Server Express
Nov 21, 2012 08:52 PM|LINK
Sorry, but did we not answer your question earlier today or am I dreaming things? I know that coffee at this hour is usually not such a good idea ;-) but I think I remember replying to a similar post today...anyway...I noticed that you do not provide a value
for the password in the connectionString. Are you hiding it from us or have you forgotton to add a value in your solution?
Hope it helps
Nov 21, 2012 08:54 PM|LINK
I am actually not using a password - thus the "allowBlankPassword".