All Questions
277 questions
0
votes
0
answers
6
views
Connection error between MicroStrategy and IBM DB2 Cloud
I am facing a connection error when trying to connect to IBM DB2 Cloud via MicroStrategy.
(Database error <5>: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. ...
1
vote
1
answer
69
views
DB2 ODBC driver not recognized?
I installed a DB2 instance inside a Docker container. Now I'm trying to connect to it from a simple Golang app, using Windows 11 x64, but i get this error:
Error connecting to database: failed to ...
0
votes
1
answer
49
views
Max number of characters in schema definiton for inline-transfer of CLOBs
I've written a TPT job script that transfers data from a DB2 table to Teradata via ODBC.
There are CLOB fields in the source table, which I also want to transfer. When I don't define a length for the ...
- 209
0
votes
1
answer
123
views
ODBC driver on Azure app service for ASP.NET Core 8 Web API
I have deployed an ASP.NET Core 8.0 Web API hosted on Azure web app service (Windows). It connects to IBM's DB2 i series database and gets the data. I am using ODBC connection, the drivers are setup ...
0
votes
0
answers
60
views
"ERROR - failed inserting new data: ('HY000', "[HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL7008"
can you help me to understand how to avoid this error? This is my code:
conn_test = get_db_connection('liq_test')
cursor_test = conn_test.cursor()
conn = get_db_connection('liq')
cursor = conn.cursor()...
- 1
0
votes
1
answer
78
views
Data Not Displaying Correctly with PostgreSQL odbc_fdw
After connecting to Oracle and DB2 via odbc_fdw and retrieving data, the record count of the tables is displayed correctly, but the data for each record's fields is not displayed correctly.
The value ...
- 1
0
votes
0
answers
45
views
PYODBC Socket Closed
ERRORI'm trying to query a database at work using PYODBC. I am able to make smaller queries no problem but when I get to some more complicated SQL it gives me a socket closed error. Any suggestions on ...
0
votes
2
answers
477
views
SSIS can't connect to DB2 running in SQL Server: ERROR [IM004] [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I have an SSIS package created in Visual Studio 2019 using an ADO.NET connection manager with provider .Net Providers\Odbc Data Provider. When running on my development machine, everything works fine.
...
- 21
0
votes
1
answer
101
views
ODBC 32-Bit System DSN Intermittent Connect Crash
I work for a small Credit Union. A lot of my work deals with Crystal Report software. After upgrading to a new laptop, I found that Crystal Reports would frequently crash whenever I tried to run a ...
0
votes
1
answer
436
views
Why isn't unixODBC isql working with DB2 Community on Docker?
I'm trying to get ODBC connections working on Linux to DB2 Community, running in a docker container. The native db2cli command works, but I can't get the unixODBC tool isql to connect. I think I have ...
1
vote
0
answers
154
views
How to connect hibernate with IBM Db2 ODBC database, is it possible?
Actually, I must connect my application to an IBM Db2 database where I'll have to read and write data. However, I can't change Java for another langage that would connect to an ODBC connection easly.
...
- 25
0
votes
2
answers
519
views
DB2 ODBC connection hangs
I've installed DB2 11.5.7 (and 11.5.8) on my Windows 10.
I've created SAMPLE DB (using db2sampl).
When I'm trying to connect to this DB through ODBC it hangs on connection stage (I have to kill ...
- 1
0
votes
0
answers
153
views
DB2 - Unable to connect sqlcode: -1598,
I'm using ibm_db library in my electron app. I need to connect to an instance of db2 that is running on our AS400 system. I'm doing the connection using this code after that the electron application ...
- 491
0
votes
0
answers
242
views
ibm_db - TypeError: Cannot read property 'indexOf' of undefined in electron app
I need to get some data from db2 inside my electron vue app.
I'm on a windows 11 system with node 16 that is installed as a dev dependency to avoid problems with vue-electron-builder plugin, I've ...
- 3,540
0
votes
0
answers
383
views
ODBC node - CONNECTION_CLOSED_ERROR on ibm db2
I'm trying to connect my electron application to a db2 istance using node-odbc library.
I have checked the ODBC driver installed into the system and all seems to be ok, so I have writed the following ...
- 491
0
votes
1
answer
113
views
Read from database into dictionary VB.net
I have a problem that is solved by selecting all columns of particular records from a DB2 database and shows them to the user as a datagridview.
The user will select a single record changes a column's ...
- 627
0
votes
0
answers
279
views
how to config the db2 odbc driver 32 bit(i need to write 32 bit programe) in Windows 64
install the 64 bit db2 odbc on win10 64bit ,it work well
install the 32 bit db2 odbc on win7 32bit , it work well
but i try to many time, 32 bit db2 odbc on win10 64bit, i use the 32bit odbc manager, ...
-1
votes
1
answer
696
views
DBeaver run AS400 CL commands
I connect to an AS400 database using DBeaver and ODBC, it lets me run CRUD operations better than the 5250 Emulator. Is there a way to run from DBeaver command lines like WRKUSRPRF or CHGUSRPRF?
- 627
0
votes
1
answer
367
views
PHP to DB2 with PDO_IBM Error : SQLDriverConnect: -1390 [IBM] [CLIDRIVER] SQL10007N
In Ubuntu 22.04 I am attempting to connect PHP with a DB2 database via the driver pdo_ibm.so
I have followed this guide, along with IBM documentation: https://github.com/php/pecl-database-pdo_ibm
I've ...
- 57
3
votes
1
answer
937
views
DB2 ODBC connection doesn't work on R 4.2
I had a working connection to a DB2 server from R. Then I ungraded to R v4.2 and it no longer works.
This is my connection string:
con_DB2 = DBI::dbConnect(odbc::odbc(),
...
- 69
0
votes
1
answer
345
views
FileNotFoundException on IBM Data DB2 connection
I am using Visual Studio 2015 and .net451 and I try to connect to an IBM Db2 database, but when I debug my code I get this error:
FileNotFoundException
An unhandled exception of type 'System.IO....
0
votes
0
answers
266
views
DB2 Decimal type not formatted correctly in C# DataSet
Due to reasons, we're having to transform our code to get DB2 data through an Odbc connection instead of OleDb. But we're having some difficulties with DECIMAL types.
We're calling a stored procedure ...
- 13
0
votes
1
answer
255
views
DB2 ODBC converting NULL floats and ints to ~0
Querying DB2 from python using ODBC, I am seeing NULL values converted to 0 (on Linux, seemingly corrupt but close to 0 on Mac M1 -- even more worryingly).
This is using the db2 docker image started ...
- 1,784
0
votes
1
answer
863
views
Cannot connect to DB2 via PDO_ODBC
I got odbc.ini setup with DSN to local DB2 Community edition v11.5.7 database. It runs on port 25010. I've verified it can connect via telnet localhost 25010. PDO_ODBC extension is also installed and ...
- 3,122
0
votes
1
answer
227
views
Window 10 R 4.2.1 DBI::dbGetQuery Error message text unavailable
I am using Window 10. I was using R 4.1.3. I have recently updated to R 4.2.1.
I was able to query from our DB2 database by using the following script.
con = DBI::dbConnect(odbc::odbc(),
...
1
vote
0
answers
358
views
Dockerfile CGO Confusing
I have a golang application and I used odbc driver " https://github.com/alexbrainman/odbc " to connect mssql or mysql on Windows. I added unixodbc-dev and mssql-mysql odbc drivers to ...
- 405
0
votes
2
answers
2k
views
IBM DB2 ODBC DRIVER :: SQL1390C The environment variable DB2INSTANCE is not defined or is invalid
I've followed several guides online and I cannot install IBM DB2 ODBC DRIVER on Windows.
I have downloaded the driver from IBM and installed (which was quite a roller-coaster).
If I follow guide1 or ...
- 12.1k
-1
votes
2
answers
242
views
Insert command not working in .net to DB2 connection
I have a legacy application written in VB.NET, it uses an ODBC connection to write to an IBM DB2 database.
It is not working.
I've tried to see if there is a space in the values, if they are not from ...
- 551
0
votes
0
answers
29
views
Weird OleDbDataAdapter Fill behavior (hangs with explicit fields) on IBM i System
we're migrating our IBM i System from OS 6.0 to 7.4; we're testing all the applications which somehow connect and read/write data to it and we found a weird behavior in one of them.
The application is ...
- 1
2
votes
1
answer
194
views
Cannot see any objects on DB2 (AS400) database after updating to R 4.2.0
When I connect to a DB2 database via ODBC using the recently released R 4.2.0 the database appears to have no objects. Connecting to AWS has no such issues, and objects a viewable using older versions ...
- 23
0
votes
1
answer
883
views
Retrieving data from IBM DB2 using pyodbc and the related error
I confirm that I have gone through multiple posts in StackOverflow with respect to similar problem, still stuck with the below problem, hence posting to seek guidance/pointers.
Following is the code
...
- 235
0
votes
0
answers
258
views
How to catch or skip error lines in Datastage when inserting lines in ODBC
I'am using Datastage 11.7 , I want to insert lines my odbc table , however while inserting I want to skip or catch the line that goes down while inserting all the lines in my odbc , all of that so my ...
- 39
1
vote
1
answer
480
views
IBM DB2 V7.2 ODBC Driver for Linux
I am trying to connect to a client's DB2 v7.2 database in Linux.
I am pretty new to DB2 and could not find 7.2 odbc driver in IBM site. The earliest is 9.1 odbc driver. Is this compatible with v7.2 ?
- 11
0
votes
0
answers
106
views
PDO prepared statement against dB2 Database Failed when execute more than once in Ubuntu Server
I have PDO prepared statement as follows :
$db2 = new PDO($dsn,$user_db, $pass_db);
$db2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db2->setAttribute(PDO::...
- 1
0
votes
1
answer
980
views
Which driver to connect Power BI to DB2?
I have an odd question on connecting Power BI to a DB2 database.
I currently seem to have three similar drivers installed on my computer. If I look in ODBC data source administrator under the drivers ...
- 473
0
votes
1
answer
2k
views
IBM AS400 File not Found error while the Table Object is still there
I'm relatively new to working with remote IBM databases. I am connecting to a remote IBM AS400 database using an ODBC Python3 connector in an Anaconda virtual environment on Windows 10. My connection ...
1
vote
0
answers
509
views
Insert in data in db2 using sqlalchemy using pyodbc and iacces
I'm trying to insert some data on a DB2 table on an IBM iSeries (AS400) server, using sqlalchemy, pyodbc and the iaccess packages.
The server allows me to run SELECT and CREATE queries, but when I try ...
- 1,303
0
votes
0
answers
222
views
.net core 3.1 odbc driver connection failed in debug mode
I created 2 odbc connection (32 and 64 bit) to connect with iseries access odbc driver (db2 IBM)
it works while publish in IIS , but while debugging raise this error ERROR [42000] [IBM][System i ...
1
vote
1
answer
2k
views
IBM DB2 ODBC drivers - DB2COPY1 or IBMDBCL1 for a Power BI connection?
I'm working in a team of people who connect Power BI to a db2 database in order to create reports. However, people are doing this via two different drivers, and this is creating compatibility problems ...
- 473
0
votes
1
answer
505
views
Laravel 8 on AS400 using ODBC table names with dots
I am on a project where I need to retrieve information from a table that contains a "." in it's name... My query looks like this:
$data['scale'] = DB::connection('odbc')
->table('QS36F.&...
- 2,375
0
votes
0
answers
51
views
Is it possible to set up the database connection if we are provided with ODBC registry file?
One of the users already has all the OBDC connections configured on to the RDC user account. That machine is used to connect to all the databases.
A new user on boards into the organization, his log ...
- 1,574
0
votes
0
answers
67
views
ODBC data provider is not listed in data source dialog
I work on asp.net mvc project and have database on Db2.
I am trying to connect to database using ODBC data provider.
But an ODBC data provider is not listed in data source dialog box.
I am trying to ...
0
votes
1
answer
717
views
What is the correct connection string for SQLDriverConnect function to connect to cataloged Db2 database with SSL?
What is the correct connection string for SQLDriverConnect function to connect to cataloged Db2 database with SSL? Programming language - C++.
How I prepare database
db2 "CREATE DATABASE TESTDB&...
- 3
0
votes
1
answer
3k
views
SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'IBMDB2' : file not found
I'm trying to connect to db2 database, trought symfony php app, via ODBC driver, and db2 installed driver (IBM Data Server Driver Package v11.5
). I'm on MAC OS 10.15 CATALINA, with APACHE, and PHP ...
- 29
0
votes
0
answers
4k
views
Powershell how use jdbc driver to connect database
I need to use a JDBC driver (JtOpen AS400) in my Powershell script to connect the DB2 database. Could you help me? I don't know how to write the connection string.
I have tried with ODBC driver but it ...
- 21
0
votes
1
answer
490
views
Difficulty passing a secure string to a system.data.odbc.odbcconnection object
Im trying to pass a secure string to an odbc connection object to save me from passing a plain password over a network but cant quite figure it out. See the current iteration of my script below.
$...
- 21
0
votes
1
answer
5k
views
SQL1109N Database manager fails to load gsk8ssl_64.dll SQLSTATE=42724 for a DB2 DSN
I have created a DB2 (Db2 for Z/OS) DSN in my Windows machine(Windows Server 2016, 64 bit OS) and I am trying to connect to it using SSL mechanism by providing the SSL certificate as ...
- 1
0
votes
0
answers
2k
views
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client machine
I am trying to connect DB2 database servers over secure port using SSL from system ODBC DSN client machine. But I am getting below error
I am using correct DB2 server IP and SSL port and connecting Z/...
1
vote
0
answers
359
views
Invalid cursor position when inserting a blob
I have an old MFC project that I'm trying to update. It's updated from VS2008 to VS2017. Database is also replaced from some old DB2, to DB2 Server Edition 11.5 (Community license). In new environment ...
- 16.8k
0
votes
0
answers
328
views
DB2 ODBC: Receiving error when creating System DSN in 32-bit ODBC administration
Up until 2 days ago, I was using a System DSN in the 32-bit ODBC Administration setup to connect to my DB2 database. I was having no issues. Suddenly it started giving me an error
"SQL10007N ...
- 33