General discussion

Locked

SQL - This should be an easy one!

By Corky132 ·
I've recently been put in charge of a SQL 7 server. I had a little experience managing databases, but i've never had to connect to a database from a client.

My question is: How does a user connect to a SQL database to input data? Is there a SQL client software that I'm not seeing, or can you connect thru Access.. and how..

thanks.

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL - This should be an easy one!

by aalladin In reply to SQL - This should be an e ...

if they are going to connect directly to the database and input data using SQL Server they can either log in using query analyzer which is part of the SQL Server 7.0 package or Enterprise Manager....you will have to map to the server where the database is on

Collapse -

SQL - This should be an easy one!

by Corky132 In reply to SQL - This should be an e ...
Collapse -

SQL - This should be an easy one!

by SamFelis In reply to SQL - This should be an e ...

You can use the QA tool w/i Enterprise Manager or install the SQL client on the users' desktop. Make sure the client has the proper networking protocol configured successfully. 9/10 times you'll have the SQL client installed on the workstation. Don't know why you'd want to access via Access.

Collapse -

SQL - This should be an easy one!

by Corky132 In reply to SQL - This should be an e ...
Collapse -

SQL - This should be an easy one!

by mightyduk In reply to SQL - This should be an e ...

The question is, do you really want a "user" connecting unfettered to your database? It may be appropriate to create a front end package which provides the required functionality, while restricting dangerous operations. Visual Basic, Access, Java and even C++ can make front ends for SQL, but I would say that PowerBuilder makes the most powerful database front ends, and will connect with SQL server, as well as just about anything else. The actual connection process is through a connect stringwhich is specific to the database.

Collapse -

SQL - This should be an easy one!

by Corky132 In reply to SQL - This should be an e ...
Collapse -

SQL - This should be an easy one!

by mightyduk In reply to SQL - This should be an e ...

The question is, do you really want a "user" connecting unfettered to your database? It may be appropriate to create a front end package which provides the required functionality, while restricting dangerous operations. Visual Basic, Access, Java and even C++ can make front ends for SQL, but I would say that PowerBuilder makes the most powerful database front ends, and will connect with SQL server, as well as just about anything else. The actual connection process is through a connect stringwhich is specific to the database.

Collapse -

SQL - This should be an easy one!

by Corky132 In reply to SQL - This should be an e ...
Collapse -

SQL - This should be an easy one!

by McKayTech In reply to SQL - This should be an e ...

SQL Server is part of a client-server system. The client is almost always a custom piece of software (an application) that runs on the desktop and provides the user interface so the fine points of communicating with the SQL database are hidden from the user. This might be an accounting program, an ERP program or something else. Between the desktop application and the server is usually a piece of software called an ODBC driver.

There are administrative tools that allow direct access to the database, but they are for administrative maintenance rather than routine day-to-day use because it is very easy to hose a database with them.

You can link to SQL tables through Access; again through the piece of software called the ODBC driver.
paul

Collapse -

SQL - This should be an easy one!

by Corky132 In reply to SQL - This should be an e ...
Back to Web Development Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums