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 29-Dec-2020 05:25 Ben Spink
png
url.png 17.2 kB 2 29-Dec-2020 05:25 Ben Spink

This page (revision-17) was last changed on 17-Nov-2023 16:11 by Ada Csaba

This page was created on 29-Dec-2020 05:25 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

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 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.
__IMPORTANT: due to the security updates since CrushFTP version 10.5.2+ any JDBC driver jar file needs to be placed into the CrushFTP10/plugins/lib/ directory, or it won't load.__
At line 3 changed one line
[attachments|driver_file.png]
\\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: [https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16]\\
\\
|db_driver_file|mssql-jdbc-12.4.0.jre11.jar\\
|db_driver|com.microsoft.sqlserver.jdbc.SQLServerDriver\\
|db_url|jdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp\\
At line 5 changed 9 lines
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|driver.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 18 added 2 lines
At line 20 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 24 removed 3 lines
At line 29 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 34 removed 2 lines
At line 38 changed one line
inherit_username varchar(255) default NULL,
inherit_username varchar(8000) default NULL,
server_group varchar(8000) default NULL,
At line 42 removed 2 lines
At line 46 changed one line
start_ip varchar(255) default NULL,
start_ip varchar(8000) default NULL,
At line 48 changed one line
stop_ip varchar(255) default NULL,
stop_ip varchar(8000) default NULL,
At line 52 removed 3 lines
At line 57 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 61 removed 3 lines
At line 66 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 70 changed one line
)
)
At line 72 removed 2 lines
At line 76 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 82 removed 2 lines
At line 86 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 90 removed 3 lines
At line 95 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 100 removed 2 lines
At line 104 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 109 removed 3 lines
At line 113 changed one line
groupname varchar(255) default NULL,
groupname varchar(8000) default NULL,
At line 115 changed one line
server_group varchar(50) default NULL
server_group varchar(8000) default NULL
At line 99 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 105 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 121 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
)
Version Date Modified Size Author Changes ... Change note
17 17-Nov-2023 16:11 3.316 kB Ada Csaba to previous
16 17-Nov-2023 16:11 3.319 kB Ada Csaba to previous | to last
15 17-Nov-2023 16:10 3.315 kB Ada Csaba to previous | to last
14 18-Aug-2023 08:27 3.131 kB Ben Spink to previous | to last
13 29-Dec-2020 05:25 3.073 kB Ada Csaba to previous | to last
12 29-Dec-2020 05:25 3.077 kB Ada Csaba to previous | to last
11 29-Dec-2020 05:25 3.101 kB Ben Spink to previous | to last
10 29-Dec-2020 05:25 3.027 kB Ben Spink to previous | to last
9 29-Dec-2020 05:25 2.844 kB Ben Spink to previous | to last
8 29-Dec-2020 05:25 2.762 kB Ben Spink to previous | to last
7 29-Dec-2020 05:25 2.603 kB Ben Spink to previous | to last
6 29-Dec-2020 05:25 2.794 kB Ben Spink to previous | to last
5 29-Dec-2020 05:25 3.455 kB Ben Spink to previous | to last
4 29-Dec-2020 05:25 2.956 kB Ben Spink to previous | to last
3 29-Dec-2020 05:25 2.868 kB Ben Spink to previous | to last
2 29-Dec-2020 05:25 2.867 kB Ben Spink to previous | to last
1 29-Dec-2020 05:25 2.849 kB Ben Spink to last
« This page (revision-17) was last changed on 17-Nov-2023 16:11 by Ada Csaba
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
LeftMenu

JSPWiki