Database

declare @list char(100)
set @list = '''wc1'',''wc2'''
select * from iv30300 where trxloctn in (@list)

declare @list char(100)
set @list = '''wc1'',''wc2'''
select * from iv30300 where trxloctn in ('wc1','wc2')

CDaoDatabase * pDb = new CDaoDatabase();
pDb->Open(db);

//AfxMessageBox(pDb->GetVersion());

CDaoRecordset * pRs = new CDaoRecordset(pDb);
CDaoTableDef * pTd = new CDaoTableDef(pDb);

pTd->Open("MSysObjects");
pRs->Open(pTd, dbOpenSnapshot); // Read access error

/*sTemp.Format("%u", pTd->GetFieldCount());
AfxMessageBox(sTemp);*/

pDb->Close();
pRs->Close();
pTd->Close();
delete pDb;
delete pRs;
delete pTd;

#include "stdafx.h"

using namespace System;
using namespace System::Data;
using namespace System::Data::SqlClient;

void main()
{
    SqlConnection^ connection = gcnew SqlConnection();

#ifdef SQLAuth
    //  SQL Server authentication
    connection->ConnectionString = 
        "User ID=sa; Password=;"
        "Data Source=(local); Initial Catalog=DCV_DB;";
#else
    //  Windows Integrated Security
    connection->ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DCV_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
#endif

	try
    {
        connection->Open();
        Console::WriteLine("We got a connection!");
    }
    catch (SqlException ^e)
    {
        Console::WriteLine("No connection the following error occurred: {0}",
            e->Message);
    }
    finally
    {
        connection->Close();
        Console::WriteLine("The connection to the database has been closed");
    }
}

<br />
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error 40: - Could not open a connection to SQL Server)