Art-Copy Scripting Advanced Functions: About DSN/ODBC Connections

Setting up a DSN/ODBC connection in Windows can be a bit tricky.

If you are only using a Microsoft Access database, this is not required for your configuration.

The first step you must take is installing your preferred Database Management System (DBMS). For this tutorial we will be using Microsoft SQL Server 2000. Many of the steps will be very similar for the other major database's (MySQL, Oracle, etc...).

NOTE: These are instructional steps detailing how to setup DSN/ODBC databases to handle transferred images. These steps may not work for every situation.

1.) After installing your DBMS and creating a database, be sure to create a table that has at least two columns: an ID field that is an autonumber and a field for the image (either binary data or a text field). Also be sure to create a user with proper rights to write to this database.

2.) Now open up your control panel and click on the Administrative Tools folder. Within that folder there is a "Data Source (ODBC)" option. Which will open this window:

3.) Click the Add button which will allow you to then select the driver for the database of your choice. For this example, we chose SQL Server. Which then displayed this screen:

4.) After hitting "Next", we were shown the screen below. Which we then changed to use the SQL Login and we entered our username and password required for this DSN.

5.) We then clicked Next through the rest of the dialog boxes. This then allows the user to send an image to our MS SQL database using Art-Copy Scripting Edition.

[Return to Contents]