Link to home
Start Free TrialLog in
Avatar of dennistk
dennistk

asked on

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.


 
Avatar of hotlyq
hotlyq

Please give more detail:
Are you use SQLServer DB through Internet ,or in your Lan and present the data to Internet?
ASKER CERTIFIED SOLUTION
Avatar of Mick Barry
Mick Barry
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.