| Dart Home | PowerTCP FTP for ActiveX | Custom Development | Reply | PowerTCP FTP for ActiveX Topics | Forums |
| Author | Forum: PowerTCP FTP for ActiveX Topic: FTP tool and SQL Server Scripts |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 1, 2001 2:28 PM What is the syntax of using your tool inside of a stored procedure of using a SQL Server script? I could not find anywhere within your documentation how to access this ActiveX tool within SQL Server. Thanks in advance for your reply.. |
Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 1, 2001 2:33 PM I'm not familiar with SQL server, but I assume that it allows some way to insert an ActiveX control. Tony Priest Dart Tech Support |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 1, 2001 2:53 PM Do you have an example of the use of your tool as an ActiveX item? I just wish to use it in a stored procedure trigger.... Thanks, James |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 1, 2001 4:16 PM Yes, any of the VB sample would probably help. |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 4, 2001 10:05 AM Where would I find such an example that refers to the aforementioned process? I looked and could not find it. Thanks, James. |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 4, 2001 10:11 AM I didn't mean to imply that I had a sample of using the product with SQL server. I was stating that the examples that would most likely help you the most would be the VB examples. Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 6, 2001 8:55 AM Thanks for the response, Tony. Tell me, would Power FTP be able to execute a script that is in a SQL table? I inserted lines of code into #FTP_Script(A SQL code example follows.) Create table #FTP_Script( script_line varchar(255) not null) Create table #FTP_Result( result_line varchar(255) null) Insert #FTP_Script values('anonymous') Insert #FTP_Script values('none') Insert #FTP_Script values('PUT ' + '@FTPSOURCE' + ' ' + 'ftp://PLUTO/test.txt' ) Insert #FTP_Script values('quit') Insert #ftp_result( result_line) exec ftp -s:#ftp_script -- either of these 2 exec statements? exec master..xp_cmdshell 'ftp -s:#ftp_script URANUS ' --select * from #ftp_result --select * from #ftp_script DROP table #ftp_script DROP table #ftp_result |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 6, 2001 9:33 AM You would not be able to "execute" the script using our FTP control, but you should be able to perform the same actions using the methods that are available to the control. Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 6, 2001 9:55 AM Tony, could you give me an idea of what you are referring to by methods available to the control? I am at a TOTAL loss as to what you are referring. Thanks. James. p.s. Could you tell me why the aforementioned script would not work? |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 6, 2001 10:31 AM I was referring to the methods of the FTP control. You would use the FTP control to accomplish what you do with the script. The FTP Tool would replace the script, NOT use it. The aforementioned script "would not work" because the FTP tool doesn't know what to do with it. Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 6, 2001 10:45 AM Now I understand about why the parameter usage in PowerFTP would not work. Thanks for the rapid response. You did not mean to imply that I could not use the control in a trigger or stored procedure did you? If possible, could you give me a mini-example as well? Thanks. |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 6, 2001 10:51 AM I'm not entirely sure what you mean, and therefore, do not have an example. Sorry, Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 6, 2001 3:57 PM The example that I was requesting but was not very specific was of the use of Power FTP and the use of it in a stored Procedure. Since I can not use a table with values within it to send to Power FTP, how would I get the User, PASSWORD, server parameters to PowerFTP within a stored procedure/ Thanks for your patience. James |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 6, 2001 4:21 PM What's a stored procedure? How do you do it with other objects? Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 6, 2001 4:25 PM I am sorry, I am not meaning to be ambiguous. I guess that normally PowerFTP is used within ASP or VB applications. A stored procedure is SQL code that can be called by a VB or ASP app. I imagine since you are unaware of stored procedures that PowerFTP does not support such? Maybe it is just terminology? Thanks, James. |
| Tony Priest From: Utica, NY USA Posts: 8466 Member Since: 04/11/00 |
posted June 6, 2001 4:35 PM I'm sorry I was not able to help. Tony |
| User705 Posts: 9 Member Since: 06/01/01 |
posted June 7, 2001 7:53 AM I am sorry, I am not meaning to be ambiguous. I guess that normally PowerFTP is used within ASP or VB applications. A stored procedure is SQL code that can be called by a VB or ASP app. I imagine since you are unaware of stored procedures that PowerFTP does not support such? Maybe it is just terminology? Thanks, James. |
| Reply | PowerTCP FTP for ActiveX Topics | Forums |
This site is powered by
PowerTCP WebServer for ActiveX
|