Quote Originally Posted by jmcilhinney View Post
Um, it is VB.
Doh idiot, I am stuck trying to get it to connect to a remote SQL server I have added the remote connection strings to my app config and kept the other referances the same for now (same DB tables) if I run the app with tableadaptor I get "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." error on this line

Code:
Return adapter.GetUserCountByUserNameAndPassword(Me.UsernameTextBox.Text.Trim(), _
                                                             Me.PasswordTextBox.Text).Value > 0
if I try to run it as a data adaptor I get this error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'."

and ideas

thanks

M