alexander yushchenko

Hello!

(CS2002 + SP3 + FP1)

I tried to use code examples in VB Script and it worked.


I use the following code: (server and database names and password
has been changed):


using System;
using System.Data.OleDb;
namespace UpdateDWScheme
{
class Class1
{
[STAThread]
static void Main()
{
OleDbConnection c = new OleDbConnection
("Provider=commerce.dso.1;Data Source=mscop://InProcConnect/Server=serv:
Catalog=DWSchemaatabase=site_dw:user=saassword =pass:FastLoad=True");
c.Open();

//Everything else goes here
}
}
}


After calling "c.Open();" the connection is opened and closed
immediately after it, with no exceptions.

What's the matter? Why doesn't it work?

--
Yours faithfully,
Alexander Yushchenko

max akbar

Don't use OLEDB use ADO.

Here is a quick sample:

ADODB.Connection oCon= new ConnectionClass();
ADODB.Record rec = new RecordClass();

oCon.Open("URL=mscop://InProcConnect/server="+server+":database="+database+":Catalog=DW Schema:
user="+user+"assword="+password+":FastLoad=True" , string.Empty,
string.Empty, 0);

rec.Open("ClassNames", oCon, ConnectModeEnum.adModeReadWrite,
RecordCreateOptionsEnum.adCreateOverwrite,
RecordOpenOptionsEnum.adOpenRecordUnspecified, string.Empty, string.Empty);

foreach(string name in (System.Array)rec.Fields["ClassNames"].Value)
{
System.Diagnostics.Debug.WriteLine(name);
}

Good luck,
-Max