Hello,

I am attempting to connect, I have changed the information in the app.config file. As I run the project it returns this error:

Could not bind to the new display member. Parameter name: newDisplayMember.

Some basic info - I am logged on as the admin, I know the connection string as it works with other DB's. I stepped thru the code, as it is going thru the steps on main.vb it goes thru Dim objAdmin as New Admin, and then at objAdmin.ShowDialog the Error message pops up.

Anyone have any ideas?

Thanks, Chuck

Chuck,

Could you specify what chapter and exercise you are working on and exactly where the error occurs. It would also be helpful to know whether you are working with SQL Server or Oracle as this sounds like an error that would occur with Oracle binding a member name to a combo box.

Thearon

Hey Thearon,

Thanks for responding. I'm just attempting to load the chapter 9 SQL Server App. I'm not sure what info to give you as I am fairly new still. I am a programing student - I also work in the computer lab where I go to school this server is on a network. I have created other DB's and have connected to them so I am unsure what is happening here.

Chuck

Chuck,

I assume you are working through the Accessing SQL Server or Oracle exercise. Please verify that the Data Source key in your app.config file specifies the name of the server where SQL Server is running and that the Initial Catalog key specifies the database of ProjectTimeTracker. I assume this database has already been created on this server since you are now at this point and that you have already created the stored procedures in that database. Next ensure that you specify your SQL Server user name and password for the User ID and Password keys in your app.config file. If you are logging in as the admin then this would be the user id of 'sa' and the appropriate password.

Thearon

Yes the app.config file is config'ed correctly. I believe we have Windows Authentication. My boss requested that I modify a Senior Project for the computer lab that I work in. This sign in system did not work as it should. I have used the methods modeled in your book to tweak the app and have made good progress. Thank you for that, I have learned alot but have about a million questions. But I am rambling - The app.config file for the sign in system connects fine with windows authentication. I was running the Chapter 9 app at home to study your methods. I just wanted to do the same at work.


Additional positive feedback - I appreciate the "starting at the ground floor and ending up with a proffesional app" method.

Chuck

Chuck,

You need to step through the code for the Admin form to find the exact point of the error in order to give more more information to work with. I'm sorry I can't be more help at this point but it sounds like you have your app.config file set up correctly, are making a connection to the database but that some other problem exists.

Thearon

I'm thinking the same thing, I started Ch. 10 last night and so lets not pursue the solution to this dilemma any longer. I work in a computer lab where I have to troubleshoot and answer student's questions all day long - I have to "see" what the problem is, I can't imagine troubleshooting something thru email or over the phone, so I understand. Thanks again for the attempt.

Chuck