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("jdbcdbc://67.19.166.82:1433/DelhiMart", "delhimart", "delhimart"); %> But it is not working.
I read the problem, but, I was confused trying to understand what you're trying to achieve. Do you want to make the database file available for others to download? If it is then go to C:\Program Files\<YOUR SQL Server Folder>\<DATA FOLDER> and look for the files that end with .mdf and .ldf file extension... You could also do a whole computer search on these types of files and achieve the same thing.