answersLogoWhite

0

Maximum client for odbc connection

Updated: 12/19/2022
User Avatar

Wiki User

15y ago

Best Answer

Maximum client is the maximum number of requests that can be served by webserver at a time.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Maximum client for odbc connection
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

Is it possible to access databases through C-CPP and if so how?

Most database vendors offer an API for this purpose. The usage will vary by vendor, but generally you open a connection, query (or runcommand), check or step through results, close connection. In the MS Windows environment, you can also use ODBC (Open Database Connectivity), which is an API that abstracts (no, its not C++ classes) the database, its tables, and its query language. You still have to install a vendor specific ODBC driver, and a vendor specific database client, so you still need to consult the vendor documentation. The procedure is similar to the non ODBC solution - you open the connection, query it, step through the results cursor, and close the connection.


What is Client-Server Networking?

A server is a database--on a server. The client is: a person on a PC connected to the server via odbc querying the database. A database is only an app on the server. You can have a domain controller, a mail server, a nat server, web hosting... doesnt matter whats on it. And the client wouldn't really be person, a person is referred to as a user. A client is generally the computer. So what is client server networking? Its when you have perhaps 4 clients all using the server for something. The server kinda being like a master. But usually most clients will look to the server for their network settings (DHCP), and perhaps NAT etc..... But like the above person mentioned you can have database's on your server. But your not just limited to database's, you can have mail server's, web servers, app server etc....


Discuss the service primitives in a client server model?

A service is formally specified by a set of primitives or operations available to the user to access the service. These primitives tell the service to perform some action or report an action taken by the peer entity. The primitives for the connection oriented service are given in following table. Primitives Meaning Listen Block waiting for an incoming connection Connect Establish a connection with waiting peer Receive Block waiting for an incoming message Send Send a message to the peer Disconnect Terminate a connection Table: - Service primitives for a connection oriented service Communication in a simple client server model using the above service primitives is illustrated in figure [A]. First the server executes LISTEN to indicate that it is ready to accept incoming connections. The client executes CONNECT (1) to establish the connection with the server. The server now unblocks the listener and sends back an acknowledgement (2). Thus the connection is established. Figure [A]:- Simple client server model on a connection oriented network The next step for a server is to execute RECEIVE (3) to prepare to accept the first request. The arrival of the request packet unblocks the server so that it can process the request. After it has done the work it uses SEND (4) to answer to the client. After all the data transfer is done it can use DISCONNECT (5) for suspending the client. When the server gets this packet, it also issues a DISCONNECT (6) and when it reaches the client, the client process is releases and the connection is broken. In the process packets may get lost, timings may be wrong; many other complex issues may arise. The Relationship of Services to Protocols Figure [B]: Relationship between the service and protocols A service is a set of primitives that a layer provides to the layer above it. The service defines what operation the layer is prepared to perform on behalf of its users. It says nothing about the implementation of these operations. A protocol is a set of rules governing the format and meaning of the packets, or messages that are exchanged by the peer entities within a layer. Figure [B] illustrates the relationship of services to protocols. Entities use protocols to implement their service primitives. Protocols relate to the packets sent between entities.


How do you connect an ODBC link through C and C Plus Plus?

make sure to include the lib, to your space, or main, or however you are adding in your libs....define and instantiate an odbc object. use a command such as objectname.connect, wrap it up in a conditional. If you need it to loop for some real time like update needs...thats acceptable.


Explain the client-server model on the Internet In which layer of the TCPIP protocol suite is the model implemented?

