These screenshots should help as an example of what to enter. In this example, I put the driver file into my CrushFTP program folder. You could also use absolute paths.
Driver download link: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

db_driver_filesqljdbc.jar
db_drivercom.microsoft.sqlserver.jdbc.SQLServerDriver
db_urljdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp


Some documentation from MS on the driver usage: http://msdn.microsoft.com/en-us/library/ms378428


/* 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,
  sort_order int 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,
  server_group varchar(50) 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,
  for_menu varchar(10) default NULL,
  for_context_menu varchar(10) 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
)


CREATE TABLE VFS_PROPERTIES (
  userid int default NULL,
  path varchar(1024) default NULL,
  prop_name varchar(255) default NULL,
  prop_value varchar(2000) default NULL
)

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
driver_file.png 21.2 kB 2 09-Oct-2016 18:14 Ben Spink
png
url.png 17.2 kB 2 09-Oct-2016 18:14 Ben Spink
« This page (revision-11) was last changed on 09-Oct-2016 18:14 by Ben Spink
G’day (anonymous guest)

Referenced by
LeftMenu

JSPWiki v2.8.2