After renting ali cloud server, install SQL2008 and new database
"XXX", for example: database table: "cs" database login account: "sa" password: "123456" IP: "113.56.104.66
"
Question:
1. How to query the ali cloud server database table data "CS"?
2. How to submit the local data to the cloud database table "cs"?

In addition to remote connect to the database directly: are there any other method? More article data remote connect to the database I afraid of data directly,
My idea is to do a middleware (interactive data, similar to the interface), vb + asp vb docking asp, asp and database interaction data, this method is reasonable? If reasonable how should do?

CodePudding user response:

You have encountered off data?

CodePudding user response:

No problem, are generally buy site space database, why are you buying?

CodePudding user response:

Just see, ECS is you buy? So, on the top of a web application server directly, used to receive data; User interaction by client or web browser, which is a more classic, remote direct database is a little dangerous,

CodePudding user response:

The

reference 3 floor Runnerchin response:

just understand this, ECS is you buy? So, on the top of a web application server directly, used to receive data; User interaction by client or web browser, which is a more classic, remote direct database is a little dangerous,

Yes I buy is ECS server, I just want to use the WEB application interface interaction, could you tell me how to do this?

CodePudding user response:

Ado support ms SQL server directly connected
Connection and local operation. MDB database about

Arrangement on the server side if ms SQL + asp, that your client is an asp exchange data, ie the client use?

CodePudding user response:

reference 5 floor spt_petrolor reply:

ado support ms SQL server directly connected
Connection and local operation. MDB database about

Arrangement on the server side if ms SQL + asp, that your client is an asp exchange data, ie the client use?

The client program is for customers to use, providing server account directly to customers don't feel safe, I want to use the form of the interface, such as: interface protocol HTTP interface

CodePudding user response:

User name and password is a string in the client program, edit the constant string, if the customer are in danger of leakage

Don't break your client, the constant string will not be the customer see

With asp safer, directly with vs do web development, database service port can be closed, the client browser, you need to consider different browsers

CodePudding user response:

Generally has three, two practical summary, 1) is linear, and c/s architecture, the code is written in the local, the password is stored in the local application, and, in addition to the company the government enterprises do their internal use, and sell pure software is not recommended, so, another can also be called cs, is on the server to write a program that every time the client requests using winsock send an instruction in the past, there query, return to send the data to come over, so that the actual or transport problems
2. B/s architecture, the server side to write a web page background asp, PHP vb generally asp, and then becomes easy, as long as the client side every time the get post things came,,,,,,,,

CodePudding user response:

Direct easy to break, the speed is too slow,
Can improve the speed by modifying adocon connection string, dozens of times,
http://blog.csdn.net/pcwe2002/article/details/52000119

CodePudding user response:

references 9 f pcwe2002 response:

direct easy to break, the speed is too slow,
Can improve the speed by modifying adocon connection string, dozens of times,
http://blog.csdn.net/pcwe2002/article/details/52000119

CodePudding user response:

On the server using asp access database data, can display on the page, as requested format according to their own situation, and then use the webbrowser control in vb, call the asp, there is no problem of the remote connection, the connection on the aps, the connection is successful in aps, returns to the vb according to this train of thought to hold more convenient service data

CodePudding user response:

Or reference innet, manual operation the data returned from the server, and with the data, then you want to how how