Printable View
If generating a select statement brings back an error (ie. it won't do anything for you while using the wizard), is it POSSIBLE that a setting on the DB server could be preventing the use of ado.net technology? I have had no luck creating an adapter and I suspect our db server is the culprit but I wouldn't know where to look if so.
Well if ODBC is all working okay, then perhaps its just an issue with your code?
can't be my code...I'm not usng any lol. I'm using the Wizard to do it for me. :)
Ahhh..... which wizard ?
um...you know when you drop a data adapter onto your form? It's the Data Adapter Configuration Wizard.
I've tried the same technique with other tables and it doesn't complain. I can only assume the table is somethow not letting me use the adapter. :confused: