Select SQL Server Database Dialog
Select SQL Server Database Dialog
ChemPoint Professional data can be stored in Microsoft SQL Server Databases. Use this dialog to specify the server and connection parameters for the database.
ChemPoint Professional can store data in a single SQL Server database, or you can use multiple databases. ChemPoint Professional ships with empty Microsoft Access database, and has a built in capability to create new Access databases. However, this ability is not included for SQL server because of security issues. You must use a script to create an empty ChemPoint Professional database on SQL server. SQL server Scripts for creating empty ChemPoint Professional databases on SQL Server are included on the CD or can be downloaded from www.pointstar.com.
Data Source (server) -- This is the name of the server containing the Microsoft SQL Server database. If the database is local, you can enter the value "(local)" without the quotes.
Catalog (Database Name) -- This is the "catalog" name of the ChemPoint Professional database on the specified server.
User ID -- This is the user ID for login to the SQL Server database. This is not the ChemPoint Professional login. This value may not be necessary for your specific database.
Password -- This is the password for login to the SQL Server database. This is not the ChemPoint Professional password. This value may not be necessary for your specific database.
Database Type -- Select the database type string and parameters. This is the database connection string, however, database specific values are represented with field codes enclosed in "<<>>".
Provider=MSOLEDBSQL;Server=<<DataSource>>;Database=<<Catalog>>; Trusted_Connection=yes;
Provider=MSOLEDBSQL;Server=<<DataSource>>;Database=<<Catalog>>; Trusted_Connection=yes;User ID=<<UserID>>;Password=<<Password>>;
Connection String:
This is the connection string for the connection to the ChemPoint Professional database. The database connection string will be assembled from the database type string specified above. Field codes will be replaced with the specified values.
For connection to a Microsoft SQL Server database on the local machine, with the catalog name "database_name_2", and no user ID or password, you would use the following connection string:
Provider=sqloledb;Data Source=(local);Initial Catalog=database_name2; User ID=;Password=;Integrated Security=SSPI