System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near

[Patrick.O.Ige]

Hi guys,
I'm getting error:-
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local);database=Northwind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(connString)
objConnection.Open()

Dim sSQL As String = "SELECT Sub_category_id,sub_category_text FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(connString, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

catlist.DataSource = objDataReader
catlist.DataBind()

[ranganh]

Hi,

You need to remove the braces in the connection string for servername
server=(local) needs to be server=local.

Hope it helps.

"Patrick.O.Ige" wrote:

Hi guys,
I'm getting error:-
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local);database=Northwind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(connString)
objConnection.Open()

Dim sSQL As String = "SELECT Sub_category_id,sub_category_text FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(connString, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

catlist.DataSource = objDataReader
catlist.DataBind()

[Patrick.O.Ige]

Hi Ranganh and thanks for the email,
I don't think that is the error i tried inputting local but it says
SQL Server does
not exist and i have other aaplications connected to the DB with the same
connection String.

The Error is on line below :-
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

Thats what the Error is saying!!
Any help any ideas!!
"ranganh" wrote:

Hi,

You need to remove the braces in the connection string for servername
server=(local) needs to be server=local.

Hope it helps.

"Patrick.O.Ige" wrote:

Hi guys,
I'm getting error:-
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local);database=Northwind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(connString)
objConnection.Open()

Dim sSQL As String = "SELECT Sub_category_id,sub_category_text FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(connString, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

catlist.DataSource = objDataReader
catlist.DataBind()

[Patrick.O.Ige]

Does anyone have an idea what i'm doing WRONG!!
"Patrick.O.Ige" <Pa*********@discussions.microsoft.com> wrote in message
news:1F**********************************@microsof t.com...

Hi Ranganh and thanks for the email,
I don't think that is the error i tried inputting local but it says SQL Server does
not exist and i have other aaplications connected to the DB with the same
connection String.

The Error is on line below :-
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

Thats what the Error is saying!!
Any help any ideas!!
"ranganh" wrote:

Hi,

You need to remove the braces in the connection string for servername
server=(local) needs to be server=local.

Hope it helps.

"Patrick.O.Ige" wrote:

Hi guys,
I'm getting error:-
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local);database=Northwind;integrated security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(connString)
objConnection.Open()

Dim sSQL As String = "SELECT Sub_category_id,sub_category_text FROM Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(connString, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

catlist.DataSource = objDataReader
catlist.DataBind()