Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MS SQL-2000 database connectivity

843859Jul 15 2006 — edited Nov 15 2006
Hi,

The problem:-
-------------------
We are not able to transfer MS SQL data from local machine to Web.

Wht we did:-
-----------------
Look presently the data base is in the local machine. Now using our control panel of datapacket hosting we have configured the dns and the MS SQL DB. Once it is configured it creates a "db" directory in the FTP server of ours (It is created proper). Now we have to transfer the database files in that "db" directory but we do not knw which files to transfer from local machine DB.

In the case of adas.co.in our database was MS Access and in that case we have copied the *.mdb file of MS Access in "db" directory of the ftp server (oviously after configuring the dns and db in the control paanel). And it worked properly. But in case of MS SQL we do not knw the file.

Wht will be the code
-----------------------------
dns: delhimart
database: DMmart
datebase user: aaaa
password: bbbb
ip: 1.1.1.1
port: 1234

In the above case wht will the JSP conectivity code

Can you kindly send me in details how to connect to my database.

Look i have build this website in my local machine with the database in my local machine. Now what are the think i must t\do to copy this data.

What i did
-----------
1) configurd the dns(DelhiMart) and database(DelhiMart) in control pannel.
2) copied the DelhiMart_Data.MDG and DelhiMart_Log.LDf files from my local machine to the "db" directory of my ftp server.
3) writen the connectivity code in a file connection.jsp and put it in wwwroot/links/ directory in my ftp server.
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc://67.19.166.82:1433/DelhiMart", "delhimart", "delhimart");
%>

But it is not working.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2006
Added on Jul 15 2006
10 comments
165 views