MS SQL-2000 database connectivity
843859Jul 15 2006 — edited Nov 15 2006Hi,
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.