Topic
  • 5 replies
  • Latest Post - ‏2012-12-13T12:06:40Z by KarthikeyanBaskaran
KarthikeyanBaskaran
KarthikeyanBaskaran
6 Posts

Pinned topic DB2 Access with v9.5fp5_ntx64_dsdriver_EN

‏2012-06-06T12:08:48Z |
Hi,

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=9.0.0.2, 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,
Karthikeyan.
Updated on 2012-12-13T12:06:40Z at 2012-12-13T12:06:40Z by KarthikeyanBaskaran
  • ArchanaSoni
    ArchanaSoni
    22 Posts

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-07-04T10:39:16Z  
    Hi Karthikeyan,

    Could you please try to run testconn20 and share the output ?

    Syntax for testconn20 is:
    testconn20 "database=<dbName>;Server=<serverName>:<portNumber>;uid=<User>;pwd=<password>"
    Thanks
    Archana
  • KarthikeyanBaskaran
    KarthikeyanBaskaran
    6 Posts

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-08-24T09:59:52Z  
    Hi Karthikeyan,

    Could you please try to run testconn20 and share the output ?

    Syntax for testconn20 is:
    testconn20 "database=<dbName>;Server=<serverName>:<portNumber>;uid=<User>;pwd=<password>"
    Thanks
    Archana
    Hi Archana,

    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?

    Thanks,
    Karthikeyan.
  • SystemAdmin
    SystemAdmin
    2826 Posts

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-08-29T04:39:36Z  
    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

    Malar.
  • KarthikeyanBaskaran
    KarthikeyanBaskaran
    6 Posts

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-12-13T11:23:26Z  
    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

    Malar.
    Hi Malar,

    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.
    Result is:

    Step 1: Printing version info
    .NET Framework version: 2.0.50727.5456
    DB2 .NET provider version: 9.0.0.2
    DB2 .NET file version: 9.5.5.2
    Capability bits: ALLDEFINED
    Build: 20091123
    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
    Elapsed: 2.7711585

    Step 2: Connecting using "DATABASE=<dbname>;SERVER=<servername>:<portno.>;User
    ID=<userid>;Password=<pwd>"
    Server type and version: OS/390 10.01.0005
    Elapsed: 2.483142

    Step 3: Selecting rows from SYSIBM.systables to validate existance of packages
    SELECT * FROM SYSIBM.systables FETCH FIRST 5 rows only
    Elapsed: 0.9760559

    Step 4: Calling GetSchema for tables to validate existance of schema functions
    Elapsed: 33.6829265
    Test passed.
  • KarthikeyanBaskaran
    KarthikeyanBaskaran
    6 Posts

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-12-13T12:06:40Z  
    Hi Malar,

    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.
    Result is:

    Step 1: Printing version info
    .NET Framework version: 2.0.50727.5456
    DB2 .NET provider version: 9.0.0.2
    DB2 .NET file version: 9.5.5.2
    Capability bits: ALLDEFINED
    Build: 20091123
    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
    Elapsed: 2.7711585

    Step 2: Connecting using "DATABASE=<dbname>;SERVER=<servername>:<portno.>;User
    ID=<userid>;Password=<pwd>"
    Server type and version: OS/390 10.01.0005
    Elapsed: 2.483142

    Step 3: Selecting rows from SYSIBM.systables to validate existance of packages
    SELECT * FROM SYSIBM.systables FETCH FIRST 5 rows only
    Elapsed: 0.9760559

    Step 4: Calling GetSchema for tables to validate existance of schema functions
    Elapsed: 33.6829265
    Test passed.
    Hi Malar,

    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!

    Thank you,
    Karthikeyan.