|
Versions SQL-Server: 7.0, 2000, 2005, 2008
Download your installation kit:
SQL_SERVER.ZIP
Server installation
- Create a new database
- Create tables and Insert in database:
Script_SQL_GB_404.sql
- Create the user who has access to database
SQL-Server 7.0 : replace COLLATE and French_CI_AS by
an empty string
Client installation
Execute the file .reg that suits your SQL installation type (SQL or Windows Authentification):
--> If you server uses a SQL authentification:
AUTHENTIFICATION SQL_32bits.REG or AUTHENTIFICATION
SQL_64bits.REG
Then, modify the string "Base" in the registry and precise the name or IP address of your server, the name of your database, the user and password.
"Provider=sqloledb;Data Source=Name of the server or IP address;Initial Catalog=name of the SQL database;User Id=SQL user;Password=Password of the SQL user"
--> If your SQL Server use the Windows authentification:
SSPI_32bits.REG or SSPI_64bits.REG
Then, modify the string "Base" in the registry and precise the name or IP address of your server, the name of your database
"Provider=sqloledb;Data Source= Name of the server or IP address;Initial Catalog= Name of the database;Integrated
Security=SSPI"
--> If your database is installed in english, you must execute:
US_32bits.REG or US_64bits.REG
|
