Does anyone know how to create an FTP task in DTS (MSSQL2000) and specify which directory to download from? Everywhere I have looked I have been unable to find any documentation that shows how to change directories.
Zach Bowling Sr. Manager of Customer Analytics Work: 480.902.5908 Mobile: 602.391.5454 Email: [EMAIL PROTECTED] http://www.direct-alliance.com -----Original Message----- From: Robert Berndt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:27 PM To: SQL Subject: RE: instances of SQL ( 7.0 and 2000 ) running with MX Well, I don't know if this will help you or not, but in JSP, JDBC Urls usually begin with "jdbc:subprotocol:subname" the sample connection to an Oracle database would be: connection = DriverManager.getConnection("jdbc:oracle:thin:dbhost:1548:ORCL", "user", "password"); Hope this helps... Robert Berndt -----Original Message----- From: Phillip B. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:44 PM To: SQL Subject: instances of SQL ( 7.0 and 2000 ) running with MX We have multiple instances of SQL ( 7.0 and 2000 ) running with MX and can no longer connect to the secondary 2000 instance. In CF 5.0 I simply put the instance name on the end of the IP as follows: 216.203.150.522\sql2k Since MX is JDBC, this no longer works. Any suggestions? Respectfully, <cf_developer> Phillip B. Holmes Media Resolutions Inc. Macromedia Alliance Partner http://www.mediares.com [EMAIL PROTECTED] 1-888-395-4678 ext. 101 972-889-0201 ext. 101 </cf_developer> Please send support requests to [EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
