Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Error in the URL
manish
2005-07-20 00:00:00.0
Hi!
I am trying to test a database connection using the type 4 drivers downloaded from the website. The drivers that I am using are Access_Direct_Access_JDBC20.

I have IIS server running at 192.168.132.243. This has a vertual directory "thakralnew". In this site I have a a MS-Access database, thakral_db.mdb. My java code is as follows:

try
{ Class.forName("com.hxtt.sql.access.AccessDriver"); /*Registering the Driver*/
}
catch(ClassNotFoundException e)
{ System.out.println("Can not load the driver");
}
System.out.println("driver loaded");
String url= "jdbc:Access://192.168.132.243/thakralnew";
Connection ctn= DriverManager.getConnection(url,"anonymous","guest");
System.out.println("got connected");
Statement stmt= ctn.createStatement();
System.out.println("created statement");
================

I am able to load the driver and connect to the database with the URL:
String url= "jdbc:Access:/c:/thakralnew";

but with the URL:
String url= "jdbc:Access://192.168.132.243/thakralnew";
I am getting a SQLException saying that 192.168.132.243/thakralnew doesnot exist.

Can you please help me.

Thanks
Regards
Manish
Re:Error in the URL
HXTT Support
2005-07-20 00:00:00.0
>String url= "jdbc:Access://192.168.132.243/thakralnew";
Please try "jdbc:Access://///192.168.132.243/thakralnew"; since you're using DIRECT Access mode for a UNC path.
Re:Re:Error in the URL
HXTT Support
2005-07-20 00:00:00.0
BTW, you can use "jdbc:Access://///192.168.132.243/thakralnew/thakral_db.mdb" too.
Re:Re:Re:Error in the URL
Manish
2005-07-20 00:00:00.0
Dear Support Team!
Thanks a lot for your help. I was able to get it working with your both your suggested responses.

Now, after the local testing, I want to try it with my web database. My website domain name is thakral.com.kh and I have the same database available on the website. My string URL is as below

String url= "jdbc:Access://///thakral.com.kh/thakral_db.mdb";

But it ends up with a similar error message,"//thakral.com.kh/thakral_db.mdb doesn't exist!".

Please help.

Also, I would like to know more regarding the licensing of the product. I am going to write one java program that is going to connect to my web database and manipulate records. I am not sure which license program is applicable (I think it should be 170 USD option) and how do we pay you.

Thanks
Regards
Manish


Re:Re:Re:Re:Error in the URL
HXTT Support
2005-07-20 00:00:00.0
Dear Manish,

> String url= "jdbc:Access://///thakral.com.kh/thakral_db.mdb";
>But it ends up with a similar error message,"//thakral.com.kh/thakral_db.mdb doesn't exist!".
It's a bad idea to use DIRECT ACCESS mode on internet through share file mode since it needs to send all bytes of your database.
One solution: run your application with DIRECT ACCESS mode on your thakral.com.kh host through JSP/BROWSER interface.
Seconde solution: run an Access service(com.hxtt.sql.admin.Admin) on your thakral.com.kh host, then your applcation can use REMOTE ACCESS mode to visit your data. A simple url sample should be "jdbc:Access://thakral.com.kh:8029/c:/thakralnew/thakral_db.mdb?password=aPassword".

>I am not sure which license program is applicable (I think it should be 170 USD option) and how do we pay you.
Yeah. You need only a Server license. HXTT accepts bank transfer and online order. You can contact webmaster@hxtt.com for more details when you have completed your program.

With best regards,

Daiwei

Re:Re:Re:Re:Re:Error in the URL
manish
2005-07-20 00:00:00.0
Dear Support Team,
Thanks for your prompt reply.

I am using a server in US and it is not managed by us. We are just hosting our site there.I am not sure if that Server will support Java and allow me to run a Java application. This is the reason I wanted to access the data using the way that I proposed.

>One solution: run your application with DIRECT ACCESS mode on your thakral.com.kh host through JSP/BROWSER interface.

Solution 1 is already implemented using a ASP/Browser interface. We are looking at developing a solution through which we do offline data entry using XML and then upload the data on the website using JDBC.

>Seconde solution: run an Access service(com.hxtt.sql.admin.Admin) on your thakral.com.kh host, then your applcation can use REMOTE ACCESS mode to visit your data. A simple url sample should be "jdbc:Access://thakral.com.kh:8029/c:/thakralnew/thakral_db.mdb?password=aPassword".

Solution 2 seems to be doable but only requirement for that would be that the server supports Java. Is that correct? Will I be able to create and manage this service remotely? What other support wll I need from my web hosting providers?

Please advice.

Thanks
Regards
Manish
Re:Re:Re:Re:Re:Re:Error in the URL
Manish
2005-07-20 00:00:00.0
Hello!
>Seconde solution: run an Access service(com.hxtt.sql.admin.Admin) on your thakral.com.kh host, then your applcation can use REMOTE ACCESS mode to visit your data. A simple url sample should be "jdbc:Access://thakral.com.kh:8029/c:/thakralnew/thakral_db.mdb?password=aPassword".

Can you please give me a sample program to create and start the service on the server.

Thanks
Regards

Manish
Re:Re:Re:Re:Re:Re:Re:Error in the URL
HXTT Support
2005-07-20 00:00:00.0
Dear Manish,

Solution 1 and Solution 2 haven't any program code difference except the JDBC url. Most of host service provider support Java too. The important difference is construction design, JSP/BORWSER, or Java applet(application)/database server.

>This is the reason I wanted to access the data using the way that I proposed.
Access data through file share on internet is slow and unsafe for sensitive data.

>Can you please give me a sample program to create and start the service on the server.
Please read dbadmin.html of Development document. First you can start a service of "jdbc:Access://localhost:8029/c:/thakralnew/thakral_db.mdb" on your development PC, then you can use "jdbc:Access://intranetIPorHostName:8029/c:/thakralnew/thakral_db.mdb" in your code to visit that service in your intranet. It's easy to release your code into your host since you need only to modify the JDBC url.

Any question or requirement? Just let us know.

With best regards,

Daiwei
Starting a service
manish
2005-07-21 00:00:00.0
Dear Daiwei,
Hello again!

On my local PC I was able to create, start a service and execute my program to access the data through the service.

How do I now create, configure and run the service on my host in US. As I described earlier that I have no administrative previledges on the server. If I have to request for something from the administrator. What would that be?

Thanks
Regards

Manish
Re:Re:Re:Re:Re:Re:Re:Re:Error in the URL
HXTT Support
2005-07-21 00:00:00.0
> How do I now create, configure and run the service on my host in US.
> As I described earlier that I have no administrative previledges on the
> server. If I have to request for something from the administrator.
> What would that be?
If your host in US supports Java, it's easy to run Solution 1 through JSP/browser since HXTT Access can be load easily on DIRECT ACCESS mode without service setting.
For Solution 2, HXTT Access needs a right to listen a port, for instance, 8029. Now HXTT Access REMOTE ACCESS need to run com.hxtt.sql.admin.Admin GUI. It seems you shouldn't have such a rigth at your US host. I guess that you should have the JSP/servlet right. Then maybe we can wirte and provide a servlet proxy to support REMOTE ACCESS for Solution 2.




Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap