I'm running xp pro with sp2, not sure could it block the connection to the sql server? I haven't applied any service packs, but going to try adding 3a to...

Hey guys,

Thanks for your sugguestions.....mark you were kind of right, I inputting the wrong datatype into the SQL statement  , which was completely...

Thanks for you replys, the program crashes at

userData.Read()

Have tried changing the sql statement to not include the single quotes, but it gives me a invalid column error if I...

I didn't realised Windows authentication was much stronger, I think it would be best to use your method.  

Thanks,

Brenden

Thanks guys for your sugguestions,

But I' managed to sort it, set up a sql server login, changed the connection properties so the connection string is simply datasource;initial catalog;user_id;password and found...