problem connecting to db using odbc
Hi, I'm trying to learn how to program for database interaction, I'm using odbc, I've tried multiple ways, and I actually can connect to my db but I am getting a pop up box to connect instead of my program directly connecting. I think my problem is in the db.open statment, but I don't completely understand all the perameters that the statment uses. here is the statement I using :
db.Open("ODBC; DSN=MYDB;");
can anyone help explain what db.Open needs to correctly call and open the db. I've been searching google, codeproject and cboard trying to find some examples or explanations but I am still confused on the examples. I'm pretty sure my db is registered correctly in for odbc calls. I used the trace option in the data source manager in control panels to find out why it was not connecting properly and I noticed a re-occurring error while attempting to connect about missing driver for db open.
Any help would be greatly appreciated. Thanks-
still scratching my on ODBC connect
Well, the article makes good sense and definately gives me a better understanding of data source names and how they are used, but when I clicked on the msdn links, I still can't find a good article that depicts the connection process and the necessary attributes for a successful call.
Unfortunately, I'm still green on the C++ side, so if I can't see how the writer is using the code with a reference to the program, its hard for me to understand what the proper syntax should be.
Sorry for the lacking knowledge. I'm really hoping I can find a way to use a string to that lists all the necessary protocols for the .Open command. I just don't know what to feed the string in order for it to work properly.
Thanks in advance for any help?