Convert connection string to IBM command line

I have a connection string for an IBM iSeries, which I am using in a VB.Net application via the DB2.Net data provider.

Here is the connection string, with examples:

"DataSource=MyDatabase; QueryOptionsFileLibrary=MyLibrary; USER ID=MyUserName; Password=MyPassword;Connection Timeout = 0;Library List=MyLibList;"

What I would like to know is what this translates to in command line language.

I need this info because my program is reporting errors about a conversion issue, but for all I can see, the data is appropriate. A portion, or all of the command is being written to a character field in the table and causing the field to overflow essentially. The portion of command that I can see is:


It looks like the first "C" is being truncated, pointing to the change query attributes command which I think is from the queryoptionsfilelibrary in the connection string, and the rest is even causing the rest of the record on the query screen to show up in High Intensity.

A coworker suggests adding ClientWorkstation=" & System.Net.Dns.GetHostName & ";" to the end of my string will help, but I would like to understand what is causing the issue in the first place.

Any info on this issue would be greatly appreciated. Thank you.

edit delete
are you sure?
asked Andrew Stair

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions