f



Using .NET to access to a IBM DB2 database

Hello

I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I
cannot choose the provider, this is the only one I can use.

The tables in AS/400 don't have journal and I cannot change this.

When I define an ODBC and link tables in ACCESS I can perform every
actions. I change the ODBC options to commit data immediately.

Using the same ODBC and the same insert statement, when I connect in
my C# application using ODBCConnection, I get this error:

ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2
UDB]SQL0206 - Column N not in specified tables.

What I want is to use a DNS Less situation, and I want to enter in the
connection string all the parameters to connect to the AS/400
database.
This is my connection string:Provider=IBMDA400;Data
Source=999.999.999.999;

When I put the AutoCommit option in the connection string I get this
error:
No error message available, result code:
DB_E_ERRORSOCCURRED(0x80040E21).

I get this message even when the autocommit is 1, 0, true or false and
this is the connection string: Provider=IBMDA400;Data
Source=192.168.192.12;autocommit=0


right now I can perform all the operation with Access database but I
can't with my .NET application in C#.

anyone can assist me?
tkx in advance
Paulo Aboim Pinto

0
Esqueleto
9/20/2007 10:54:40 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

2 Replies
1119 Views

Similar Articles

[PageSpeed] 14

Esqueleto wrote:
> ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2
> UDB]SQL0206 - Column N not in specified tables.
Are you submitting a query with a VARIABLE "N" in it?
This error doesn't appear to have anything to do with your connection.
You successfully made it to DB2 and it's SQL compiler.
But it appears that you have to read up on how to bind variables.
E.g. using "parameter markers".

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
0
Serge
9/20/2007 12:18:49 PM
You might find the examples in this Redbook useful:
http://www.redbooks.ibm.com/abstracts/sg246440.html

Esqueleto wrote:
> Hello
> 
> I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I
> cannot choose the provider, this is the only one I can use.
> 
> The tables in AS/400 don't have journal and I cannot change this.
> 
> When I define an ODBC and link tables in ACCESS I can perform every
> actions. I change the ODBC options to commit data immediately.
> 
> Using the same ODBC and the same insert statement, when I connect in
> my C# application using ODBCConnection, I get this error:
> 
> ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2
> UDB]SQL0206 - Column N not in specified tables.
> 
> What I want is to use a DNS Less situation, and I want to enter in the
> connection string all the parameters to connect to the AS/400
> database.
> This is my connection string:Provider=IBMDA400;Data
> Source=999.999.999.999;
> 
> When I put the AutoCommit option in the connection string I get this
> error:
> No error message available, result code:
> DB_E_ERRORSOCCURRED(0x80040E21).
> 
> I get this message even when the autocommit is 1, 0, true or false and
> this is the connection string: Provider=IBMDA400;Data
> Source=192.168.192.12;autocommit=0
> 
> 
> right now I can perform all the operation with Access database but I
> can't with my .NET application in C#.
> 
> anyone can assist me?
> tkx in advance
> Paulo Aboim Pinto
> 

-- 
Kent Milligan
ISV Enablement - System i
kmill@us.eye-bee-m.com (spam trick)   GO HAWKEYES!!
 >>> ibm.com/iseries/db2
(opinions stated are not necessarily those of my employer)
0
Kent
9/21/2007 5:04:21 PM
Reply:

Similar Artilces:

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44) The code that I am using (with try/catch removed) is as follows: String url = "jdbc:db2:sample"; String driver = "COM.ibm.db2.jdbc.DB2XADataSource"; String dbuser = "db2u...

Convert SAP Oracle Database to IBM DB2 Database??
Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving via DB2 compression? Did you run the latest version of DB2 rather than allow SAP to keep your Oracle version back-leveled? Please, DB2 Bashers need not apply, looking for the business case anyone used to convert to DB2. Thank you. Charles On 6 Feb, 01:52, "Charles Davis" <cdavis10...@comcast.net> wrote: > Hello, > > I would like to hear from anyone here who has converted their SAP Oracle > database to IBM DB2 d...

