| At line 1 changed one line |
| These screenshots should help as an example of what to enter. In this example, I put the driver files into my CrushFTP program folder. You could also use absolute paths. Just separate multiple files with a semicolon. |
| 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_file|sqljdbc.jar\\ |
| |db_driver|com.microsoft.sqlserver.jdbc.SQLServerDriver\\ |
| |db_url|jdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp\\ |
| At line 3 changed 7 lines |
| [attachments|driver_file.png] |
|
| This is the URL format for my example. The URL format could be different if its MS SQL 2000 or MS SQL 2005+. |
|
| [attachments|url.png] |
|
|
| \\ |
| Some documentation from MS on the driver usage: [http://msdn.microsoft.com/en-us/library/ms378428]\\ |
| \\ |
| At line 16 added 2 lines |
|
|
| At line 16 changed 2 lines |
| domain varchar(255) default NULL, |
| path varchar(255) default NULL |
| domain varchar(8000) default NULL, |
| path varchar(8000) default NULL, |
| sort_order int default NULL |
| At line 20 removed 3 lines |
|
|
|
| At line 25 changed 2 lines |
| event_name varchar(255) NOT NULL default '', |
| prop_name varchar(255) NOT NULL default '', |
| event_name varchar(8000) NOT NULL default '', |
| prop_name varchar(8000) NOT NULL default '', |
| At line 30 removed 2 lines |
|
|
| At line 34 changed one line |
| inherit_username varchar(255) default NULL, |
| inherit_username varchar(8000) default NULL, |
| server_group varchar(8000) default NULL, |
| At line 38 removed 2 lines |
|
|
| At line 42 changed one line |
| start_ip varchar(255) default NULL, |
| start_ip varchar(8000) default NULL, |
| At line 44 changed one line |
| stop_ip varchar(255) default NULL, |
| stop_ip varchar(8000) default NULL, |
| At line 48 removed 3 lines |
|
|
|
| At line 53 changed 2 lines |
| prop_name varchar(255) default NULL, |
| prop_value varchar(2000) default NULL |
| prop_name varchar(8000) default NULL, |
| prop_value varchar(MAX) default NULL |
| At line 57 removed 3 lines |
|
|
|
| At line 62 changed 3 lines |
| username varchar(255) default NULL, |
| password varchar(255) default NULL, |
| server_group varchar(50) default NULL, |
| username varchar(8000) default NULL, |
| password varchar(8000) default NULL, |
| server_group varchar(8000) default NULL, |
| At line 66 changed one line |
| ) |
| ) |
| At line 68 removed 2 lines |
|
|
| At line 72 changed 3 lines |
| url varchar(255) default NULL, |
| type varchar(50) default NULL, |
| path varchar(255) default NULL, |
| url varchar(8000) default NULL, |
| type varchar(8000) default NULL, |
| path varchar(8000) default NULL, |
| At line 78 removed 2 lines |
|
|
| At line 82 changed 2 lines |
| path varchar(255) default NULL, |
| privs varchar(255) default NULL |
| path varchar(8000) default NULL, |
| privs varchar(8000) default NULL |
| At line 86 removed 3 lines |
|
|
|
| At line 91 changed 2 lines |
| sql_field_key varchar(255) default NULL, |
| sql_field_value varchar(255) default NULL, |
| sql_field_key varchar(8000) default NULL, |
| sql_field_value varchar(8000) default NULL, |
| for_menu varchar(8000) default NULL, |
| for_context_menu varchar(8000) default NULL, |
| At line 96 removed 2 lines |
|
|
| At line 100 changed 2 lines |
| sql_field_key varchar(255) default NULL, |
| sql_field_value varchar(255) default NULL, |
| sql_field_key varchar(8000) default NULL, |
| sql_field_value varchar(MAX), |
| At line 105 removed 3 lines |
|
|
|
| At line 109 changed one line |
| groupname varchar(255) default NULL, |
| groupname varchar(8000) default NULL, |
| At line 111 changed one line |
| server_group varchar(50) default NULL |
| server_group varchar(8000) default NULL |
| At line 97 added 5 lines |
| CREATE TABLE MODIFIED_TIMES ( |
| server_group varchar(8000) default NULL, |
| prop_name varchar(8000) default NULL, |
| prop_value varchar(8000) default NULL |
| ) |
| At line 103 added 6 lines |
| CREATE TABLE VFS_PROPERTIES ( |
| userid int default NULL, |
| path varchar(8000) default NULL, |
| prop_name varchar(8000) default NULL, |
| prop_value varchar(8000) default NULL |
| ) |
| At line 117 removed 5 lines |
| CREATE TABLE MODIFIED_TIMES ( |
| server_group varchar(50) default NULL, |
| prop_name varchar(255) default NULL, |
| prop_value varchar(255) default NULL |
| ) |