Thank you everybody for your help and direction.

I am learning C++ and would like to find out from the veterans out there what is the most efficient way of learning this language. Through research I have found the book "C++ How to Program" by P.J. Deitel and am working through the book. I also have on order "C Primer Plus" by Stephen Prata. Though my "How to Program" has limited questions and exercises. Secondly you have to have an instructor's edition to verify the answers to exercises and this resource is not accessible to the general public. Does anyone out there know of any good workbooks with questions and exercises and answers to these items? Secondly, what is the most recommended learning path.

I obtained the answer for this on another board. Basically, the problem is that I did not sign-on as administrator on my Visual Studio program.

Can someone help me with this error? I am compiling an IDL file and am getting an MIDL2020 error. This error is defined as "General access denied error". I am working on a Windows Vista machine and have searched for a solution but cannot find anything that solves this. Any suggestions would be greatly appreciated. Below is the complete compilation error: midl\oleaut32.dll : error MIDL2020 : error generating type library : SaveAllChanges Failed : .\spellcheck.tlb (0x80070005) Here is the program: //Creating the interface import "unknwn.idl"; [object,uuid(C73BA5B4-B466-4348-8CC2-E6B48998B3F7)] //Defining the interface interface ISpellChecker : IUnknown { HRESULT CheckSpelling([in,string] char *word,[out,retval] BOOL *isCorrect); HRESULT UseCustomDictionary([in,string] char *filename); } //Define type library [uuid(C81C9C52-008B-429d-8533-262E90A1D0D5)] library SpellcheckerLib { [uuid(57B7A8A0-E4D7-11d0-818D-444553540000)] coclass CSpellChecker { interface ISpellChecker; } };

modified on Sunday, May 30, 2010 10:46 AM

The following is the error message I am receiving: Error number: 80040e4d Login failed for user 'mcertini'. Error Code = 80040e4d Code meaning = I Source = Microsoft OLE DB Provider for SQL Server

I am currently having problems with my ADO connection string. I have searched all over the internet for a solution to this problem but I have yet to find a solution. Can someone help me with the proper configuration for a SQL OLEDB connection with a windows authentication? Included is my C++ code file. I cannot include my SQL Server signon but can send a printscreen via e-mail attachment. // ConnectionString.cpp : Defines the entry point for the console application. // #include "stdafx.h" // ConnectionStringSampleCpp.cpp // compile with: /EHsc //#import "msado15.dll" no_namespace rename("EOF", "EndOfFile") #import "c:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "EOFile") // Function declarations inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);}; void ConnectionStringX(); _bstr_t GetState(int intState); void PrintProviderError(_ConnectionPtr pConnection); void PrintComError(_com_error &e); int main() { if (FAILED(::CoInitialize(NULL))) return 0; ConnectionStringX(); ::CoUninitialize(); } void ConnectionStringX() { // Define Connection object pointers. Initialize pointers on define. These are in the ADODB:: namespace _ConnectionPtr pConnection1 = NULL; _ConnectionPtr pConnection2 = NULL; _ConnectionPtr pConnection3 = NULL; _ConnectionPtr pConnection4 = NULL; // Define Other Variables HRESULT hr = S_OK; try { // Open a connection using OLE DB syntax. TESTHR(pConnection1.CreateInstance(__uuidof(Connection))); //pConnection1->ConnectionString = "Provider='sqloledb';Data Source='(local)';" // "Initial Catalog='DSNPubs';Integrated Security='SSPI';"; //pConnection1->ConnectionString = "Provider='sqloledb';Server='PCD-LT-MCERTINI\\SQLEXPRESS';" // "AttachDbFilename='C:\\SQL Server 2000 Sample Databases\\NORTHWND.mdf';Initial Catalog='northwind';Trusted_Connection=Yes;"; pConnection1->ConnectionString = "Provider='SQLOLEDB.1';Persist Security Info='True';User ID='mcertini';Initial Catalog='northwind';Data Source='PCD-LT-MCERTINI\\SQLEXPRESS';"; //pConnection1->ConnectionString = "Provider='SQLNCLI10';Data Source='NORTHWND.mdf';"; pConnection1->ConnectionTimeout = 30; pConnection1->Open("", "", "",adConnectUnspecified); printf("cnn1 state: %s\n", (LPCTSTR)GetState(pConnection1->State)); // Open a connection using a DSN and ODBC tags. // It is assumed that you have create DSN 'D

Can someone help me with the below ADO API? I am a new programmer and am having problems programming a SQL Server connection. I have found various connection strings and continue to run into problems with the syntax. Thank you in advance. #include "stdafx.h" #include #include #import "C:\Program files\Common Files\System\Ado\msado15.dll" rename("EOF", "ADOEOF") //--------------------------------------------------------------------------------------------------------------------------------------------- std::string outputashex(unsigned long l) { char buffer[1024]; ::itoa(l, buffer, 16); return buffer; } ; //--------------------------------------------------------------------------------------------------------------------------------------------- void main() { HRESULT hr; CoInitialize(NULL); try { ADODB::_ConnectionPtr connection; hr = connection.CreateInstance(__uuidof(ADODB::Connection)); if (FAILED(hr)) { throw _com_error(hr); } //-------------------------------------------------------------------------------------------------------------------------------------------- ADODB::_RecordsetPtr recordset; hr = recordset.CreateInstance(__uuidof(ADODB::Recordset)); if (FAILED(hr)) { throw _com_error(hr); } //-------------------------------------------------------------------------------------------------------------------------------------------- connection->CursorLocation = ADODB::adUseClient; //-------------------------------------------------------------------------------------------------------------------------------------------- connection->Open("Provider=sqloledb;Server=.\SQLExpress;AttachDbFilename=c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\WattsALoan.mdf;Database=WattsALoan;Trusted_Connection=Yes;") //------------------------------------------------------------------------------------------------------------------------------------------- //recordset->Open("CREATE TABLE mytable (value NVARCHAR(255))", //connection.GetInterfacePtr(), ADODB::adOpenForwardOnly, //ADODB::adLockReadOnly, ADODB::adCmdText); //-------------------------------------------------------------------------------------------------------------------------------------------- //recordset->Open("INSERT INTO mytable VALUES ('Hello')", //connection.GetInterfacePtr(), ADODB::adOpenForwardOnly, //ADODB::adLockReadOnly, ADODB::adCmdText); //-------------------------------------------------------------------------------------------------------------