If I understand your question, I think you are asking if you could
install 2 Clients on the same workstation, each with it's own
db2cli.ini settings ?
If that is your question, I think the answer is no. I don't think you
can have two clients on 1 box without conflicting.
On 20 May 2004 11:39:40 -0700,
sea_099@hotmail.com (sea) wrote:
[color=blue]
>Thank you so very much -- this really helps, I had no idea you could
>set this value within VB6!
>
>One more question -- if I have two separate runtime clients connecting
>to the same remote db server, with the longdatacompat variable of each
>runtime client configured differently to match the vb and java app
>driver requirements, will this be another possible solution to the
>problem?
>
>Thank you again!
>
>================================================= ===================
>
>kurt.wood@NOSP@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40acae10.4467281@news.state.mn.us>...[color=green]
>> Here you go (btw, I am assuming VB6)..
>>
>> The old one using ODBC
>> = "Driver={IBM DB2 ODBC DRIVER};Database=" & msDBName &
>> ";DSN=;UID=;PWD=;" & _
>> "AUTOCOMMIT=1;EARLYCLOSE=0;LOBMAXCOLUMNSIZE=104857 5;LONGDATACOMPAT=1;"
>> & _
>> "CURSORHOLD=1;DBALIAS=" & msDBName & ";PATCH1=1408;PATCH2=6"
>>
>> The new one using the OLEDB provider (UDB 8.1.4)
>>
>> = "Provider=IBMDADB2;Database=" & msDBName & ";DSN=;UID=;PWD=;" & _
>>
>> "AUTOCOMMIT=1;EARLYCLOSE=0;LOBMAXCOLUMNSIZE=104857 5;LONGDATACOMPAT=1;"
>> & _
>> "CURSORHOLD=1;DBALIAS=" & msDBName &
>> ";PATCH1=1408;PATCH2=6"
>>
>>
>> That should do it for you!
>>
>>
>> On 19 May 2004 21:18:20 -0700,
sea_099@hotmail.com (sea) wrote:
>>[color=darkred]
>> >Thank you so very much for your tip, this would REALLY help - yes,
>> >could you please send the complete connection string, if this is not
>> >too much of a trouble? You can either reply to this board, or email me
>> >at
sea_099@hotmail.com. Thank you again!
>> >
>> >================================================= ==========================
>> >
>> >
>> >kurt.wood@NOSP@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40ab61dc.6338453@news.state.mn.us>...
>> >> Set it to work for the java app and use a connection string in the VB
>> >> app that include LONGDATACOMPAT=1. That's what we did. If you need to
>> >> the whole connection string, I can provide it.
>> >>
>> >> On 18 May 2004 16:03:36 -0700,
sea_099@hotmail.com (sea) wrote:
>> >>
>> >> >I have 2 applications, one a Microsoft Visual Basic application and
>> >> >the other a Java application both connecting to the same DB2 database.
>> >> >The database has binary LOB objects. The Visual Basic application uses
>> >> >ODBC bridge and the Java application uses JDBC app driver. Inorder for
>> >> >the VB application to correctly load and display the LoB objects, I
>> >> >need to set the long object binary treatment in db2 client
>> >> >configuration assistant to longvar data. But for the Java application
>> >> >to run using the app driver the long object binary treatment needs to
>> >> >be set to LOB.
>> >> >
>> >> >Question is, how can I run the two applications, one using odbc and
>> >> >the other using jdbc app driver on the same client computer?
>> >> >
>> >> >Thank you very much[/color][/color][/color]