Hello!
(CS2002 + SP3 + FP1)
I tried to use code examples in VB Script and it worked.
I rewrote it using ADODB interop assembly and it worked.
Now I try to do the same using .Net data adaptor in c#.
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=DWSchema:Database=site_dw:user=sa:password=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