Unable to connect to SQL with VC++

Hi, I'm trying to connect to sql server through my VC++ program, when I go to the "test connection" it shows me a message telling me that my connection is successful, but when I try to run the program I just see an error message telling me that it can not connect to my db's columns ( records ). So, what's the problem? Once it tells me that it's nothing wrong with the connection, and then it fails to connect. Any help/idea would be greately appericiated.

Well, it might be because you're writing in lower case, while SQL is installed in the way that it DOES make a difference between lower case and upper case characters or vice versa. As you know we can define the code page, sort order and also case sensitivity, kara and ... in SQL installation.