DB2 connectivity without client drivers
I'm using EF 6 (Code first) with the IBM.Data.DB2.EntityFramwork nuget package to access a db2 database server. Working locally it all works as expected, but when deployed to a test server I get an exception: "System.MissingMethodException: Method not found: 'Void IBM.Data.DB2.InternalStruct6.SetDefault()"
I'm no DB2 wizard but I think the issue is related to a incompatible version of the db2 client drivers installed on the test server (9.7?). Entity framework 6 support needs version > 10.5. (I must have installed the 10.5 version locally at some point).
It would be nice to be able to run the application on any pc without additional dependencies, so my question is: Are there any way of skipping the db2 clients/drivers installation, and rather reference certain db2 dll's (or other nuget packages), to access db2 db servers?
Ok, I think asking the question resulted in a moment of enlightenment. I guess the answer is NO, as the db2 clients/drivers actually installs the db2 odbc data source driver for db2. (Located in Administrative Tools -> Data Sources (ODBC)).
- SQL Query to Get DB2 Version on IBM i
- Paging enormous tables on DB2
- Connect to IBM DB2 with SQuirreL "Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001"
- db2 query top group by
- Unable to connect DB2 Database with Python in Visual Studio
- Describe is not working in IBM DB2
- Splitting Multi Value Column In DB2
- How to rebuild index in DB2 9.7 LUW
- Connecting to IBM AS/400 with OS/400 data queue from a C# ASP.NET Core 6 Web API
- Create table in DB2 throws BOOLEAN data type is not supported error. Any idea how to resolve this?
- How to format Db2 timestamp with UTC consideration
- SQL using in operator with fetch first rows only
- Match java.sql.Timestamp with DB2 Timestamp
- Add N business days to a given date skipping holidays, exceptions and weekends in SQL DB2
- Db2: how to format output?
- DB2 UTF8 storage configuration
- Not able to install/compile perl module DBD::DB2 on Rocky Linux 9.4 with cpanm
- Analyzing Color Breakdowns by Name
- DB2 Conditional WHERE clause
- Querying DB2 every 15 seconds causing memory leak in NodeJS
- To get the previous record which is less than the given date and time
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found
- Get columns of index on DB2
- Unable to convert bytes from charset 65535 in to Japanese (5035)
- ibmcom/db2 docker image fails on m1
- IBMi SQL stored procedures - how to set comma / decimal point in numbers
- as400 (IBMi) journals for analysis
- Batch update a column from a Select in AS/400
- IBM Db2 Query Not Returning Expected Results for JSON Array Objects