Possible to set up datasources through Java code? 
Author Message
 Possible to set up datasources through Java code?

I have a java application that will be going out to 150+ remote field
sales people.  It allows them to download their "chunk" of data from a
DB2 mainframe database.  After doing that, they can disconnect and work
with the data in their local MS Access databases.  It all looks like its
going to work fine, but we're wondering how we're going to set up the
ODBC data sources on these 150+ laptops without writing native code or
without having them send in the laptops.  Is there are way to register a
database as an ODBC data source via Java code.  I thought it might've
been in the DriverManager class, but I couldn't find it.

Thanks.



Tue, 06 Nov 2001 03:00:00 GMT
 Possible to set up datasources through Java code?

Cloudscape is about to release full application synchronization for its Java
SQL database. This will solve the problem of managing remote data collection
(and enable you to upgrade the application in the field). You can connect
our sync server to DB2 either through direct calls, or through a piece of
standard middleware like Active Software, Lakeview or IBI. You can get a
white paper about this from our web site if you're interested. Go to
http://www.cloudscape.com/pdf/DeployingWP.pdf

Malcolm Colton
VP Marketing
Cloudscape

Quote:

> I have a java application that will be going out to 150+ remote field
> sales people.  It allows them to download their "chunk" of data from a
> DB2 mainframe database.  After doing that, they can disconnect and work
> with the data in their local MS Access databases.  It all looks like its
> going to work fine, but we're wondering how we're going to set up the
> ODBC data sources on these 150+ laptops without writing native code or
> without having them send in the laptops.  Is there are way to register a
> database as an ODBC data source via Java code.  I thought it might've
> been in the DriverManager class, but I couldn't find it.

> Thanks.



Tue, 06 Nov 2001 03:00:00 GMT
 Possible to set up datasources through Java code?
As far as I know this has to be done with some type of setup program that is
native to the platform. At least in 1.1 there is no way to get a list of
DSN's on the machine or for that matter add a data source either... if you
could find a java only access driver you could skip that stuff all together
...

Tony


Quote:
> I have a java application that will be going out to 150+ remote field
> sales people.  It allows them to download their "chunk" of data from a
> DB2 mainframe database.  After doing that, they can disconnect and work
> with the data in their local MS Access databases.  It all looks like its
> going to work fine, but we're wondering how we're going to set up the
> ODBC data sources on these 150+ laptops without writing native code or
> without having them send in the laptops.  Is there are way to register a
> database as an ODBC data source via Java code.  I thought it might've
> been in the DriverManager class, but I couldn't find it.

> Thanks.



Tue, 06 Nov 2001 03:00:00 GMT
 Possible to set up datasources through Java code?
This can be done but you will need to know how to create registry keys etc
via native API calls.  I concluded it was going to be abit tricky and was
waiting either for pure JDBC drivers or until one of the installer programs
announced they had figured out a way to do this.  It might be a while
though!
Another option is to just write a call to the ODBC manager to start it up so
you can make your choices on screen as part of an installation script etc.

I favour option two.  Its simple, pragmatic and instructions can be written
for the person installing the app.

Craig

Quote:

> I have a java application that will be going out to 150+ remote field
> sales people.  It allows them to download their "chunk" of data from a
> DB2 mainframe database.  After doing that, they can disconnect and work
> with the data in their local MS Access databases.  It all looks like its
> going to work fine, but we're wondering how we're going to set up the
> ODBC data sources on these 150+ laptops without writing native code or
> without having them send in the laptops.  Is there are way to register a
> database as an ODBC data source via Java code.  I thought it might've
> been in the DriverManager class, but I couldn't find it.

> Thanks.



Fri, 09 Nov 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. is it possible to access SQLOLEDB provider datasources?

2. Is it possible to access SQLOLEDB Provider datasources?

3. Maxi code for UPS

4. Setting up ODBC Datasources

5. Need referrals for Business Set Ups

6. Multi-Protocol Set Ups

7. ---JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA---

8. Convert VB 5.0 Code to Java JDeveloper Code

9. Calling Java code on disc from a Java Stored Procedure

10. Java byte-code to UNIX Binary code?!

11. change cursor code to set based code

12. Generating runtime code (Possible???)


 
Powered by phpBB® Forum Software