The Client-Server ModelThe most common model for distributing a system is the client-server model. The model is fairly simple to explain and use.The name of the model is quite descriptive. In your distributed system you have one or more servers. These servers provide services to other parts of the system, called clients. When a server is started it first opens up a particular port through which clients can access it. It then sits down and waits until somebody (the client) attempts to connect to it. When that happens, the server and client exchange some messages and ultimately of the two close the connection. This connection takes place using so-called sockets.*The Server*The simplest version of such a server is non-threaded. That means that multiple connections are handled sequentially, in other words: clients have to queue up and they are handled one by one. That's fine if connections last only very short and if there are not too many clients connecting at the same time, however if you have many clients connecting at the same time or long-lasting connections you have to handle connections in parallel. You can handle multiple connections in parallel using threads. Each time a connection is established a new thread is created and the connection is handled by that new thread. The server thread then continues accepting new connections. Because creating threads is an expensive process (in terms of CPU cycles) threads are usually kept in a "pool". When a thread finished its job, it is kept alive until a new request has arrived it can handle.*The Client*For the client to connect it has to know the server's IP or hostname and the port to connect to. Once the connection is established the client and server can exchange messages. Depending on the distributed system a client may connect to multiple servers. One server to access the database, one for file services, another for e-mail, for example.RegardsDipaksiliguridipak_slg@rediffmail.com

Related questions

How do you do ODBC connection in Linux OS?

Employ the ODBC code or module written for whatever language you're writing in. Or, alternatively, write your own ODBC code.


What is an odbc connection?

ODBC stands for Open Data Base Connectivity. It is a connection that is created to define a connection between a computer and a database stored on another system. The ODBC connection contains information needed to allow a computer user to access the information stored in a database that is not local to that computer. You need to define the type of the database application - like Microsoft SQL or Oracle or FoxPro or mySQL. Once you have defined the type of database you need to select or supply the appropriate driver for a connection (Windows already contains many of these) and then supply the name of the database file and the credentials needed to access the database.Once the ODBC connection is created, you can tell specific programs to use that ODBC connection to access information in that database.


How do you connect to mysql using vb6?

Install the MyODBC database connector.Set up an new ODBC connection to your mysql database in Windows. (This will vary based on your version of Windows)You can use the ADODB extension in VB to connect to your ODBC connection.


Is it possible to access databases through C-CPP and if so how?

Most database vendors offer an API for this purpose. The usage will vary by vendor, but generally you open a connection, query (or runcommand), check or step through results, close connection. In the MS Windows environment, you can also use ODBC (Open Database Connectivity), which is an API that abstracts (no, its not C++ classes) the database, its tables, and its query language. You still have to install a vendor specific ODBC driver, and a vendor specific database client, so you still need to consult the vendor documentation. The procedure is similar to the non ODBC solution - you open the connection, query it, step through the results cursor, and close the connection.


Does Microsoft exchange server support ODBC connection with anything other than oracle and SQL?

yes because odbc stands for open data base connectivity and it support a lot of data bases. like mysql, ms-access, oracle, sql server etc.


Why must the server program be executed before the client program?

A server program must be executed before the client program because once a client is run, it will attempt to initiate a connection with the server. If the server is down, then the client will not be able to make a connection.


What layer of the osi model is odbc and sql?

ODBC and SQL operate at Session Layer.


What is ODBC in tally?

In tally ODBC is used to connect to other programs and exchange data dynamically


What can you do to fix this error the smtp server requires a secure connection or the client was not authenticated the sever Ever time you start this application it fails with this error.?

Obtasin a secure connection and or authenticate the client. How do i obtain a secure connection,and how do i authenticate?


What drivers are needed to setup a database with ODBC?

Alongside dedicated ODBC drivers, a JDCB driver is usually required. This enables a bridge to the ODBC driver, enabling the database to connect to its target.


Explain what is long polling?

Long polling is a web application development pattern used to emulate pushing data from the server to the client. When the long polling is used, the client sends a request to the server, and the connection remains intact until the server is ready to send data to the client. The connection will be closed only after the data is sent back to the client or connection timeout occurs.


How do I create a form which will then upload to a database that I can access in Microsoft Access?

Have your form's input insert into a database (SQL, Oracle, etc) then access that database through Access's ODBC connection.