[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