Connect to SQL Server 2005 Using Visual Studio C++ 2005 ?

Hi All,
I hope I am in the correct group to ask such a question, anyway:
I am new to Visual Studio C++ (2005) and SQL Server 2005 as I have
recently moved across from using Borland C++, so VS has been pretty much
a steep learning curve for me.
I have created a database through SQL Server called dbTest.mdf, I did
this from SQLCMD (CREATE DATABASE dbTest).
I now want to connect to the database using Visual Studio C++ 2005 by
writing a simple app.
Obviously the code included below won't work - well I can't get it to
work, so please have a look at it and tell me where I'm going wrong....
Best Regards
Pete
#include "stdafx.h"
using namespace System;
using namespace System::Data;
using namespace System::Data::Sql;
using namespace System::Data::SqlClient;
int main(array<System::String ^> ^args)
{
SqlConnection conn;
conn = new SqlConnection("Data Source=PETER-VTR1000\SQLEXPRESS;Initial
Catalog=dbTest;Integrated Security=True");
return 0;
}
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
-->>>>>>http://www.NewsDemon.com<<<<<<--
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access"Pete Moscatt" <peter.moscatt@.gmail.com> wrote in message
news:448a5f1b$0$29247$b9f67a60@.news.newsdemon.com...
> Hi All,
> I hope I am in the correct group to ask such a question, anyway:
> I am new to Visual Studio C++ (2005) and SQL Server 2005 as I have
> recently moved across from using Borland C++, so VS has been pretty much a
> steep learning curve for me.
> I have created a database through SQL Server called dbTest.mdf, I did this
> from SQLCMD (CREATE DATABASE dbTest).
> I now want to connect to the database using Visual Studio C++ 2005 by
> writing a simple app.
> Obviously the code included below won't work - well I can't get it to
> work, so please have a look at it and tell me where I'm going wrong....
>
Sure. This is C++/CLI.
Your other option to access SqlServer form C++ is OleDB. But I like this
much better since you get access to the whole .NET framework, and you can
use garbage-collected types.
Also there are tons of examples of how to use SqlServer through .NET in C#.
Once you master the syntax differences between C# and C++/CLI you can
easilly use them.
Anyway here's your code rewritten a bit.
David
#include "stdafx.h"
using namespace System;
using namespace System::Data;
using namespace System::Data::Sql;
using namespace System::Data::SqlClient;
void Run()
{
/*
SqlConnection implements IDisposable and must be cleaned up after it's
used.
But declaring as a local variable intead of a reference using gcnew
the compiler
will insert the cleanup code at the end of this scope.
*/
SqlConnection conn("Data Source=(local);Initial Catalog=test;Integrated
Security=True");
conn.Open();
/*
SqlCommand doesn't really need cleanup, so we can create that using
gcnew and access
it through a handle.
*/
SqlCommand^ cmd = gcnew SqlCommand("select top 10 Name from
sys.objects",%conn);
/*
SqlDataReader also needs cleanup, but it is returned from the
SqlCommand as a handle
so we can't use automatic storage for it. So a try/finally block
guarantees cleanup.
*/
SqlDataReader^ rdr = cmd->ExecuteReader();
try
{
while (rdr->Read())
{
System::Console::WriteLine(rdr[0]);
}
}
finally
{
rdr->Close();
}
}
int main(array<System::String ^> ^args)
{
try
{
Run();
return 0;
}
catch (Exception^ ex)
{
Console::WriteLine(ex);
return 1;
}
}|||Xref: TK2MSFTNGP01.phx.gbl microsoft.public.sqlserver.programming:608275
David Browne wrote:
> "Pete Moscatt" <peter.moscatt@.gmail.com> wrote in message
> news:448a5f1b$0$29247$b9f67a60@.news.newsdemon.com...
> Sure. This is C++/CLI.
> Your other option to access SqlServer form C++ is OleDB. But I like this
> much better since you get access to the whole .NET framework, and you can
> use garbage-collected types.
> Also there are tons of examples of how to use SqlServer through .NET in C#
.
> Once you master the syntax differences between C# and C++/CLI you can
> easilly use them.
> Anyway here's your code rewritten a bit.
> David
>
> #include "stdafx.h"
> using namespace System;
> using namespace System::Data;
> using namespace System::Data::Sql;
> using namespace System::Data::SqlClient;
> void Run()
> {
> /*
> SqlConnection implements IDisposable and must be cleaned up after it
's
> used.
> But declaring as a local variable intead of a reference using gcnew
> the compiler
> will insert the cleanup code at the end of this scope.
> */
> SqlConnection conn("Data Source=(local);Initial Catalog=test;Integrate
d
> Security=True");
> conn.Open();
> /*
> SqlCommand doesn't really need cleanup, so we can create that using
> gcnew and access
> it through a handle.
> */
> SqlCommand^ cmd = gcnew SqlCommand("select top 10 Name from
> sys.objects",%conn);
> /*
> SqlDataReader also needs cleanup, but it is returned from the
> SqlCommand as a handle
> so we can't use automatic storage for it. So a try/finally block
> guarantees cleanup.
> */
> SqlDataReader^ rdr = cmd->ExecuteReader();
> try
> {
> while (rdr->Read())
> {
> System::Console::WriteLine(rdr[0]);
> }
> }
> finally
> {
> rdr->Close();
> }
> }
> int main(array<System::String ^> ^args)
> {
> try
> {
> Run();
> return 0;
> }
> catch (Exception^ ex)
> {
> Console::WriteLine(ex);
> return 1;
> }
> }
>
>
G'Dave,
Thanks for the code - at least it now compiles.
When I run the EXE I am now faced with connection errors so now assume
that I need to pay more attention on how I installed SQL Server.
So, back to the books to clear that up - I can use SQLCMD so I guess I
can't be too far away on getting it right.
Currently I have the server connecting with TCP (port 1403) and I see I
could also used:
Named Pipes
TCP
VIA
What is considered the better way to connect ?
I had a look at the configuration of the Server and found to be 'local
service'
Would I be better of using:
local system
or
network service
or
local service (current)
Cheers
Pete
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
-->>>>>>http://www.NewsDemon.com<<<<<<--
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access|||"Pete Moscatt" <peter.moscatt@.gmail.com> wrote in message
news:448b95c4$0$30209$b9f67a60@.news.newsdemon.com...
> David Browne wrote:
> G'Dave,
> Thanks for the code - at least it now compiles.
> When I run the EXE I am now faced with connection errors so now assume
> that I need to pay more attention on how I installed SQL Server.
> So, back to the books to clear that up - I can use SQLCMD so I guess I
> can't be too far away on getting it right.
> Currently I have the server connecting with TCP (port 1403) and I see I
> could also used:
>
You probably need an instance name in the "Data Source".
SqlConnection conn("Data Source=(local)\SQLExpress;Initial
Catalog=test;Integrated Security=True");
conn.Open();
And "Initial Catalog" is the database name.
I would generally use TCP/IP (remote) and Shared Memory (local).

> Named Pipes
> TCP
> VIA
> What is considered the better way to connect ?
> I had a look at the configuration of the Server and found to be 'local
> service'
>
As for what account you use to run SQL Server, it really depends on your
security setup. Usually either Local Service or Network Service is
appropriate. But sometimes you will want to use a Domain account.
David|||On Sun, 11 Jun 2006 11:10:50 -0500, "David Browne" <davidbaxterbrowne
no potted meat@.hotmail.com> wrote:

>"Pete Moscatt" <peter.moscatt@.gmail.com> wrote in message
>news:448b95c4$0$30209$b9f67a60@.news.newsdemon.com...
>
>You probably need an instance name in the "Data Source".
> SqlConnection conn("Data Source=(local)\SQLExpress;Initial
>Catalog=test;Integrated Security=True");
> conn.Open();
>And "Initial Catalog" is the database name.
>I would generally use TCP/IP (remote) and Shared Memory (local).
>
>
>As for what account you use to run SQL Server, it really depends on your
>security setup. Usually either Local Service or Network Service is
>appropriate. But sometimes you will want to use a Domain account.
>
>David
>
Thanks Dave, it all a good thing at the moment.
You have me enough info for me to let loose and work things out
myself.
Again, thanks for all the assistance you have given me on this issue.
Pete
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
-->>>>>>http://www.NewsDemon.com<<<<<<--
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access