I how to operate on the server, to oneself can use the SQL server, and other machines cannot connect to the server (including LAN and remote network), I am using PB, write such statements are convenient in PB?

CodePudding user response:

1. The preferred scheme real change to the client program, start the client, to determine the IP, only can continue to IP within the prescribed scope, or withdraw from the system.
2. If you are not convenient to change the client program, then write a small program on the server, the program starts, circulation judge login user, kill this server program, database connection process.
Of course, when you connect to the database on the server, in the sqlca. Dbparm add login id.
Specific how to do and different databases, examine relevant documents.

CodePudding user response:

I just want to at a certain time (such as data backup) don't let other client connection, I was using a SQL server server, can you give me introduce some information on this, several search site I used, first, thanks

CodePudding user response:

Just want to at a certain time (such as data backup) don't let other client connection, it depends on how certain specific, automatic and manual?

CodePudding user response:

I hope it's automatic, such as data backup before, of course, you can just write with pb language,

CodePudding user response:

First what disdain in the advertising,
Secondly, I answered the question of good friend, you can by connecting to the server, then set operation user name and password, and then to his rights configuration changes and table can be used to call, ha ha, the connection string as follows:
//Profile sf,
The SQLCA. DBMS="MSS Microsoft SQL Server"
//driver name
The SQLCA. Database="data"
//the default table name
The SQLCA. LogPass=& lt; * * * & gt;
//the user password
The SQLCA. ServerName="C3DE912CFE21452"
//the above is the name of the server, also can be the IP address (realize remote connection)
The SQLCA. LogId="test"
//user name
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

Good luck to you, the hope can help you a little, want to make friends with me!!!!!!!
_____________Jacky_Dai QQ: 57768213

CodePudding user response:

As if it's not that simple, ha ha.