<div>
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)<br />
Yes, there is really another way to access the SQL Server. Directly call it through it's TCP/IP or namepipe protocol.<br />
There's no open document for this. You need to try it yourself.<br />
I do not know why you can not use DSN?<br />
<br />

</div>


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?



<div>
Becos I have hundreds of client PCs! And I have to use MFC C++ :(<br />
<br />
And the client applications need to connect to the SQL server..... <br />
<br />

</div>


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.....



<div>
This means to you installing DSN on every client?<br />

</div>


This means to you installing DSN on every client?


<div>
<div class="content wysiwyg-content">
Right now, I'm using CDatabase &amp;&nbsp;CRecordset for ODBC programming. But that's require that ODBC DSN must be set.<br />
<br />
Is there anyway that we can directly retrieve recordset from the SQL server without setting the DSN?<br />
<br />
Thanks
</div>
</div>


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?

Thanks

SQL Server Direct Access

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.