Skip to Content.
Sympa Menu

freetds - Re: [freetds] Executing a huge sql script

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Executing a huge sql script
  • Date: Wed, 20 Nov 2013 08:46:23 +0000

Hi Chris,
did you read documentation? Probably what you are looking for is
http://www.freetds.org/userguide/name.lookup.htm and
http://www.freetds.org/userguide/portoverride.htm. Combined allow you
to use something like "localhost:1111" as your server name. For the
protocol version you have still to use default setting (probably if
you have only mssql 7.2 is not safe unless you have still some 2000).

As James noted our applications are mainly meant as test applications
or small scripts. For instance is quite hard to detect an error with
huge inserts like what you are trying to do. Probably tsql sent all
the query to the server but for some intermediate errors server did
not execute all your queries.

Frediano

2013/11/20 Chris Kings-Lynne <Chris.Kings-Lynne AT navitas.com>:
> I don't think you understand what Vagrant is Konrad...
>
> Anyway, I'll patch it soon as I have time
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Konrad Hambrick
> Sent: Wednesday, 20 November 2013 1:30 AM
> To: 'freetds AT lists.ibiblio.org'
> Subject: Re: [freetds] Executing a huge sql script
>
>
>
> Not to mention that each Developer can have a distinct $HOME/.freetds.conf
> file ...
>
> -- kjh
>
>> -----Original Message-----
>> From: freetds-bounces AT lists.ibiblio.org
>> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of David Chang
>> Sent: Monday, November 18, 2013 7:31 PM
>> To: freetds AT lists.ibiblio.org
>> Subject: Re: [freetds] Executing a huge sql script
>>
>> Chris,
>>
>> What configuration items are you trying to mix in the freetds.conf
>> file? Could you provide an example?
>>
>> I thought there were just three basic items you needed to connect to a
>> server:
>>
>> [SERVER_LABEL]
>> host = <hostname>
>> port = <TCP port>
>> tds version = <version number>
>>
>> In addition, the tds version can be put in the [global] section so you
>> don't have to specify it for every server. As for multiple users, so
>> long as you create a unique SERVER_LABEL and put all the configuration
>> in there, you are insulated from the the other servers as well as the
>> [global] section.
>>
>> DC
>>
>> On 11/18/2013 4:41 PM, Chris Kings-Lynne wrote:
>> > Using freetds.conf is horrible. It mixes together code-level
>> > configuration with system
>> root-level static files. It doesn't work when you have dozens of
>> developers sharing a single Vagrant environment definition, but
>> different SQL servers. It doesn't work when you are stamping out lots
>> of instances in the cloud, etc. I have resorted to using TDSPORT and
>> TDSHOST, but I'm not yet 100% sure of what exactly the scope of
>> setting the environment variable is, will it conflict with multiple
>> different database connections, all set to only connect on demand, etc.
>> >
>> > I'm firing up a dev linux VM now to look at adding host and port
>> > settings, which I'll
>> try to do over time. I also need to do my own build of freetds anyway
>> so my developers can actually have error messages in PHP as per my
>> first mail to this list :(
>> >
>> > Chris
>> >
>> > -----Original Message-----
>> > From: freetds-bounces AT lists.ibiblio.org
>> > [mailto:freetds-bounces AT lists.ibiblio.org] On
>> Behalf Of James K. Lowden
>> > Sent: Monday, 18 November 2013 1:18 PM
>> > To: freetds AT lists.ibiblio.org
>> > Subject: Re: [freetds] Executing a huge sql script
>> >
>> > On Sun, 17 Nov 2013 00:14:30 +0000
>> > Chris Kings-Lynne <Chris.Kings-Lynne AT navitas.com> wrote:
>> >
>> >> Are there any plans to add host and port CLI options to bsqldb?
>> >> It's a severe pain having to use service definitions :(
>> > Hmm? Why is it more difficult to specify hostname & port once in
>> > freetds.conf than it
>> is to specify every time on the command line?
>> >
>> > A little-known feature: if the argument to -S is not found in
>> > freetds.conf, it is passed
>> to DNS for resolution. On my system,
>> >
>> > $ grep willow ~/.freetds.conf
>> > $ TDSDUMPCONFIG=stdout bsqldb -S willow \ < /dev/null | sed -ne
>> > '/willow/p;
>> /Final/,/port/p'
>> > config.c:170:Getting connection information for [willow].
>> > config.c:468:Looking for section willow.
>> > config.c:288:[willow] not found.
>> > config.c:468:Looking for section willow.
>> > config.c:288:[willow] not found.
>> > config.c:1060:Looking for server willow....
>> > config.c:195:Failed to find [willow] in configuration files; trying
>> > 'SYBASE' instead.
>> > config.c:209:Final connection parameters:
>> > config.c:210: server_name = willow
>> > config.c:211: server_host_name = willow
>> > config.c:212: ip_addr = 192.168.5.17
>> > config.c:213: instance_name = MSSQLSERVER
>> > config.c:214: port = 1433
>> > bsqldb: Msg 20009, Level 9 (OS error 61: Connection refused)Unable
>> > to
>> > connect: Adaptive Server is unavailable or does not exist
>> >
>> > You can control the port with TDSPORT. Or, you know, it's open source.
>> >
>> > --jkl
>> >
>> >> -----Original Message-----
>> >> From: freetds-bounces AT lists.ibiblio.org
>> >> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K.
>> >> Lowden Sent: Saturday, 16 November 2013 11:13 PM To:
>> >> freetds AT lists.ibiblio.org Subject: Re: [freetds] Executing a huge
>> >> sql script
>> >>
>> >> On Wed, 13 Nov 2013 01:19:45 +0000
>> >> Chris Kings-Lynne <Chris.Kings-Lynne AT navitas.com> wrote:
>> >>
>> >>> I'm trying to execute a huge sql script via tsql and although it
>> >>> can execute from management studio, tsql just fails halfway though.
>> >>> There's no error, nothing. It just finishes its 10th set of 1000
>> >>> inserts (with GO between) and simply chooses not to continue on
>> >>> with the next lot, in the same file.
>> >> I don't recommend tsql for that purpose; that's not its intended use.
>> >> tsql is primarily a diagnostic tool for testing the tds library
>> >> independent of the client libraries. That's why it has a bunch of
>> >> weird options for bypassing the configuration files, for instance.
>> >>
>> >> I can't think of a reason offhand it would fail, though.
>> >>
>> >> I recommend bsqldb for non-interactive use. The 'b' stands for
>> >> "batch". bsqldb will definitely report any errors and messages
>> >> from the server, and will exit if a server message carries a
>> >> serverity > 10.
>> >>
>> >> If that doesn't solve your issue, you'll need a TDSDUMP log.
>> >>
>> >> HTH.
>> >>
>> >> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> --
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.http://www.mailguard.com.au/mg
> Click here to report this message as spam:
> https://login.mailguard.com.au/report/1IpFQgcTnJ/7k4ybtrYLjM2WxkYLlCKBr/0
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page