[freetds] Linux request to MS SQL many incidents?

Atkinson.Keith Keith.Atkinson at IGT.com
Thu Feb 2 14:34:41 EST 2006


I would like to thank all for responding to my question, no matter how vague. Secondly, I would like to apologize for being so vague, this is my first time to present a question.

That being said, I believe you have answered my question with the \\ VS \

To be more precise, I'm trying to query MS_SQL 2000 that has several incidents (complete databases setups for testing on the same phyiscal box, and with the same IP, and port) so, normally in the freetds.conf or interface you would setup the structure as shown below:

        demoacctv
        query tcp 4.2 172.19.5.18 1433

Mulitple incidents:
                  demoacctv\acct2
                  query tcp 4.2 172.19.5.18 1433

                  demoacctv\acct3
                  query tcp 4.2 172.19.5.18 1433

                  demoacctv\acct4
                  query tcp 4.2 172.19.5.18 1433

etc...

Unix or Linux does not work with a backslash the same way as a 
Windows environment, Linux just ignores the backslash. So, with the 
information you have provided previously, would I setup the interface file
as shown below?

                  demoacctv\\acct4
                  query tcp 4.2 172.19.5.18 1433


Keith W. Atkinson
IGT Systems



-----Original Message-----
From: freetds-bounces at lists.ibiblio.org on behalf of Robert Klemme
Sent: Thu 2/2/2006 00:49
To: FreeTDS Development Group
Subject: Re: [freetds] Linux request to MS SQL many incidents?
 
2006/2/2, Atkinson.Keith <Keith.Atkinson at igt.com>:
> I have a simple question, I think?
>
> Linux server using freetds to query a MS SQL server
> Example: MS_SQLNameServer
>                 NameDB1
>                 NameDB2
>
> MS_SQL works MS_SQLNameServer\NameDB2
> Unix or Linux does not work with a backslash the same way.
>
> What is the string to make the connection for the 2nd DB?

I agree with others that your question is very vague.  But maybe it's
just an escaping issue, i.e. you have to use \\ instead of \ on the
command line because of shell interpretation.

robert


--
Have a look: http://www.flickr.com/photos/fussel-foto/
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3634 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20060202/c9bbe43f/attachment.bin


More information about the FreeTDS mailing list