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

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
    21 Posts
    ACCEPTED ANSWER

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-07-04T10:39:16Z  in response to KarthikeyanBaskaran
    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
      ACCEPTED ANSWER

      Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

      ‏2012-08-24T09:59:52Z  in response to ArchanaSoni
      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
    ACCEPTED ANSWER

    Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

    ‏2012-08-29T04:39:36Z  in response to KarthikeyanBaskaran
    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
      ACCEPTED ANSWER

      Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

      ‏2012-12-13T11:23:26Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

        Re: DB2 Access with v9.5fp5_ntx64_dsdriver_EN

        ‏2012-12-13T12:06:40Z  in response to KarthikeyanBaskaran
        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.