CDaoDatabase And MS SQL

You indicate that you will allow the user to input a DSN... but then you also indicate that you want to use DSN-less connection.

If you have a DSN (as set up in the ODBC control panel) then it is very easy to work with databases using MFC.  Let me know if that is the case and I'll cover it.

If you do not have a DSN, then your best bet is probably to use ADO database access.   A very simple example of that is shown here:

   How to connect to sql server 2K?
   https://www.experts-exchange.com/questions/20534401/How-to-connect-to-sql-server-2K.html

Here is a project in which a guy wrapped that all up into an MFC object:

   ARSdb - Abstracted Database and Recordset Classes
   http://codeguru.earthweb.com/mfc_database/arsdb.shtml

You can also create an ATL data access object (which uses OLE DB), but that can be kind of ticky, what with all of the ATL stuff.

-- Dan

Dan,
Thanks for the reply.

If your read my orginal question I stated that I will allow for a DSN connection for SQL Server... but that I currently have code for DNS-Less connection for Access.

So I am wanting a way to connect to a SQL server with a DSN.

Alternatively you may refer this example at codeproject :

http://www.codeproject.com/database/sqlconnect.asp <=====

MAHESH

and also this :
http://support.microsoft.com/kb/q186383/

MAHESH

you also check this

https://www.experts-exchange.com/questions/21765012/Connecting-to-SQL-Server-and-getting-data-from-a-table.html


Raj

Dan,
Another good post.  But as my title said (and I should have been clearer), I'd like a solution with CDaoDatabase, not CDatabase.  Now I could convert my Dao code to CDatabase, but I think it would be easier to work with htat instead.

The rest of you that posted, not much help in the links you provided.

Dan,
You pointed me in the right direction, so you get the points.

But here is my final code for this to work:
CString      Sql;
AfxGetModuleState()->m_dwVersion = 0x0601; // Needed for Access 2000 and doesn't seem to hurt anything else.
AfxDaoInit();
CString sConnect;
CString sDSN= "testds";
CString sUser="test";
CString sPswd="test";

sConnect.Format("DSN=%s;UID=%s;PWD=%s",
              (LPCSTR) sDSN,
              (LPCSTR) sUser,
              (LPCSTR) sPswd
            );

db.Open("",FALSE,FALSE,_T(sConnect));
Sql = "SELECT * FROM ";
Sql.Insert(Sql.GetLength(), m_pSettings->struDatabaseInfo.strTable); //Finishes building my SQL string.
recset.Open(AFX_DAO_USE_DEFAULT_TYPE,Sql,dbSeeChanges); // I am assuming, would love a comment on this, that I can just put "test" (which is the table I am  using) instead of AFX_DAO_USE_DEFAULT_TYPE.

Thanks for your help.

The DAO recordset handling, based on the JET database engine, is generally considered obsolete -- having been supplanted first by ODBC (MFC CDatabase/CRecordset), then ADO (ActiveX), then OLE DB -- that's why I didn't mention it.  However, I can't think of any reason not to use it if it suits your purposes.

There are three forms of the CDaoRecordset::Open() fn and you ar using the first one in which the first paramerte is an integer nOpenTYpe and the value AFX_DAO_USE_DEFAULT_TYPE lets the system choose automatically between dbOpenDynaset, dbOpenTable, and dbOpenSnapshot (my read indicates that AFX_DAO_USE_DEFAULT_TYPE will equate with dbOpenDynaset).

The other two forms expect the first parameter to be a pointer to a CDaoTableDef object and I have no experience working with that object.  It is covered here:
    DAO Tabledef: Using Tabledefs
    http://msdn.microsoft.com/library/en-us/vccore/html/_core_DAO_Tabledef.3a_.Using_Tabledefs.asp

Note that it is possible to insert data, delete records, etc. without bothering with recordsets by using the CDaoDatabase::Execute() function.  Just compose a valid SQL statement and pass it in.  For instance,

    sSQL= "INSERT INTO MyTable (lastName,firstName,city) VALUES ( 'Jones', 'Tim', 'Tulsa' )";
or
    sSQL= "DELETE FROM MyTable WHERE lastName= 'Jones' ";

    db.Execute( sSQL, dbSQLPassThrough );

Dan,
I had another question and figured it deserved its own question (don't want to milk these 500 points)... if you could comment I'd appreciate it.

https://www.experts-exchange.com/questions/21813246/What-db's-can-I-claim-support-for.html