Page 1 of 1

CONNECTING TO IBM DB2

Posted: Thu Jun 25, 2015 7:43 am
by Traffic_TransNetPlanAnalyst
I am attempting to connect to IBM DB2 and PrimalSQL is not allowing me to make this happen. Its great to have all of the other connection tools but DB2 would be great too. Any help would be great!!!

using the same connection strings we use in apps and AQT...

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

1. PrimalSQL 2015, Version & Build: 4.1.41
2. 64 bit version
3. WIN7 64 bit.

CONNECTING TO IBM DB2

Posted: Thu Jun 25, 2015 7:43 am
by SAPIEN Support Forums
This is an automated post. A real person will respond soon.

Thank you for posting, Traffic_TransNetPlanAnalyst.

Did you remember to include the following?
  • 1. Product, version and build (e.g. Product: PrimalSQL 2014, Version & Build: 4.0.36. Version and build information can be found in the product's About box accessed by clicking the blue icon with the 'i' in the upper right hand corner of the ribbon.)
    2. Specify if you are running a 32 or 64 bit version
    3. Specify your operating system and if it is 32 or 64 bit.
    4. Attach a screenshot if your issue can be seen on the screen
    5. Attach a zip file if you have multiple files (crash reports, log entries, etc.) related to your issue.
If not, please take a moment to edit your original post or reply to this one.

*** Make sure you do not post any licensing information ***

Re: CONNECTING TO IBM DB2

Posted: Thu Jun 25, 2015 8:35 am
by Traffic_TransNetPlanAnalyst
Future Reference.... create an Alias in your (windows) ODBC tool
Then use the following ODBC conn String in PrimalSQL

DSN=YourDB2Alias;Uid=YourDB2UserName;Pwd=YourDB2Password

Re: CONNECTING TO IBM DB2

Posted: Thu Jun 25, 2015 9:45 am
by davidc
We don't offer direct DB2 support at this time but I will add it to the wish list. And yes, ODBC can sometimes be a work-around.

David