Stack Overflow
Stack Overflow

Questions tagged [db2-connect]

db2-connect is an independent product used as a database client driver to connect IBM host database servers like zOS and i-Series servers.

db2-connect is an independent product used as a database client driver to connect IBM database servers like zOS, i-Series and Informix. db2-connect package comes with these client drivers: ODBC driver, CLI Driver, JCC Driver, .NET Driver, Python, PHP, Perl and Ruby Driver. It comes with CLPPlus command line tool too.

66 questions
0
votes
1 answer

visual studio 2010 connectivity to db2 on windows server 2008 R2

I have installed the db2 drivers from the ibm enterprise connect package. I am able to connect to the db2 datasource (system dsn) when I open visual studio in an admin mode and open the integration package. But I get an sqlstate 58031 when I open…
user1813399
  • 23
  • 5
0
votes
1 answer

DB2 sort the result by coumn which is not mention in query

Result of following query is weird to me, (I' m new to DB2). It sorted the result by column in the table which I didn't mention in the query. WITH RESULT AS ( SELECT T1.*, ROWNUMBER() OVER() AS RNUM FROM TableNAmeT1 WHERE column1=…
user978103
  • 21
  • 5
0
votes
1 answer

DB2 ConnectionString error

A button on the aspx page checks whether the connection with the DB2 database server is established or not. My connection String is : Server=xx.xx.xx.xx:446; Database=dd_unit; UID=db2admin; PWD=Secure*888; CurrentSchema=ptdd; It is throwing me a…
Vinayak Pahalwan
  • 2,915
  • 4
  • 26
  • 34
0
votes
0 answers

Public avaiable DB2 Databases

Are there any public available Versions of the following Database: Database: DB2 for i5/OS Version: 07.01.0000 OS/400 V7R1M0 I´m looking either for an way to setup that specific database, or a public available one (just to connect) Thank you.
kamahl
  • 931
  • 1
  • 8
  • 20
-1
votes
1 answer

DB2Command with no results ends with no error code .Net

When calling a stored procedure using either ExecuteResultSet or ExecuteReader using (DB2Connection conn = new DB2Connection(connstr)) { conn.Open(); DB2Command cmd = conn.CreateCommand(); cmd.Transaction = conn.BeginTransaction(); …
mackjazzy
  • 48
  • 1
  • 8
-1
votes
1 answer

db2 connection error [IBM][CLI Driver] SQL1042C

[2013-05-22 12:29:03,659]**[WARN]**[main]**[SettingsFactory:103]:Could not obtain connection metadata org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1042C An…
user2407976
  • 1
  • 1
1 2 3 4
5