Vo2Ado Question
in [Visual Objects]
|
From: Carlo Russo on 30 Jun 2008 09:27 Can I execute with vo2Ado class a sql script? My scope is execute more INSERT command from a sql file. Thanks Carlo Russo
From: Robert van der Hulst on 30 Jun 2008 16:00 Hi Carlo, On Mon, 30 Jun 2008, at 06:27:46 [GMT -0700 (PDT)] (which was 15:27 where I live) you wrote about: 'Vo2Ado Question' > Can I execute with vo2Ado class a sql script? > My scope is execute more INSERT command from a sql file. Most servers do not allow that. I usually split the file in separate statements and execute each statement individually (with an optional transaction around all statements). -- Robert van der Hulst AKA Mr. Data Vo2Jet & Vo2Ado Support VO & Vulcan.NET Development Team www.heliks.nl
From: Geoff Schaller on 30 Jun 2008 18:18 Carlo, You can do this as long as the appropriate command line tools are installed for MS SQL server because MS SQL comes with a command line sql processor. However, it has to be allowed and set up in the config parameters. Works for 2005 and 2008. But. Is this wise. You can more easily do this with VO2Ado by executing the statements constructed at runtime using the AdoCommand class. Then you don't have to worry about how sql server was installed and what options were allowed. It is also something a DBA could turn off. Geoff "Carlo Russo" <russoc(a)tin.it> wrote in message news:2169d5c8-9e32-444c-b91a-63573060a891(a)m45g2000hsb.googlegroups.com: > Can I execute with vo2Ado class a sql script? > My scope is execute more INSERT command from a sql file. > > Thanks > > Carlo Russo
From: Carlo Russo on 2 Jul 2008 04:22 On 1 Lug, 00:18, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> wrote: > Carlo, > > You can do this as long as the appropriate command line tools are > installed for MS SQL server because MS SQL comes with a command line sql > processor. However, it has to be allowed and set up in the config > parameters. Works for 2005 and 2008. > > But. > > Is this wise. > > You can more easily do this with VO2Ado by executing the statements > constructed at runtime using the AdoCommand class. Then you don't have > to worry about how sql server was installed and what options were > allowed. It is also something a DBA could turn off. > > Geoff > > "Carlo Russo" <rus...(a)tin.it> wrote in message > > news:2169d5c8-9e32-444c-b91a-63573060a891(a)m45g2000hsb.googlegroups.com: > > > Can I execute with vo2Ado class a sql script? > > My scope is execute more INSERT command from a sql file. > > > Thanks > > > Carlo Russo > > Thanks, I resolved grouping multiple INSERT commands into a single transactions using the AdoCommand class Carlo Russo
|
Pages: 1 Prev: ReportPro: Trigger and Variables Next: MLE Cursor Position |