44 users using DBSP now!
Home  I  Company  I  Services  I  Documentation  I  Downloads  I  E-Support
home -> documentation -> environment guide -> setting up a Microsoft SQL Server® connection

 

Prerequisites

The Microsoft SQL Server Client tools or MDAC must be installed in and properly configured before you can set a successful connection.


Configuring the connection

If you want to configure a new Microsoft SQL Server connection, follow these steps:

1. On the DBSP Configuration tool, select the DB Connections tab and press New.

2. On the name field type the name of the connection as how it will be referenced in the DBSP pages, for example: MSSQLEXAMPLE.

3. In the driver name list box, select MSSQL.

4. In the user name field, type a valid user for the database that you are trying to access. For the simplicity of the example, we will use the SA user.

Note: The user that you type in the User Name field will be the user that the DBSP Engine will use when the pages are interpreted. If this is the first time that you are connecting to the database, you will need a user with table creation privileges. Later on you can change these privileges according to your security necessities.
Note: If you want to use windows authentication mode, leave the username in blank. Consider also which user the web server will use for running the HTTP process. Be sure that this user has enough privileges over the database. How ever, a better approach is to use the SQL Server authentication (User-password combination).

5. Type the password in the Password field. In order to prevent errors, the password will be displayed. You will need to do this process only once per connection. If you are using Windows authentication mode, leave the password in blank.

6. Type in the Database field the name of the database, for example: NORTHWIND.

New Interbase connection and it's parameters

7. Type the in the Hostname field the name of the machine in which the database is located, in case that is not located in the current machine. If the database is located in the same machine you can use localhost or leave it in blank.

Advanced configuration settings for the Interbase connection

8. If you want to modify the advanced parameters of the connection, press the Advanced button.

9. When done, press the Ok button. The new connection appears on the connection list.

Testing your new connection.

10. Press the Test button in order to test that your connection is establishing correctly to the server.

 

Advanced parameters for SQL Server

LongStrings This boolean option when turned on allows dataset to represent long strings (more than 255 symbols) as memo.
Blobsize Indicates the maximum number or bytes retrieved by any blob field. If you want to set this size to unlimited, set this property to -1.

Previous | Next