Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


SQL Server Direct Access

Posted on 1999-07-12
Medium Priority
Last Modified: 2013-11-20
Right now, I'm using CDatabase & CRecordset for ODBC programming. But that's require that ODBC DSN must be set.

Is there anyway that we can directly retrieve recordset from the SQL server without setting the DSN?

Question by:ymw1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 1309552
If you want to use ODBC, then you HAVE to use DSN. The access the MS SQL Server, the only simple way is use ODBC (Also you can use ADO, RDO, or JDBC::ODBC. But they all established upon ODBC)
Yes, there is really another way to access the SQL Server. Directly call it through it's TCP/IP or namepipe protocol.
There's no open document for this. You need to try it yourself.
I do not know why you can not use DSN?


Author Comment

ID: 1309553
Becos I have hundreds of client PCs! And I have to use MFC C++ :(

And the client applications need to connect to the SQL server.....


Expert Comment

ID: 1309554
This means to you installing DSN on every client?

Accepted Solution

jonalee earned 100 total points
ID: 1309555
Hundreds of client connect to your MS SQL Server? Oh. M$ software's lisence is expensive. If you have hunderds of clients connect to your SQL Server, that may need  hundreds of client lisence. :-)

Why no use RPC or CORBA or DCOM. You client just connect to your server. Then you only need to establish SQL connection on your Server. Your client can be any OS platform, even Unix. Then you will not have the headache of install DSN on every client.
Also, ODBC SDK has the ability to create DSN on the fly. Please check the "SQLConfigDataSource" function.
But even if you can create DSN on the fly, you still need to install ODBC driver on every of your clients. Tons of work, right.


Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
Introduction: The undo support, implementing a stack. Continuing from the eigth article about sudoku.   We need a mechanism to keep track of the digits entered so as to implement an undo mechanism.  This should be a ‘Last In First Out’ collec…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question