Discussion Locked

web database dev

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Novice doing OJT. I have a web page on a virtual server with a hosting company which offers sql server 7. My question is How do I connect to the database or do I have to have sql server 7 on my local machine and upload my database to the server?? Any help or direction would be greatly appreciated. Remember you once were naive.

7 replies

by alterego2

I know of two methods:
1)isqlw
2)MMC

1)isqlw will allow you to run SQL commands from a command prompt or user interface.
2)MMC will allow you to connect via the management console (easier if you are a novice)

Either method will require you to upload file groups/databases.

ISPs usually only allow isqlw access and should provide full instructions on how to set this up (fairly straight forward you just choose your client netwrok protocol and a remote port to connect to). You will need the SQL client software.
The following address has a bit of information that you might find useful.
http://www.atlantis-intl.com/isp/sql7.html

by donq

Your Hosting Company's SQL-Server (database) will become the "back-end" (or data warehouse) for your software. On your PC (to save money) you could create a temporary "back-end" using Microsoft Access that includes a permanent "front-end" within the same Access ".mdb" file. Once you get everything tested and working properly Access allows users to "click a Wizard button" to upsize the databases (table)structure into SQL-Server. Access comes with the SQL driver since both products are Microsoft's and ally you need do is ask your Host how you (or they) duplicate your Access structure. You will need to coordinate Trigger and Procedure conversions so if you are truly "Novice" you must understand there is much to learn about database normalization and/or data modeling. But all learned skills will serve you well for years. Good Luck!

by b1xml2

The answers are quite straight-forward:-
1. Unless you have at least 128kb/s in your internet connection, using MMC (SQL Enterprise Manager) to connect to your database on the ISP is simply going to time out.
2. I have ported data to MS SQL Server7.0 residing on the ISP Network. This is my advice:-
a. Have a local database and SQL 7 (a desktop version is pretty good) on the box being used to port the data. It is always a good idea to have an exact copy on your box. Never rely completely on someone else making a backup for you. Backups have been known to fail at crucial times!!!
b. Porting your entire database or a portion of it is extremely easy to do using DTS packages.
c. Connecting to the SQL Database is easy using the Query Analyser or what was known as ISQL/Windows.
d. If you are dealing with SQL 7, forget about Access. SQL 7 has much more powerful ANSI-SQL support as it is MS's flagship RDBMS.
e. Data entry can be done via the web application if so desired, or simply through sql scripts executed via the Query Analyzer or instead porting of tables with data through DTS packages.
f. And by the way, index your tables thoughtfully; use stored procedures to get the best out of SQL.

Note: whether you have the SQL Server Engine installed or not, you still should have the SQL Client Utilities Installed!

Regards,

Brandon Driesen
Senior Analyst Programmer.

This discussion is closed to new replies.