Northwind connection issue

[JohnnyBoy]

I am learning to program C++ .net and am having difficulty with one of the
exercises and wondered if someone could help?
I am including the code for a console app I wrote according to the exercise
that is supposed to create a connection to the
Northwind.mdb database. I modified the code for the ConnectionStrin g to
include the path to where I found Northwind.mdb
to be located on my machine. When I run the program, I get the following
error:

An unhandled exception of type 'System.Invalid OperationExcept ion' occurred
in system.data.dll Additional information:
The 'Microsoft.Jet. OLEDB.4.0: Data Source=C:\Progr am Files\Microsoft
Office\Office\S amples\northwin d.mdb' provider is not
registered on the local machine.

Can anyone help me?

// This is the main project file for VC++ application project // generated
using an Application Wizard. #include "stdafx.h" #using using namespace
System; //Generic ADO.NET definitions using namespace System::Data;
//specific Oledb provider definitions using namespace System::Data::O leDb;
int _tmain() { //create a connection OleDbConnection * cnNwind = new
OleDbConnection (); //Set the connection string cnNwind->ConnectionStri ng = S"
Provider=Micros oft.Jet.OLEDB.4 .0: " S"Data Source=C:\\Prog ram
Files\\Microsof t Office\\Office\ \Samples\\north wind.mdb"; try { //Open the
database cnNwind->Open(); Console::WriteL ine(S"Connected to database
successfully!") ; } catch(OleDbExce ption* pe) { Console::Write( S"Error
occurred: "); Console::WriteL ine(pe->Message); } //Close the connection if
(cnNwind->State != ConnectionState ::Closed) { cnNwind->Close(); }
Console::WriteL ine(S"The database connection is now closed"); return 0; }

[Milosz Skalecki]

Hi,

You have a bug in your connection string:
S"Provider=Micr osoft.Jet.OLEDB .4.0:" ...blabla
There should be semicolon instead of colon
S"Provider=Micr osoft.Jet.OLEDB .4.0;" ...blabla

Hope this helps
--
Milosz Skalecki
MCP, MCAD
"JohnnyBoy" wrote:

I am learning to program C++ .net and am having difficulty with one of the
exercises and wondered if someone could help?
I am including the code for a console app I wrote according to the exercise
that is supposed to create a connection to the
Northwind.mdb database. I modified the code for the ConnectionStrin g to
include the path to where I found Northwind.mdb
to be located on my machine. When I run the program, I get the following
error:

An unhandled exception of type 'System.Invalid OperationExcept ion' occurred
in system.data.dll Additional information:
The 'Microsoft.Jet. OLEDB.4.0: Data Source=C:\Progr am Files\Microsoft
Office\Office\S amples\northwin d.mdb' provider is not
registered on the local machine.

Can anyone help me?

// This is the main project file for VC++ application project // generated
using an Application Wizard. #include "stdafx.h" #using using namespace
System; //Generic ADO.NET definitions using namespace System::Data;
//specific Oledb provider definitions using namespace System::Data::O leDb;
int _tmain() { //create a connection OleDbConnection * cnNwind = new
OleDbConnection (); //Set the connection string cnNwind->ConnectionStri ng = S"
Provider=Micros oft.Jet.OLEDB.4 .0: " S"Data Source=C:\\Prog ram
Files\\Microsof t Office\\Office\ \Samples\\north wind.mdb"; try { //Open the
database cnNwind->Open(); Console::WriteL ine(S"Connected to database
successfully!") ; } catch(OleDbExce ption* pe) { Console::Write( S"Error
occurred: "); Console::WriteL ine(pe->Message); } //Close the connection if
(cnNwind->State != ConnectionState ::Closed) { cnNwind->Close(); }
Console::WriteL ine(S"The database connection is now closed"); return 0; }

[JohnnyBoy]

That did it!!!!
Thanks so much for replying!

"Milosz Skalecki" wrote:

Hi,

You have a bug in your connection string:
S"Provider=Micr osoft.Jet.OLEDB .4.0:" ...blabla
There should be semicolon instead of colon
S"Provider=Micr osoft.Jet.OLEDB .4.0;" ...blabla

Hope this helps
--
Milosz Skalecki
MCP, MCAD
"JohnnyBoy" wrote:

I am learning to program C++ .net and am having difficulty with one of the
exercises and wondered if someone could help?
I am including the code for a console app I wrote according to the exercise
that is supposed to create a connection to the
Northwind.mdb database. I modified the code for the ConnectionStrin g to
include the path to where I found Northwind.mdb
to be located on my machine. When I run the program, I get the following
error:

An unhandled exception of type 'System.Invalid OperationExcept ion' occurred
in system.data.dll Additional information:
The 'Microsoft.Jet. OLEDB.4.0: Data Source=C:\Progr am Files\Microsoft
Office\Office\S amples\northwin d.mdb' provider is not
registered on the local machine.

Can anyone help me?

// This is the main project file for VC++ application project // generated
using an Application Wizard. #include "stdafx.h" #using using namespace
System; //Generic ADO.NET definitions using namespace System::Data;
//specific Oledb provider definitions using namespace System::Data::O leDb;
int _tmain() { //create a connection OleDbConnection * cnNwind = new
OleDbConnection (); //Set the connection string cnNwind->ConnectionStri ng = S"
Provider=Micros oft.Jet.OLEDB.4 .0: " S"Data Source=C:\\Prog ram
Files\\Microsof t Office\\Office\ \Samples\\north wind.mdb"; try { //Open the
database cnNwind->Open(); Console::WriteL ine(S"Connected to database
successfully!") ; } catch(OleDbExce ption* pe) { Console::Write( S"Error
occurred: "); Console::WriteL ine(pe->Message); } //Close the connection if
(cnNwind->State != ConnectionState ::Closed) { cnNwind->Close(); }
Console::WriteL ine(S"The database connection is now closed"); return 0; }