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-