我后面用了HOST ITERGRATION SERVER 2000 .可是也配不通不知道是不是参数设置问题, 装了这个软件系统也不正常了。我后面用ODBC.NET在VC#中也可以用很正常。 就在ASP.NET不行。不晓得怎么搞。
you try:use ADO.NET to connect to DB2.Provider=DB2OLEDB;Cache Authentication=False;Password=myPassword;Persist Security Info=True;User ID=myUser;Initial Catalog=BIGBLUE;Network Transport Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network Address=111.22.136.23;Network Port=446;Package Collection=QGPL;Default Schema=QGPL参考:http://groups.google.com/groups?q=ado.net+db2&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=ehiLWd%23ECHA.1956%40cpmsftngxa07&rnum=4
IBM DB2 OLEDB, OleDbConnection (.NET) from ms TCP/IP: "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW" APPC: "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
IBM DB2 OLEDB, OleDbConnection (.NET) from ms TCP/IP: "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW" APPC: "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW" OLE DB .NET Data Provider (System.Data.OleDb) The OLE DB .NET Data Provider uses native OLE DB through COM interop to enable data access. To use the OLE DB .NET Data Provider, you must also use an OLE DB provider (e.g. SQLOLEDB, MSDAORA, or Microsoft.JET.OLEDB.4.0).For IBM AS/400 OLE DB Provider' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=IBMDA400.DataSource.1;" & _ "Data source=myAS400DbName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open()
SERVER=localhost;DBALIAS=tmlaw;UID=db2admin;PWD=db2admin在asp.net中就不行了???
装了这个软件系统也不正常了。我后面用ODBC.NET在VC#中也可以用很正常。
就在ASP.NET不行。不晓得怎么搞。
Security Info=True;User ID=myUser;Initial Catalog=BIGBLUE;Network Transport
Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network
Address=111.22.136.23;Network Port=446;Package Collection=QGPL;Default
Schema=QGPL参考:http://groups.google.com/groups?q=ado.net+db2&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=ehiLWd%23ECHA.1956%40cpmsftngxa07&rnum=4
OLEDB, OleDbConnection (.NET) from ms
TCP/IP:
"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
APPC:
"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
OLEDB, OleDbConnection (.NET) from ms
TCP/IP:
"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
APPC:
"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
OLE DB .NET Data Provider (System.Data.OleDb)
The OLE DB .NET Data Provider uses native OLE DB through COM interop to enable data access. To use the OLE DB .NET Data Provider, you must also use an OLE DB provider (e.g. SQLOLEDB, MSDAORA, or Microsoft.JET.OLEDB.4.0).For IBM AS/400 OLE DB Provider' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=IBMDA400.DataSource.1;" & _
"Data source=myAS400DbName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()