These screenshots should help as an example of what to enter. In this example, I put the driver files into a folder named "lib" that was up one directory from my CrushFTP program. You could also use absolute paths. Just separate multiple files with a semicolon.

This was the driver name to use for my example. Depending if its MS SQL 2000 or MS SQL 2005+ it may be different.

attachments

This is the URL format for my example. The URL format could be different if its MS SQL 2000 or MS SQL 2005+.

/* Script for MS SQL to make the DB tables needed for CrushFTP. */

CREATE TABLE DOMAIN_ROOT_LIST (
  userid int NOT NULL default '0',
  domain varchar(255) default NULL,
  path varchar(255) default NULL
)




CREATE TABLE EVENTS5 (
  userid int NOT NULL default '0',
  event_name varchar(255) NOT NULL default '',
  prop_name varchar(255) NOT NULL default '',
  prop_value text NOT NULL
)



CREATE TABLE INHERITANCE (
  userid int default NULL,
  inherit_username varchar(255) default NULL,
  sort_order int default NULL
)



CREATE TABLE IP_RESTRICTIONS (
  userid int NOT NULL default '0',
  start_ip varchar(255) default NULL,
  type varchar(1) default NULL,
  stop_ip varchar(255) default NULL,
  sort_order int default NULL
)




CREATE TABLE USER_PROPERTIES (
  userid int default NULL,
  prop_name varchar(255) default NULL,
  prop_value varchar(2000) default NULL
)




CREATE TABLE USERS (
  userid int NOT NULL IDENTITY (1, 1) NOT FOR REPLICATION,
  username varchar(255) default NULL,
  password varchar(255) default NULL,
  server_group varchar(50) default NULL,
  PRIMARY KEY  (userid)
) 



CREATE TABLE VFS (
  userid int default NULL,
  url varchar(255) default NULL,
  type varchar(50) default NULL,
  path varchar(255) default NULL,
  sort_order int default NULL
)



CREATE TABLE VFS_PERMISSIONS (
  userid int default NULL,
  path varchar(255) default NULL,
  privs varchar(255) default NULL
)




CREATE TABLE WEB_BUTTONS (
  userid int NOT NULL default '0',
  sql_field_key varchar(255) default NULL,
  sql_field_value varchar(255) default NULL,
  sort_order int default NULL
)



CREATE TABLE WEB_CUSTOMIZATIONS (
  userid int NOT NULL default '0',
  sql_field_key varchar(255) default NULL,
  sql_field_value varchar(255) default NULL,
  sort_order int default NULL
)




CREATE TABLE GROUPS (
  groupname varchar(255) default NULL,
  userid int default NULL,
  server_group varchar(50) default NULL
)




CREATE TABLE MODIFIED_TIMES (
  server_group varchar(50) default NULL,
  prop_name varchar(255) default NULL,
  prop_value varchar(255) default NULL
)