Web Development·12,141 discussions

SQL – This should be an easy one!

Locked

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.

Topic

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

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

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

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.

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

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.

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

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.

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

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

SQL – This should be an easy one!

In reply to SQL – This should be an easy one!

[Author]

Replies