MSSQL and C++

[sllabres]

Hi,
I noticed a previous thread on this topic but the solution provided, which was a link to a previous thread, was broken.
I am tryin got connect to a mssql database using C++, iv had a good trawl using google with no joy. Dont suppose anyone has some suggestions.

Thanks,

Sebastian

[sllabres]

Well iv come accross SQLAPI++ which looks like itll solve all my problems. Iv downloaded it and my app compiles ok except it seems to stop working. I cant seem to connect to the MSSQL database. My code is as follows:

SAConnection con;
SACommand cmd(
&con,
"Select * from nhssms");

con.setOption( "UseAPI" ) = "DB-Library";

try
{
con.Connect(
"SMSTEST@nhssms", // database name
"sa", // user name
"", // password
SA_SQLServer_Client);

con.Disconnect();
}
catch(SAException &x)
{
ShowErr((const char*)x.ErrText());
}

I must be doing something wrong, any suggestions?

Thanks,

Seb

[sllabres]

oh dear, sqlapi++ isnt free...heh can anyone suggest some free api's? or a way of accessing mssql.

cheers,

Seb