Connect to IBM DB2 database without installing the DB2 client.
Hi, To connect to the DB2 Driver, from a remote machine. Do we requier DB2 client. Can't we connect by just having IBM DB2 driver which is just a single file (db2cli.dll). I am using vb application from Windows platform to connect to DB2 on Linux machine. Regards, Santosh SB wrote: > Hi, > > To connect to the DB2 Driver, from a remote machine. Do we requier DB2 > client. > Can't we connect by just having IBM DB2 driver which is just a single > file (db2cli.dll). > I am using vb application from Windows platform to connect to DB2 on > Linux machine. > It's imposiblle. The IBM DB2 ODBC Driver is not only db2cli.dll. Try to install DB2 Run Time Client Lite merge modules with your VB application under client workstation. Direct connecting to DB2 databases supported JDBC Type 4 Driver only. P.S. Sorry for my bad english :( With best regards, Dmitry. FYI: On Windows DB2 comes with db2iprune tool. With this utility you can reduce size of installation binaries, for example you can reduce your DB2 runtime client to include only the interfaces you need. The db2iprune tool is located in the \db2\windows\utilities\db2iprune directory on DB2 product installation image. So, if you are planning install DB2 client with/within your application you can combine the tool with the response file and perform quick batch installation. -- Artur Wronski ...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm running IBM iSeries Acc...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm runn...

oct 24 DB2 for LUW Tech Talk: What's Hot from IOD for PureData Systems, IBM Mobile Database and DB2 for LUW
Now we can tell you more! IBM announced PureData Systems on October 9th --= a series of expert integrated solutions for your transactional and analyti= c workloads.=20 In the next DB2 Tech Talk, we'll come to you from Las Vegas with hot news f= rom the conference from a DB2 for LUW, PureData Systems perspective! We'll= also cover a new free software download called IBM Mobile Database, which = helps you enable your DB2 data apps for Android mobile users. And then we = will bring you the best of the presentations from the conference, including= an IBM Champion and other interesting perspectives on DB2. =20 Register: bit.ly/tt2012oct ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM Sets DB2 Database Free
http://www.linuxtoday.com/it_management/2006013101526NWSV Will UniVerse and UniData follow? Henrry Keultjes hbkeultjesat earthlinkdotnet csigline@hotmail.com wrote: > http://www.linuxtoday.com/it_management/2006013101526NWSV > > Will UniVerse and UniData follow? Good catch, Henry (or is it two r's now-see below). We will have to ask IBM what their intentions are with U2 in light of this, but I suspect that the PE editions will be the extent of the free offering. We shall see. Cheers! --dawn > Henrry Keultjes > hbkeultjesat > earthlinkdotnet Hard to compete when others such as MS SQL and Oracle are offering free versions too. mpizl@yahoo.com wrote: > Hard to compete when others such as MS SQL and Oracle are offering free > versions too. The only one my primary ISP will provide for me is MySQL. I suspect that is true of other ISPs as well. I feel the barometer falling in the database industry. cheers! --dawn do you think we can at least get some stuff for free like pdp.net? What is RD going to do to survive? Cant see too many new people wanting to learn or buy pick. dawn wrote: > mpizl@yahoo.com wrote: > >>Hard to compete when others such as MS SQL and Oracle are offering free >>versions too. > > > The only one my primary ISP will provide for me is MySQL. I suspect > that is true of other ISPs as well. I feel the barometer falling in > the datab...

hibernate and db2 using com.ibm.db2.jcc.DB2Driver
I am trying to use hibernate with db2. I have set the hibernate dialect to be DB2Dialect. I am using the com.ibm.db2.jcc.DB2Driver make a connection with the database. Database connection details are as follows: jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.url=jdbc:db2://<host>:50000/<database> I have the db2jcc.jar on my classpath. DB2 v8.2 is running on a Linux box. When i try and save to the database i am getting the following exception back from hibernate/driver org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not insert: [nz.co.vircom.model.WorkOrder]; bad SQL grammar [insert into EMSDATA.MM_MRP_CONNECTIONS (Account_Balance, Address, Charge, Charge_Code, City, Comments, Competed_Date, Contract_A_c, Customer, Date_Due, Date_Due_2, Date_Received, Device_Location, Device_No, Disconnect, Disco_Type_ID, EmailSent, Escalated, ETA_Request_Count, ETA_Time, ICP___1, Installation_number, Invoice_to, Issue_Time, Job_No, Job_SubType, Job_Type_ID, Key, Locality, Meter_Seal_Number, Non_Disco_Type_ID, Period_No, Postal_Cod, Premise, Reade rs__Mesaage, Reading, Reason, Retailer_ID, Service_Provider_ID, Source_Doc_ID, Status_ID, Suburb, Technician_ID, Telephone, Time_mode, Urgency, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, default)]; nested exception is com.ibm.db2.jcc.b.SQLException: ACCOUNT_BALANCE c...

