VB.NET

Your select command looks wrong you normally have the information after * in your projects config file (its in xml format). This information is not in the sql statement which is only for selecting information from tables in an SQL database. That information usually is passed to your sql connection variable you have in the above code. The select statement requires a table name.

For reference here are some proper sql connection strings I found on this website (I used the ones on this website myself when I ran into a similar issue):

http://www.connectionstrings.com/sql-server-2012

use sql server management studio to help develop the query for you (I use it to test my queries on test sql servers before I mess any data up at work) and if it does not execute in sql management studio then it might be incorrect.

Once you eliminate the impossible, whatever remains, no matter how improbable, must be the truth. - "Sherlock holmes" "speak softly and carry a big stick" - theodore roosevelt. Fear leads to anger, anger leads to hate, hate leads to suffering - Yoda. Blog - http://www.computerprofessions.co.nr