I am using the above driver to connect to the DB2 Database, previously I am using the same int Windows Vista / 64-bit OS. Now, I have migrated my OS to Windows 7 and installed the same driver here.
We are using a web service to connect to the database. So, when i re-build the same web service in VS 2005 it is throwing me an error like
"Could not load file or assembly 'IBM.Data.DB2, Version=220.127.116.11, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. An attempt was made to load a program with an incorrect format."
in the web.config file.
Your help is greatly appreciated.
Thanks in Advance,
Pinned topic DB2 Access with v9.5fp5_ntx64_dsdriver_EN
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-13T12:06:40Z at 2012-12-13T12:06:40Z by KarthikeyanBaskaran
ArchanaSoni 2700053MB431 Posts
Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN2012-07-04T10:39:16ZThis is the accepted answer. This is the accepted answer.Hi Karthikeyan,
Could you please try to run testconn20 and share the output ?
Syntax for testconn20 is:
Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN2012-08-24T09:59:52ZThis is the accepted answer. This is the accepted answer.
- ArchanaSoni 2700053MB4
Thanks for your time in this.
Hope you are saying something related to Connection String that we people will be using when we connect to database.
Also, based on the reply from IBM Development Support team's reply - have concluded the reason behind the above problem which I have mentioned - "My PC is equipped with Windows 7 64 bit OS and DB2 Driver V9.5 will not be compatible with that, so we can't use that to build any .Net applications in this platform."
So, I changed my machine's OS to Win 7 - 32bit and tried running the web service which I built and it is working fine now. But, the connectivity seems to be damn slow when we try to fetch huge amount of data. Do you people have any idea as how to improve that?
SystemAdmin 110000D4XK2826 Posts
Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN2012-08-29T04:39:36ZThis is the accepted answer. This is the accepted answer.Hi J,
Could you please give us testconn40 output? testconn40 would be in <product install directory\bin.
testconn40 "Server=<ipconfig/machine name>:<port no.>;Database=<databasename>;uid=<userid>;pwd=<password>"
Also please provide us with screenshot of the error and commontoolreg*.log in %APPDATA%\IBM\vsnet2010
Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN2012-12-13T11:23:26ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Thanks for the answer
Sorry for replying very late.
Tested the way you have said and i have testconn20, did a testing based on that. This is the first time i came to know that this is a way to test it.
Step 1: Printing version info
.NET Framework version: 2.0.50727.5456
DB2 .NET provider version: 18.104.22.168
DB2 .NET file version: 22.214.171.124
Capability bits: ALLDEFINED
Factory for invariant name IBM.Data.DB2 verified
Factory for invariant name IBM.Data.Informix verified
IDS.NET from DbFactory is Common IDS.NET
VSAI is not installed properly
Step 2: Connecting using "DATABASE=<dbname>;SERVER=<servername>:<portno.>;User
Server type and version: OS/390 10.01.0005
Step 3: Selecting rows from SYSIBM.systables to validate existance of packages
SELECT * FROM SYSIBM.systables FETCH FIRST 5 rows only
Step 4: Calling GetSchema for tables to validate existance of schema functions
Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN2012-12-13T12:06:40ZThis is the accepted answer. This is the accepted answer.
- KarthikeyanBaskaran 2700054H53
Also did the same testing repeatedly and it takes the time like this:
1st: 40 secs.
2nd: 39 secs.
3rd: 45 secs.
Also, heard from some of my peers here and they said "Adding one more attribute as Authentication:Server" will increase the connectivity pace. Tried that way but still it takes the same amount of time, will be really grateful if you could get me some ideas on this!