Thank you Bassguy. Reading the exception in a little more detail did give me a clue as to where the problem was.
My application is now pulling data from the SQL server.
I have a table with data on our SQL2000 server. I have created a project in VB.NET. I can successfully establish the SqlConnection1, SqlDataAdapter1, and DataSet11. I can preview the data. I then put a DataGrid on the form and connect the DataSource and the proper field headers appear. I...
More info.....
I have established an OleDBConnection1. When I go through the wizard to create my OleDBAdapter1 it says: "Failed to get schema for this query."
Possibly this is a problem on my AS400 side. However, I can see the data in the query builder.
Thank you, Chip H., that helped (using Library.tablename). I think I've set up the OleDBConnection and OleDBData Adapter properly. My problem is still probably VB 101 - how to put on a control that is bound to a field on my AS400. I don't seem to have the same options as I did in 6.0. I...
Dimandja,
Yes, that is the error verbatim. I went to Microsoft's site to see if I could get help out there but didn't see anything. I don't have code out there per se (just what is built automatically as I created the form and controls). I want to build a bound controls to the fields I have...
I know a lot about VBA and a little about VB 6.0. I'm currently trying to use VB .NET to access data in a file called "vacation" in a library/collection called SQLDBA. I started a new VB project and set up my data connections. I can see the Vacation file and all the fields in it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.