Solved

How to create permanent connect using Ms SQL Server Database

Posted on 2001-07-05
3
237 Views
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.
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
Comment
Question by:dennistk
3 Comments
 

Expert Comment

by:hotlyq
Comment Utility
Please give more detail:
Are you use SQLServer DB through Internet ,or in your Lan and present the data to Internet?
0
 
LVL 92

Accepted Solution

by:
objects earned 20 total points
Comment Utility
You can access the database in exactly the same way from the Internet as from the intranet.
0
 
LVL 14

Expert Comment

by:sudhakar_koundinya
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
powerN  challenge 3 46
strCopies  challenge 17 73
Free Alternative to JIRA 4 52
JUnit 4 @Before and @BeforeClass differences 3 19
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now