l******9
发帖数: 579 | 1 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of access IBM Netteza database from C# in Visual Studio
发信站: BBS 未名空间站 (Thu Jul 17 10:02:59 2014, 美东)
I need to access IBM Netteza database from C# in Visual Studio 2013 on win 7
.
connectionString="Driver={NetezzaSQL}; Server=xx.x.xxx.xxx;Database = my_db;
Uid=my_user_id;Pwd= my_password; ReadOnly=true;
I got exception:
An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in
System.Data.dll
Addit... 阅读全帖 |
|
l******9
发帖数: 579 | 2 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of access IBM Netteza database from C# in Visual Studio
发信站: BBS 未名空间站 (Thu Jul 17 10:02:59 2014, 美东)
I need to access IBM Netteza database from C# in Visual Studio 2013 on win 7
.
connectionString="Driver={NetezzaSQL}; Server=xx.x.xxx.xxx;Database = my_db;
Uid=my_user_id;Pwd= my_password; ReadOnly=true;
I got exception:
An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in
System.Data.dll
Addit... 阅读全帖 |
|
l******9
发帖数: 579 | 3 I need to access IBM Netteza database from C# in Visual Studio 2013 on win 7
.
connectionString="Driver={NetezzaSQL}; Server=xx.x.xxx.xxx;Database = my_db;
Uid=my_user_id;Pwd= my_password; ReadOnly=true;
I got exception:
An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in
System.Data.dll
Additional information: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified
I have installed 32/64 bits data base driver.
Thanks |
|
|
d****y
发帖数: 701 | 5 你如果用在大的系统上，建议STAY WITH ＴＤ。
换了系统之后你就会体会到贵有贵的道理。ＴＤ在ＦＯＲＴＵＮＥ ＴＯＰ ５００里
可是超过５０％的ＳＨＡＲＥ。
当然如果系统不大，不复杂，用什么都可以。小的ＤＡＴＡ ＭＡＲＴ可以试试
Netteza。
其实５Ｍ可以升级ＴＤ了。 |
|
z**h
发帖数: 85 | 6 no clue about C#, below are Java code, hope it helpful.
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
try {
String server = "YourServerHostname";
String port = "5480";
String dbName = "YourDatabaseName";
String url = "jdbc:netezza://" + server + ":" + port + "/" +
dbName ;
Class.forName("org.netezza.Driver");
Properties myProp = new Properties();
myProp.put("user", ... 阅读全帖 |
|
|
