System.Data.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near

[Patrick.O.Ige]

Hi guys,
I'm getting error:-
System.Data.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local) ;database=North wind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(c onnString)
objConnection.O pen()

Dim sSQL As String = "SELECT Sub_category_id ,sub_category_t ext FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(conn String, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

catlist.DataSou rce = objDataReader
catlist.DataBin d()

[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.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local) ;database=North wind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(c onnString)
objConnection.O pen()

Dim sSQL As String = "SELECT Sub_category_id ,sub_category_t ext FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(conn String, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

catlist.DataSou rce = objDataReader
catlist.DataBin d()

[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.Exec uteReader(Comma ndBehavior.Clos eConnection)

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.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local) ;database=North wind;integrated
security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(c onnString)
objConnection.O pen()

Dim sSQL As String = "SELECT Sub_category_id ,sub_category_t ext FROM
Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(conn String, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

catlist.DataSou rce = objDataReader
catlist.DataBin d()

[Patrick.O.Ige]

Does anyone have an idea what i'm doing WRONG!!
"Patrick.O. Ige" <Pa*********@di scussions.micro soft.com> wrote in message
news:1F******** *************** ***********@mic rosoft.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.Exec uteReader(Comma ndBehavior.Clos eConnection)

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.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near '='.
What could cause this ERRORR
My code below:-
Dim connString As String = "server=(local) ;database=North wind;integrated security=true;"
Dim objConnection As SqlConnection
objConnection = New SqlConnection(c onnString)
objConnection.O pen()

Dim sSQL As String = "SELECT Sub_category_id ,sub_category_t ext FROM Sub_Category"

Dim objCommand As SqlCommand
objCommand = New SqlCommand(conn String, objConnection)

Dim objDataReader As SqlDataReader
objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

catlist.DataSou rce = objDataReader
catlist.DataBin d()