How to make the software use sql server 2000?

Featured Products

NF-M86 Exit Push Button with Back Box

NF-M86B Plastic Exit Button

NF-C6 Surface Mounted Infrared Touchless exit button

NF-M55 Exit Button with Back Box

RRO-RF1 Mifare&ID Access Reader

NE-280S(Magnetic lock 600Lbs)

NS-L1 Single-door Access Control Board(with Webserver)

Home > FAQ > How to make the software use sql server 2000?

How to make the software use sql server 2000?

2015-08-14

If you want your softwareuse SQL database ,you need to install the SQL server 2000 first.The defaultdatabase is access.
......................................................................................................................................................................
Step 1: Install SQL server 2000.
a. put the CD into CD-ROM.
b. Click SQL server 2000 components , then next ,

c. Keep clicking next until appearing followinterface, choose use the local system account ,then click next

d. Choosemixed mode ,you can set the SQL password ,or set empty password.

e. Thenkeep clicking next until installation..finished.
......................................................................................................................................................................
Step 2: run service manager

Then Click start and select

.......................................................................................................................................................................
Step 3:Set the software use SQL database

a. openthe software directory , (default C:iCCard)
find sqlServerConfig.exe ,

then run it.
b. ChoseSQL server Authentication, if you have set the SQL password ,pls input it,otherwise keep empty.

c. Createnew database, then confirm.

Finnally open the software to check .if the heredisplay SQL ,

this means the software is using SQL database.
SQL server database sharing
Run the program “SQLServerConfig.exe” under thesoftware installation directory in your computer.

Then click new connection, select this one

Next,

Finally, click “ test connection” :

Now, SQL server database sharing successfully.
operation
The question is that software can be done by morethan one computer.And there is a solution through shared the folder.
...........................................................................................................................................................
please do as follows:
1、you needs two computer at least,one is server,another is clinet.theyalso have installed this software.
2、on the server ,please share the folders named iccard. the folders'sshare permissions must be written.
3、on the client,please connect the server database throughServer_Setting.exe which in the installation directory.
4、after the success of connection.please open the software to confirmthe information is as same as the server.if is the same,you can operate thesoftware by each computer.