Ask for a translation of a foreign language document ~

(Note: this interface supports MSSQL and Access or any other relational database, and there are 1- 16 port versions to choose from. )

(This interface is a green installation-free version, which is more convenient for development and redistribution. )

(1) database interface function:

Through this database interface, your existing systems (such as OA, CRM, ERP, etc. ) You can easily realize the wireless office function. No matter which development language (VB \ VC \ VFP \ ASP \ JSP \ Java \ Pb \ Delphi ...) is used, as long as your system can read MS SQL 2000 or access the database, it can be docked! You only need to add records in the specified table, and this interface program will automatically send and receive. You don't need to know any knowledge of data communication to realize the sending and receiving function of mobile phone short messages!

The "0" code can increase the function of sending and receiving short messages in your current system!

(2) Use steps:

Step 1: Connect the mobile phone, SMS cat (or other SMS devices) to the computer correctly.

Step 2: Start "Sms_Server.exe". In practical application, this interface program can be automatically run and minimized when it is started (see Settings).

Step 3: Set the port parameters correctly and click the "Start Connection" button (this step can also be set to be automatic, see Settings).

Step 4: Send and receive SMS messages in your original system through the database data.mdb (or the table in SQL) under the running program directory. For example, if you send a short message, the system will send it automatically as long as you add a record in the outbox table of data.mdb (see below for details).

Simply put, it is two steps, namely: ① run Sms_Server.exe > ② send and receive short messages by operating the database.

(See below for details)

Description: a. If you use Aceess database, the default value is data.mdb in the installation directory.

B if MS SQL database is used, please restore the database file SmsData.bak in the installation directory and modify the value of "database" in the collection. The INI file in the installation directory.

Of course, you can also add corresponding tables in any other database according to our database structure, and then modify the database values of the collection. INI file for connection!

(2) Brief description of interface functions:

The interface is provided in the form of a database. There is a database file data.mdb in the installation directory of the interface, which contains five main tables, which are described as follows:

(a), outbox table send short message list (just insert a record in this table, you can realize the sending of short messages)

[Mbno] Target mobile phone number, string, such as: 13632263389, 186 1 etc.

[Msg] SMS content, character string, maximum 1000 Chinese characters, with automatic segmentation function.

[sending time] The scheduled sending time and date type, such as: 2005-8-1921:31:1.

[Report] Whether to send a report is a numerical type. When the report = 1, the report is required; when the report =0, the report is not required.

[ComPort] Port number, numeric type, set the port number used to send this message. If it is 0 (or left blank), it is an automatic port number.

[User Name] Field reserved for extension.

[V 1 ]-[ V5] Reserved fields for extension.

(2) The inbox table lists the received messages (the content of the received messages will be automatically saved in this table).

[Mbno] The mobile phone number of the letter

[Msg] Content of received SMS

[ArriveTime] The time when the message was received.

[Comport] The sequence number of the received message.

(3), SendedOutBox table list of sent messages

[Mbno] sent mobile phone number

[Msg] the content of the sent SMS.

[Send Time] The time of sending.

[Comport] The serial number used to send this short message.

[username] A reserved field for expansion, corresponding to the Outbox table.

[V 1 ]-[ V5] Reserved fields for extension, corresponding to Outbox table.

(4) Badoutbox table failed to send short message list.

[Mbno] Failed to send mobile phone number.

[Msg] Failed to send SMS content.

[Send Time] The time when sending failed.

[Bad_why] Reason for sending failure

[username] A reserved field for expansion, corresponding to the Outbox table.

[V 1 ]-[ V5] Reserved fields for extension, corresponding to Outbox table.

(5) Report table Send report list (when the report in the Outbox table is 1, send report will be generated).

[RpMsg] Contents of the report

[transmission time] information transmission time

[ArrivedTime] The response time received (or not received) by the other party.

[Related Operations]

Customers can send and receive information by operating the database, such as:

A. For example, if you want to send a message, you only need to write a record in the Outbox table (including Msg- "content", Mbno- "mobile phone number" and SendTime- "planned sending time", among which the required items are Msg and Mbno). After adding the record, this interface will send the mobile phone message at the specified time (if sendtime is not filled in, it defaults to the current time, that is, send it immediately).

B, if you want to receive information, just read the records in the inbox table (the system will automatically receive new information and save it in the inbox table).

C if the contents in the outgoing list (outbox table) are successfully sent, they will be transferred to the Sendedoutbox table; If the sending is unsuccessful, it will be passed to the Badoutbox table, and the reason for the sending failure will be automatically recorded!

[Related Settings]

A, the interface program can be set to start automatically at startup and minimize automatically.

B, you can set the working mode of the interface program.

C, can automatically save the running record of sending and receiving short messages.

New features of V 4.0:

Unattended mode description

Unattended means that you can connect multiple SMS cats at the same time (for example, 8), but only some of them (for example, 2) are enabled at first. When two SMS cats fail to send to the designated number (for example, 20) continuously due to arrears or other reasons, the other SMS cats will automatically start sending, thus realizing unattended operation in a certain sense!

Explanation about the limited number of sending ports.

