Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

How to create permanent connect using Ms SQL Server Database

I writing a java application that can run in LAN And Internet using Java 2 and JDBC. The Database is Ms SQL Server 7.

For the LAN I can using DataSource to create a connetion.
example:

strDriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(strDriverName);
gCon = DriverManager.getConnection(ODBCPub, "sa", "sa");

But, how can I create connection for the internet application or using back the same method like above.

Pls guide me or provide me some sample coding.


 
0
dennistk
Asked:
dennistk
1 Solution
 
hotlyqCommented:
Please give more detail:
Are you use SQLServer DB through Internet ,or in your Lan and present the data to Internet?
0
 
objectsCommented:
You can access the database in exactly the same way from the Internet as from the intranet.
0
 
sudhakar_koundinyaCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:


[points to objects]


Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
sudhakar_koundinya
EE Cleanup Volunteer
---------------------
If you feel that your question was not properly addressed, or that none of the comments received were appropriate answers, please post your concern in THIS thread.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now