VB vs JAVA

[sea]

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

[Remove the obvious for replies]

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, se*****@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

[sea]

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 se*****@hotmail.com. Thank you again!

================================================== =========================
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@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, se*****@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

[Remove the obvious for replies]

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, se*****@hotmail.com (sea) wrote:

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 se*****@hotmail.com. Thank you again!

================================================= ==========================
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@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, se*****@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

[sea]

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@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...

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, se*****@hotmail.com (sea) wrote:

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 se*****@hotmail.com. Thank you again!

================================================= ==========================
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@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, se*****@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

[Remove the obvious for replies]

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, se*****@hotmail.com (sea) wrote:

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@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...

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, se*****@hotmail.com (sea) wrote:

>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 se*****@hotmail.com. Thank you again!
>
>================================================= ==========================
>
>
>kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@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, se*****@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