项目需要用到Datawindow.net 2.0的控件Datawindow.net 2.0就是PB中的Datawindow在.net中的控件程序如下Transaction trans = new Transaction();trans.Dbms = Sybase.DataWindow.DbmsType.OleDb;
trans.Password = "dw";
trans.UserId = "dw_his";
trans.DbParameter = "PROVIDER=\'OraOLEDB.Oracle\',DATASOURCE=\'192.168.0.2\',PROVIDERSTRING=\'database=dw_his\'";trans.Connect();运行之后在trans.Connect 行,提示Connection fails.用户名和密码都正确,可能是哪地方的错误呢?连接字符串?先谢谢进来看帖子的朋友~
trans.Password = "dw";
trans.UserId = "dw_his";
trans.DbParameter = "PROVIDER=\'OraOLEDB.Oracle\',DATASOURCE=\'192.168.0.2\',PROVIDERSTRING=\'database=dw_his\'";trans.Connect();运行之后在trans.Connect 行,提示Connection fails.用户名和密码都正确,可能是哪地方的错误呢?连接字符串?先谢谢进来看帖子的朋友~
trans.DbParameter="OraOLEDB.Oracle;User ID='192.168.0.2';Password='';Data Source=dw_his;"
字符串的原因?正确的如何写呢?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)trans.DbParameter = "PROVIDER=\'OraOLEDB.Oracle\',DATASOURCE=\'118\',PROVIDERSTRING=\'database=dw_his\'";