View Attach (2) Info

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 05-Dec-2023 05:32 Ben Spink
png
 url.png 17.2 kB 2 05-Dec-2023 05:32 Ben Spink

This page (revision-17) was last changed on 05-Dec-2023 05:32 by Ada Csaba

This page was created on 05-Dec-2023 05:32 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 05-Dec-2023 05:32 3.316 kB Ada Csaba to previous
16 05-Dec-2023 05:32 3.319 kB Ada Csaba to previous | to last
15 05-Dec-2023 05:32 3.315 kB Ada Csaba to previous | to last
14 05-Dec-2023 05:32 3.131 kB Ben Spink to previous | to last
13 05-Dec-2023 05:32 3.073 kB Ada Csaba to previous | to last
12 05-Dec-2023 05:32 3.077 kB Ada Csaba to previous | to last
11 05-Dec-2023 05:32 3.101 kB Ben Spink to previous | to last
10 05-Dec-2023 05:32 3.027 kB Ben Spink to previous | to last
9 05-Dec-2023 05:32 2.844 kB Ben Spink to previous | to last
8 05-Dec-2023 05:32 2.762 kB Ben Spink to previous | to last
7 05-Dec-2023 05:32 2.603 kB Ben Spink to previous | to last
6 05-Dec-2023 05:32 2.794 kB Ben Spink to previous | to last
5 05-Dec-2023 05:32 3.455 kB Ben Spink to previous | to last
4 05-Dec-2023 05:32 2.956 kB Ben Spink to previous | to last
3 05-Dec-2023 05:32 2.868 kB Ben Spink to previous | to last
2 05-Dec-2023 05:32 2.867 kB Ben Spink to previous | to last
1 05-Dec-2023 05:32 2.849 kB Ben Spink to last
« This page (revision-17) was last changed on 05-Dec-2023 05:32 by Ada Csaba
G’day (anonymous guest)
CrushFTP11 | What's New

Referenced by
LeftMenu

JSPWiki