How to create permanent connect using Ms SQL Server Database

Posted on 2001-07-05
Last Modified: 2010-04-16
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.

strDriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
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.

Question by:dennistk

Expert Comment

ID: 6262189
Please give more detail:
Are you use SQLServer DB through Internet ,or in your Lan and present the data to Internet?
LVL 92

Accepted Solution

objects earned 20 total points
ID: 6263712
You can access the database in exactly the same way from the Internet as from the intranet.
LVL 14

Expert Comment

ID: 9017440
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.
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.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tomcat not starting 6 68
MySqlDump not dumping triggers 1 43
sql import cannot be resolved jsp 3 48
Crystal Reports Licensing Questions 4 35
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question