MS SQL-2000 database connectivity
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.
[1840 byte] By [
Dipyaa] at [2007-10-3 0:39:44]
Woah Dude Woah.
This is a loooooong way from working. An MS-SQL Database requires an MS-SQL Database Server. MS-SQL is NOT a file based database like Access it is a full blown database service.
Copying the files over wont work and is wrong anyway. First you need a copy of MS-SQL server running on the target machine (or available for the target machine to connect to). Then you will move the data (data not files) across from server to another.
Please consult your local SQL Server DBA promptly before you do yourself permanent damage.
Wow. Staggering. Amazing.I wonder if somebody was paying for this bit of ETL work?%
Thanks for your reply,Can you kindly tell me in details how to do it (transfer data from local machine to server).....................Dipyaman
Dipyaa at 2007-7-14 17:33:50 >
> Thanks for your reply,
>
> Can you kindly tell me in details how to do it
> (transfer data from local machine to
> server).....................
>
> Dipyaman
No. This is the second step NOT the first step.
The first step is do you have MS-SQL Server installed and running on the server?
> Copying the files over wont work and is wrong
> anyway. First you need a copy of MS-SQL server
> running on the target machine (or available for the
> target machine to connect to). Then you will move the
> data (data not files) across from server to another.
In SQL Server 2005 you can attach and detach databases. The database itself can then be moved with a file copy.
I believe that 2000 allows that as well.
One can also do a back up and restore.
> Thanks for your reply,
>
> Can you kindly tell me in details how to do it
> (transfer data from local machine to
> server).....................
>
It might help to know what you are accomplishing by doing the copy.
It is for a new install?
Do you want to merge the data in to an existing database?
Are you just keeping a back up there (it isn't intended to be used by another database instance)?
Thanks for the replies,
As per the querys:
1) I am trying to use the Database of my host (hosting server of datapacket). They have a support for MS-SQL-2000. Therefore surely the server is there. After my CPanel configuration i got the Database Server IP (67.122.X.X), Port - 1433, SQL Server user and pasword.
2) In my local machine SQL Server 2000 is installed. Where the databse and DNS is configured.
Now, from this local machine how can i transfer the data to the host machine (remote SQL Server).
Simpliy copying Files it is not working. And i don't have access to the remote SQL-SERVER as it is in the host machine of datapacket. I can only configure it throuch there Control Panel and throuch FTP can copy the required files in there machine. I have a user in that remote MS-Sql server that all i have.
As per my understanding after the control panel configuration the database and the DNS is created in the remote Sql-Server of datapacket. Now all i have to do is transfer the data & tables. HOW TO DO THAT?
I have tried using Export but it fails to connet the remote database.
Thanks in Advance
Dipya
Dipyaa at 2007-7-14 17:33:50 >
> Now, from this local machine how can i transfer the> data to the host machine (remote SQL Server). Still doesn't answer the questions that I asked.
hello sir,
i want to Load Local database to Remote database in ms-SQL 2000 database with Use of Query Analyzer.
--
my application in vb6.0 with ms- sql 2000
how can i do it
send me sample Application
thanks in Advance
kanthavadiya amrut
amrut01cp089kumar@yahoo.com
This is what worked for me when I migrated from a msaccess db on a local machine then moved the web app online to a mssql2005 server.
First, I got a host for the MSSQL database, rather cheaply ( 9.99 a month).
Then I located an article from aspfree.net ( my favorite) that went through the neccessary steps to create the proper dsn to utilize the Upsizing Wizard in Access to move all the access tables into created sql db tables on the local machine.
Once that was done ( the actual transferring of the tables from access to mssql) I created a backup of the sqldatabase on the local machine then uploaded up to the host server (mssql express 2005).
At that point, my host restored the backed up database and I had access to all the tables from my web app code.
Also necessary in your app code is the actual physical path to the database directory on the host server. The server host will supply that to you.
Finally I use SQL Server Management Studio (free from microsoft) to manipulate and update tables from my local machine to the remote ser ver.
I do believe that somewhere on my hard drive I still have that article.
My suggestion, if you do attempt this....backup - backup - backup...
regards and
best of luck