IBM DB2 Database Specialist
We are looking to fill the following permanent position with one of our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED). Apply to: APPLICATION@GOAHEADCONSULTING.CO.UK Job Title IBM DB2 Database Specialist Location: Saudi Arabia Objective Responsible for the administration of DB2 subsystems and associated software on the client=92s mainframes Accountable to Data Centre Manager Responsibilities This SENIOR position involves the full spectrum of DB2 system programming activities, including product installation, customization, deployment, software tools integration, exploitation, and performance analysis activities. Implement, upgrade, Migrate and support DB2 and related vendor products. Monitor and tune DB2 daily performance, resolving problems as needed.DB2 Internal tuning (buffer pools, DASD (SMS), performance reports (PM, OMEGAMON, CA tools).Application tuning (database design review, SQL tuning, stored procedures, triggers V6, user defined functions V6, again reports). Implement TCP/IP access to DB2 using DRDA Compare DB2/connect with Star/SQL gateway and make recommendation. This position requires being on call 24 hours a day Provide documentation and skills transfer to existing staff. Working relationships Work closely with Applications Development and systems programmers in z/OS, DB2, Networking and Websphere groups and other members of the CICS and MQ Department Essential Skills Recent and extensive knowledge of latest DB2 Versi...

DBI:ibm_db connection for IBM DB2 database
Hello, I am attempting to make a DBI connection from Ruby code running on Win32 (XP) machine to an IBM DB2 v9.5 database running under Linux On the Win32 machine, I have Ruby 1.8.6 (installed with the one-click installer) and have successfully launched the following gem installation commands for the IBM DB drivers and required libraries: >gem install activesupport -v 1.4.2 >gem install activerecord -v 1.15.3 >gem install ibm_db -v 0.8.5 I have also (as required by the IBM documentation at http://rubyforge.org/docman/view.php/2361/967/IBM_DB-0.6.0.pdf) added ‘ibm_db’ to the list of connection adapters on line77 of gems\1.8\gems\activerecord-1.15.3\lib\active_record.rb : RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird sqlserver db2 oracle sybase openbase frontbase ibm_db ) Here is the ruby code : ------------- require 'rubygems' gem 'ibm_db' require 'dbi' # Connect to a database dbh = DBI.connect('DBI:ibm_db:host=localhost;port=50000;database=MY_DB;', 'username', 'password') # Select some data sth = dbh.prepare('select * from my_table') sth.execute # Print out selected data while row=sth.fetch do p row end --------------- Error reported is as follows : C:\dev\ruby\dbtest>dbtest.rb c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to load drive r 'ibm_db' (DBI::InterfaceError) from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in `_get_full_drive...

Re: IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit,
vvcd said: > IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 > bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite > Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express > Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM > Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other > IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 > CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM > Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere > Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 > CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia > ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia > ColdFusion MX for J2EE, other What the heck, I'm sure IBM won't have a problem with a little copyright violation... >:o) > please send e-mail, ola2@mail.gr, astra35@mailbox.gr, Do they have internet access in Greek jails, I wonder... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list ...

db2 client to connect to host databases and create/use local databases too
Is it possible to install DB2 client product(s) so that the same system can connect to host databases like DB2 Connect can, *and* can also create and use local databases like DB2 Personal can? I have "DB2 Personal Edition" installed now, which does everything I want except I get an SQL8002N about missing DB2 Connect product/license when I try to connect to an OS/400 database. I was thinking of trying "DB2 Connect Personal Edition", but I cannot find confirmation anywhere of whether that would let me also create and use local databases... On 17.04.13 12:31 , Cindy Ross wrote: > Is it possible to install DB2 client product(s) so that the same system > can connect to host databases like DB2 Connect can, *and* can also > create and use local databases like DB2 Personal can? > > I have "DB2 Personal Edition" installed now, which does everything I > want except I get an SQL8002N about missing DB2 Connect product/license > when I try to connect to an OS/400 database. I was thinking of trying > "DB2 Connect Personal Edition", but I cannot find confirmation anywhere > of whether that would let me also create and use local databases... Yes, "DB2 Connect Personal Edition" is the one you want. -- Helmut K. C. Tessarek DB2 Performance and Development IBM Toronto Lab >> Is it possible to install DB2 client product(s) so that the same system >> can connect to host dat...

how to use db2 connect server as a gateway to connect to mainframe db2 database
we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect server and client, so client could access the database through the connect server? like that: db2client <--> db2 connect server <--> db2 mainframe database IBM keeps talking about this structure but never mention about the configuration in all the manuals.:( thanks for help! jeffhan wrote: > we have os/400 db2 database at the backend. > i installed db2 v9 connect server on one windows server which is > locating the same network with database server. > > now how to i configure the connect server and client, so client could > access the database through the connect server? > > like that: > > db2client <--> db2 connect server <--> db2 mainframe database > > IBM keeps talking about this structure but never mention about the > configuration in all the manuals.:( > > thanks for help! Info-center: - "DB2 Connect server products: installation and configuration overview": http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.uprun.doc/doc/c0008452.htm - "Preparing DB2 Universal Database for iSeries for connections from DB2 Connect": http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.uprun.doc/doc/t0008234.htm - &qu...

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIX
Hi, I have installed WebSphere Portal on AIX and connected to DB2 on a remote machine, Getting the followin errors when trying to get the values from database thru applications installed on Portal. Any Help Appreciated. Thanks in advance. Praveen Singh IBM Workplace, India COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.33.12.221". Communication function detectin...

Whether ACE threads work with IBM Db2 Database
Hi All, We are starting one Project with following Skills 1) Language :- C++ with Embedded SQL Programming ( Source file format :- .sqC ) 2) Database :- IBM UDB database 3) Platform:- Solaris Sparc 5.8 Machine. 4) ACE Threads. Please let us know, can we use ACE Threads with C++ and Db2 Embedded SQL under Solaris Sparc 5.8 Machine. Thanks & Regards, Divya ...

