StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhy can't I get my CDatabase object to understand my Data Source Name?
primarykey
Id
725046
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-04-07T10:44:05.830
FavoriteCount
0
LastActivityDate
2009-11-16T15:58:11.783
LastEditDate
2009-04-07T11:54:25.037
LastEditorUserId
11575
OwnerUserId
11575
ParentId
0
PostTypeId
1
Score
1
ViewCount
2332
LastEditorDisplayName
text
Body
I'm using the MFC class CDatabase. To establish a connection to SQL Server, I'm calling OpenEx() with a connection string. My problem is that the object seems unable to interpret the DSN part of the string. The connection string looks like this: <pre><code> ODBC;DSN=mySystemDSN;UID=myUsername;WSID=myMachineName;DATABASE=myDatabaseName;Trusted_Connection=Yes </code></pre> That ought to be right because I got it by using OpenEx( NULL ), choosing the data source manually and then calling GetConnect(). But this string doesn't seem to contain enough information: OpenEx() always pops up a dialogue asking for more. It doesn't seem to matter what I choose from this dialogue - I can pick a DSN associated with a completely different database and things still work (a call to GetConnect() in that situation shows that it's using my connection string except for the DSN part, which is borrowed from the other data source). I need my application to be able to connect to the database automatically - dialogue boxes are a deal-breaker. I've tried a DSN-less connection with similar results. What's going on here, and what can I do about it? edit in answer to Neil Butterworth's question: The information I provided when I created the DSN in the ODBC Data Source Administrator was as follows: driver: SQL Server name: mySystemDSN server: myMachineName authentication type (can be Windows or SQL Server): Windows checkbox "Connect to SQL Server to obtain default settings for the additional configuration options.": ticked checkbox "Change the default database to": ticked and myDatabaseName chosen from drop-down menu checkbox "Use ANSI quoted identifiers": ticked checkbox "Use ANSI nulls, paddings and warnings": ticked checkbox "Perform translation for character data": ticked
Tags
<c++><sql><sql-server><mfc><odbc>
Title
Why can't I get my CDatabase object to understand my Data Source Name?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTommy Herbert
UserOwnerUserId
1. USTommy Herbert
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.