Thread: 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-

http://www.able-consulting.com/MDAC/...n/ODBC_DSN.htm

gg

Cool, Thanks Codeplug, I will review the link, thanks for the quick response.

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?

Hey, I finally got it, I was not accessing my dsn correctly in the string I created. Thanks again codeplug, your response pointed me to learning the dsn info I needed.