For each port, you can set the maximum amount of short messages allowed by the port. When it exceeds this amount, it will automatically stop sending the port.

What's new in V 5.0

1, using new threading technology, on the premise of ensuring the stability and speed of sending, it reduces the occupation of system resources. Generally, CPU only accounts for about 3% when sending short messages.

Translation: SMS cat VB SQL

(Note: this interface supports MSSQL and Access or any other relational database, with the option of 1- 16 port version).

(This is green, which makes it easier to install and publish for free.)

(1) database interface function:

Through this database interface, your existing systems (such as OA system, CRM, ERP) can easily realize wireless office functions, no matter what language you use (VB \ VC development \ \ \ \ JSP VFP asp pb, Delphi Java \ ...). The system can, as long as you read MS SQL 2000 or Access database, you can dock it! You only need to add a record in the specified table, and the program will automatically send the interface and receive it, so you don't need to know anything about data communication, so you can realize the functions of sending short messages!

The "0" code can add system functions to the short message you are sending now.

(2) Use steps:

Step 1: Connect the mobile phone, SMS cat (or other devices) to the computer correctly.

Step 2: Start ","Sms_Server exe. In practical application, the program interface allows the boot to run automatically and minimize (see).

Step 3: After the settings are correct, click the "Start Port Parameter Connection" button (this step is set to automatic, so you can check the settings).

Step 4: Get data from the program's directory database in your original system. The table (or SQL MDB) receives short messages, for example, sending short messages. Only the data in the table is added to the MDB outbox, and the system will automatically send them (see the figure below).

To put it simply, this is divided into two steps: (1)>2) Sms_Server runs through operation exe. Send message database

(See below)

Description: A. If Aceess database is used, the directory data will be installed by default. When is MDB

B if MS SQL database is used, please restore the database files in the installation directory and modify SmsData bak. Database under the installation directory "settings. The INI file may be valuable.

Of course, you can also add corresponding modified database files in any other database table according to our database structure. Set the connection!

(2) Brief description of interface functions:

This interface is provided in the form of a database, and the installation directory interface has a database file data and five .mdb.main tables, which are detailed as follows:

(1) Prepare a short message list for the form in the outbox (just insert the form to send short messages).

[Mbno] Target mobile phone number, string, such as: 13632263389, 186 1 etc.

[text], Msg, top 1 0,000 string with automatic segmentation function.

[sending time] the planned sending time and date type, such as: 2005-8-1921:31:1

[About] Whether to send a report, numerical type, about 1 = = 0, the report about this report should be reported.

[ComPort] socket, number, set this information to be sent by using the port, and 0 (or not) is used to automatically fill the slogan.

[Narrator], the user name is for extended use. field

[[V5]]-V 1 is set as field extension.

(2), the received message inbox observation list (the received message will be saved here),

[Mbno letter] mobile phone number

[Msg] received message

[Arrival time] message has been received.

[Comport] received the message of this serial number.

(3) SendedOutBox table list of sent messages

Do you have a cell phone number

The message content has been

[sending time] sending time

The part that sent this message] [Serial number

[Narrator], user name field, corresponding to extended use outbox.

[[V5]]-V 1 is set to expand, which corresponds to the outbox.

(4) Sending SMS Badoutbox table failed.

[Mbno] Failed to send mobile phone number.

Message sending failed.

[sending time] sending failure time

[Bad_why] sending failed.

[Narrator], user name field, corresponding to extended use outbox.

[[V5]]-V 1 is set to expand, which corresponds to the outbox.

(5) Observation table (report table) When the outbox is about = 1, a sending report will be generated.

[RpMsg] Contents of the report

[a]]。 Sending time information

[ArrivedTime] The time when the person received (or did not receive) the reply.

[Related Operations]

Customers can receive information through the database, such as operations:

A, if you want to send information, just write a record (including Msg-"content", Mbno-"mobile phone number" and SendTime-"planned sending time", in which Mbno should be added) in the outbox table, and the interface will send the information to SendTime at the specified time (if it is not filled in, it will default to the current time and send it), that is.

B, if you want to collect information, you can check the reading records in the inbox (the system will automatically receive new information and save it in the viewing inbox.

C. If the contents in the ready list are successfully transferred out, send the OutBox list; if not, automatically transfer to the Badoutbox list and record the reasons for sending failure!

[Related Settings]

First, an interface program can be installed, which is used for automatic startup and automatic minimization.

B, the program can set the interface working mode.

C, can automatically save the text receiving operation record.

V: New function 4.0

About the explanation of unattended.

The so-called unattended, that is, you can connect to multiple short messages (8 messages) like a cat, but only the first part (such as 2 messages). When two short messages cats can't send a number (such as 20 messages) because of arrears or other reasons, they automatically start sending short messages to other cats, which is a feeling of unattended!

The limited number of transmissions of this port.

For each port, you can set the maximum allowable port, and when it exceeds the number of messages sent, the number of ports will be automatically stopped.

New features of V 5.0

1 adopts new technology. In order to ensure the stability and speed of thread sending, under the premise of reducing system resources, the general text is only about 3% of CPU utilization.