Coonecting to SQL using C++

Question

Hi can some one please explain to me how to use C++ .net to connect to an SQL server PLEASE PLEASE!! because in msdn i have seen code like this 

SqlConnection* myConnection = new SqlConnection();

myConnection->ConnectionString = S"Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30";
myConnection->Open();
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.71).aspx
but it gives me a compile error which states that System::Data::SQLClient does not exist.

I am using Visual Studio 2010

Thanks a lot for your time.

---

Noel Farrugia

Answer 1

Is your application managed or unmanaged?

For unmanaged applications, I suggest using ADO. You can read more about it here.

Answer 2

I would like to create a project with managed C++ i.e using .NET Framework 4, could you suggest on how to create a visual studio 2010 project. Thanks a lot for your time.

---

Noel Farrugia

Answer 3

why ADO and not ODBC ?

---

yo

Answer 4

for me it does not make a difference which one to use, but i saw on msdn that with managed C++ using .net was much simpler but it gave me a compile error when implementing the reference to SQLClient. I would like someone to tell me if possible how to create a C++ project using .net framework 4 using visual studio 2010

---

Noel Farrugia

Answer 5

[...]

but it gives me a compile error which states that System::Data::SQLClient does not exist.

[...]

Try the correct name of namespace: SqlClient.

Answer 6

I tried that to, my problem is i think i am not creating a C++ .net framework project how can i check pls?

---

Noel Farrugia

Answer 7

Is it possible for you to paste your code here?

Apart from this,please check the reference for System.Data.SqlClient. Have you used it in your code?

 

 

---

Cheers!!!

Vatsa

www.objectiveprogramming.com

 

Answer 8

Just to get you started. This code compiles, but you have to manage connection string and SqlConnection itself to actually connect to database:

 

 

#using <System.dll>

#using <System.Data.dll>


using namespace System;

using namespace System::Data;

using namespace System::Data::Sql;

using namespace System::Data::SqlClient;

int main(array<System::String ^> ^args)

{

    SqlConnection^ myConnection = gcnew SqlConnection();

    myConnection->ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";

    myConnection->Open();

    return 0;

}

Answer 9

i'll try this out and let you know. Thanks alot :D :D

---

Noel Farrugia

Answer 10

i'll try this out and let you know. Thanks alot :D :D

---

Noel Farrugia

I just want to add that managed C++ is another language - not C++. It is even closer to C#, in my opinion. They share the same classes (namespaces) and only syntax somehow reminds C++. So, do not expect a lot of help from this C++ General Forum.

Answer 11

So when creating a C++ project in Visual Studio how can you set it to managed C++ or it detects it automatically. Thanks alot for your time :)

---

Noel Farrugia

Answer 12

So when creating a C++ project in Visual Studio how can you set it to managed C++ or it detects it automatically. Thanks alot for your time :)

---

Noel Farrugia

In Wizard you select New->Project->CLR. It creates new C++/CLI project.

You also can mix C++ and managed C++ selecting Project->properties->Configuration properties->General->Common Language Rutime Support.

All these projects require .NET framework when native C++ does not.

Answer 13

cool, thanks alot =]

---

Noel Farrugia

Answer 14

why ADO and not ODBC ?

---

 ADO is a wrapper above both ODBC and OLEDB, and can be used for either protocol. 

Answer 15

cool, thanks alot =]

---

In my opinion, if you are thinking of using SQL Server, your application is more likely to fall into the category where C# should be considered for client code development. Database applications can be developed under C# much faster, and the tools are simply much better.

Is there a reason you are choosing C++ over C#?

Answer 16

Because C++ is more powerful as a programming language than C#, i have worked with C# aswell but i would like the freedom of pointers etc. :)

---

Noel Farrugia

Answer 17

Because C++ is more powerful as a programming language than C#...

For database applications, I strongly disagree with you.

The Entity Framework technology is extremely powerful and valuable for database design, and LINQ is extraordinarily useful. Neither of these technologies is available to C++, but is available to C#. You are missing out on them by choosing C++.

Answer 18

I'll do it with C# then because C++ makes it a lot more complex . Thanks for your time

---

Noel Farrugia