Help with sqldataadapter

[markprog]

I am working on filling a dataset with an SQL table from our SQL 2000 Server.

When I go to do the .Fill with the dataset I receive a System.Data.SqlClient.SqlException error "Invalid object name"

my code follows:

Dim strSQL As String
Dim strConn As String
Dim objSQLDA As SqlClient.SqlDataAdapter
Dim objOrders As New Data.DataSet

strConn = "server=MYSERVER;" & _
"database=MYDBS;" & _
"user=MYUSER;" & _
"password=MYPASSWORD;"

strSQL = "SELECT * FROM orders"

objSQLDA = New SqlClient.SqlDataAdapter(strSQL, strConn)

objSQLDA.Fill(objOrders)

Any help would be appreciated.

 

[tebathe3]

Did you import the system.data.sqlclient ?

 

[markprog]

Never mind.

My orders table wasn't called "orders".

"I picked the wrong week to stop sniffing glue

 

[tebathe3]

lmao!!!!! i love that movie. Glad you fixed it!

 

[ThatRickGuy]

Oh, I've had that problem befor too.

Me: "Why wont this dang SQL work?"
DBA: "For the Orders table?"
me: "Yeah! see look, my SQL is good!"
DBA: "For the Oreders table maybe."
me: "I'll go flog myself now, thank you."
DBA: "Don't mention it."

-Rick

----------------------

http://www.ringdev.com