Hibernate 3.1 and db2 connecting using com.ibm.db2.jcc.DB2Driver
I am trying to use hibernate with db2. I have set the hibernate dialect to be DB2Dialect. I am using the com.ibm.db2.jcc.DB2Driver make a connection with the database. Database connection details are as follows: jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.url=jdbc:db2://<host>:50000/<database> I have the db2jcc.jar on my classpath. DB2 v8.2 is running on a Linux box. When i try and save to the database i am getting the following exception back from hibernate/driver org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not insert: [nz.co.vircom.mode...

Web resources about - Using .NET to access to a IBM DB2 database - comp.databases.ibm-db2

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Enterprises want to run databases in containers
More than three out of four IT decision makers are interested in running stateful applications like databases within containers, according to ...

NFL mock draft database 2016: Tracking Giants picks from around the Internet
Let's keep track of mock drafts from around the Internet as the 2016 NFL Draft approaches. Can we find a consensus for the New York Giants?

NTTC's Liquid Products Database making steady progress
NTTC's Liquid Products Database making steady progress Modern Bulk Transporter NTTC is asking carriers to suggest “proprietary blends” for ...

Herbalife sinks on database error report
Herbalife said it had overstated growth in the number of "active new members" in some instances in the past three quarters due to database errors. ...

Consumer Group Sues DOT For Failure To Create Searchable Database Of Safety Defects
... about safety defects. One safety group says this hasn’t happened, and is suing DOT Secretary Anthony Foxx in an effort to make this database ...

TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers
TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers

Architizer raises $7 million to launch a new products database
US media company Architizer has received $7 million in venture capital to help launch an online products database for architects and designers ...

Resources last updated: 3/7/2016 2:21:22 AM