its not the server connectivity that is the issue. its the format of the SQL within the file i am trying to create the tables from within the database. its not liking the format.

Quote Originally Posted by sallushan
I have used the simplest Query and it worked.

Code:
Dim objConn As SqlClient.SqlConnection
Dim objCmd As SqlClient.SqlCommand

objConn = New SqlClient.SqlConnection("Data Source=(local);Initial Catalog=master;Integrated Security=True")
objCmd = New SqlClient.SqlCommand("SELECT * FROM sysusers", objConn)

objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

objCmd.Dispose()
objConn.Dispose()
Maybe there is some issue with your SQL Server Connectivity, what is the actual exception?