I've just found out that the magical number of '5 connections' isn't a licensing issue as I thought it was but that it is a 'maximum recommended'. Thus I don't have a problem anymore !!!!! BTW, this recommendation is apparently due to performance degradation for more than 5 connections. Is this true? I thought the only difference between MSDE and MSSQL was the management tools that come with MSSQL as the install size, structure and location seems to be identical. Thanks anyway to anybody who would have offered to help with my problem, which is no longer a problem. Damian

Howdy, Does anybody know whether the SQL max connections metric is process or thread based? ie If I have an SQL server with up to 3 connections and am running an app which sporns threads which connect to the database will the app have trouble upon more than 3 concurrent threads executing. If the connections are process based then this architecture will do fine. If howver SQL connections are measured on a thread basis then I'm going to have to rewrite the app. Thanks, Damian Del Campo

Sorry about that last comment, "my bad". I won't tell you what the problem was as its rather embarassing. Sorry again. Damian

Howdy, I downloaded you classes and was using them quite successfully. *However*, I had to convert my app to UNICODE as the clients require this. Since I've done that, I can't find any way of passing a connection to the CADODatabase. Open method simply doesn't like what I'm passing it (& I'm pressuming all methods will be the same). I've tried creating a char string and passing that to the database open function but it simply won't work either. All I get is an error message -> CADODataBase Error Code:80004005 Code meaning: Unspecified error Source:||||||||||||||| Description:|||||||||||||| Since I'm now passing it the same thing as I was before (char *) it should work, the fact that it doesn't makes me think that UNICODE must affect an include file that the ADO classes depend on in some way. Do you know how I can get around this ?????? Thanks, Damian Del Campo

Hi, I'm having big trouble accessing recorset elements. I'm using ODBC(MSSQL) with CDatabase and CRecordset objects, I can perform SQL executes, and even seem to open recordsets without bother but come into trouble when I try to access a recordset field. I have CDatabase* called pDB. I have used recordsets previously but only used to check the number of rows returned (and thus not attempted to read any fields). As far as I can tell there shouldn't be a problem here (I've copied most of this section straight from MSDN). The SQL statement returns a 1 row of 1 field recordset and the datatype of that element is varchar. Hi, I've written the following code char strSQL[2048]; try { sprintf(strSQL,"SELECT DataValue FROM dbo.SSEData WHERE (DataName = N'LOGON')"); printf("%s\n\n\n", strSQL); CRecordset rs(pDB); printf("Just setup Filter\n"); if ( rs.Open( CRecordset::snapshot, strSQL) ) printf("Just opened recordset\n"); else printf("Failed to open recordset\n"); if (rs.GetRecordCount() == (long)0){ printf("No records found"); } else { if ( rs.IsEOF() ) printf("The recordset was EOF"); if ( rs.IsBOF() ) printf("The recordset was BOF"); printf("Field Count : %d \n", rs.GetODBCFieldCount() ); rs.AssertValid(); printf("Recordset was greater than nothing\n"); CString CStartupMessage; CDBVariant CVariantField; printf("In between the first and last string\n"); // rs.GetFieldValue( (short)0, CVariantField ); rs.GetFieldValue( short(0), CStartupMessage); printf("Got the field value\n"); } rs.Close(); } catch(CDBException *e){ printf("Caught a DB exception\n"); e->Delete(); } catch(CMemoryException *m){ printf("Caught a memory error\n"); TCHAR ErrorMessage[256]; m->GetErrorMessage( ErrorMessage, 255); printf("Finished capturing error %s\n", ErrorMessage); } The Output from this code is: .... Just setup Filter Just opened recordset Field Count : 1 Recordset was greater than nothing In between the first and last string Caught a memory error Can anybody help me ???? Thanks, Damian Del Campo (damian_jose@yahoo.com)

Thanks, however my spec just changed again and the client want me to use SQL which isn't a problem. However they want me to access it using OLE which is a problem for me (I don't have a problem using ADO and ODBC but OLE looks ghastly to me). You can't help here can you ????? Thanks Damian Del Campo

Howdy, I built an app that used ODBC to write to an SQL database. The client has just turned around and said that they wish to use OLEdb connection strings to tell my app where the server is (instead of ODBC DSNs). Everything I've found on using OLEDB to access databases, is a whole pile of COM interface stuff with no real world examples. A far cry from the 'CDatabase' simplicity I'm used to. Can anybody help me with this ? All I need to do is to write some data via INSERT statements and do a few SELECT statements. I'm looking for some sample code or a tutorial with "real world" examples. Actually, anything that will help me do this in the few hours I have available to change my code. Thanks to anybody who can help. Damian Del Campo

Howdy, I built an app that used ODBC to write to an SQL database. The client has just turned around and said that they wish to use OLEdb connection strings to tell my app where the server is (instead of ODBC DSNs). Everything I've found on using OLEDB to access databases, is a whole pile of COM interface stuff with no real world examples. A far cry from the 'CDatabase' simplicity I'm used to. Can anybody help me with this ? All I need to do is to write some data via INSERT statements and do a few SELECT statements. I'm looking for some sample code or a tutorial with "real world" examples. Actually, anything that will help me do this in the few hours I have available to change my code. Thanks to anybody who can help. Damian Del Campo

Howdy, does anybody know how to connect to an MSAccess database directly (using the file not a DSN) with VC without using MFC? This database is also encrypted so it has a cmb & wgf as opposed to an mdb. Some source or examples would be a life saver I'll be eternally endebted to anybody who can help Thanks Desperate Damian

Howdy, I have to write a WinNT(4) service which checks a few directories and writes files to a database. The database is MS Access & it is accessed directly (ie not through ODBC) so I'd normally use AppWizard in VC to make an MFC with db support program. However, given that its an NT service, I'm writing it as a console application. 1) If I make it a console app with MFC support, does that blow the size of the thing sky high? 2) Can I access an MS Access database easily without using MFC functionality ? 3) Am I approaching this the correct way. Thanks for any help, Damian Del Campo

Howdy, I'm a Software Engineer using C++, I've got an Engineering degree so have a fairly relevant qualification already. I've been going through a MS press book on Desktop Applications for one of the exams for MCSD and am thinking of sitting the exam. My question is, what advantage will doing this exam(only)? What advantage would I get from having a MCSD? I mean do people who actually know about SE and C++ think that MCSD is value added to a few years of experience ?? Will it actually improve my employment prospects ?? Damian Del Campo BEng(CompSys Hons) Software Engineer

Hi, I currently use VC++6 and Win2K and have a few questions about the "next" versions. 1) .NET -> ¿Qué? What is this supposed to be? At first I thought that it was either something to make VB more "usable" in the way that MS has been going turning a Basic language into fully featured replacement for proper programming languages or that it was the next step from #C to try and compete in the embedded environment. But now I'm reading that it has something to do with VC++. Thus my question is this, as a VC++ developer of non-embedded solutions using v6.0, what am I going to gain from using .NET ? 2) MS took 6 years to get out Win2K from NT and even that was late a missing some functionality. Why such a quick move to a new OS? Is XP supposed to be a replacement for 2K or is it a replacement for 98/Me? & More importantly, as a user of Win2K, what would I gain from going to XP ? Thanks in advance, :confused: Damian Del Campo BEng(CompSys Hons) Software Engineer

Hi, I am temporarily working on a PC that doesn't have VC++, so I've downloaded a C++ compiler for Win32. The only thing I can't find is a win32 version of Make. Can anybody help me by sending or pointing me to a URL etc ? Damian Del Campo BEng(CompSys Hons) Software Engineer