Skip to Content.
Sympa Menu

freetds - [freetds] Fwd: Named Instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Patrick Corbett" <pcorbe81 AT maine.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Fwd: Named Instances
  • Date: Tue, 18 Dec 2007 15:38:40 -0700

No, you were clear, I believe I follow you. I'm using the server IP address
as well as the DNS for it with no luck. I also tried excluding the port
definition and leaving out the client charset, but that did not seem to make
a difference either - still getting that "unknown" error :( Is it possible
I'm using the wrong version of php_dblib.dll? I downloaded it from here:
http://kromann.info/download.php?strFolder=php5_2-Release_TS&strIndex=PHP5_2

Perhaps it is a TS/non-TS issue? Maybe I should try the non-TS php_dblib.dll
version...

Let me know what you think. Again, thanks for helping out - I'm really
excited to get this driver working.

freetds.conf
----
[abc\def]
host = 204.xxx.xx.xx (I've also tried abc.adomain.com, as well as our
internal 192.168.xx.xx address with no luck)
instance = def
;port = 1197
;client charset = UTF-8
tds version = 8.0
;text size = 20971520
dump file append = yes
dump file = C:\Inetpub\wwwroot\freetds.log
-----

and the error:

------
dblib.c:3593:dbsetlogintime(5)
dblib.c:3574:dbsettime(60)
dblib.c:413:dblogin(void)
dblib.c:4535:dberrhandle(024D1090)
dblib.c:4553:dbmsghandle(024D10E0)
dblib.c :459:dbsetlname(020486B8, xxxxx, 2)
dblib.c:459:dbsetlname(020486B8, xxxxx, 3)
dblib.c:459:dbsetlname(020486B8, PHP 5, 5)
dblib.c:812:dbopen(020486B8, abc\def, [microsoft])
dblib.c:268:dblib_get_tds_ctx(void)
config.c:166:Getting connection information for [abc\def].
config.c:170:Attempting to read conf files.
config.c:304:... $FREETDSCONF not set. Trying $FREETDS/etc.
config.c:317:... $FREETDS not set. Trying $HOME.
config.c:327:... Error getting ~/.freetds.conf. Trying c:\freetds.conf.
config.c:247:Found conf file 'c:\freetds.conf' (default).
config.c:375:Looking for section global.
config.c:432: Found section abc\def.
config.c:446: Reached EOF
config.c:375:Looking for section abc\def.
config.c:432: Found section abc\def.
config.c:435:Got a match.
config.c:456: host = '204.xxx.xx.xx'
config.c:485:Found host entry 204.xxx.xx.xx.
config.c:488:IP addr is 204.xxx.xx.xx.
config.c:456: instance = 'def'
config.c:456: tds version = '8.0'
config.c:456: dump file append = 'yes'
config.c:456: dump file = 'C:\Inetpub\wwwroot\freetds.log'
config.c:446: Reached EOF
config.c:251:Success: [abc\def] defined in c:\freetds.conf.
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character
set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:819:select: retval 1 err 0
net.c:836:instance info
0000 05 6c 00 53 65 72 76 65-72 4e 61 6d 65 3b 42 4f |.l.Serve rName;AB|
0010 52 3b 49 6e 73 74 61 6e-63 65 4e 61 6d 65 3b 67 |C;Instan ceName;d|
0020 65 6e 3b 49 73 43 6c 75-73 74 65 72 65 64 3b 4e |ef;IsClu stered;N|
0030 6f 3b 56 65 72 73 69 6f-6e 3b 38 2e 30 30 2e 31 |o;Versio n;8.00.1|
0040 39 34 3b 74 63 70 3b 31-31 39 37 3b 6e 70 3b 5c |94;tcp;1 197;np;\|
0050 5c 42 4f 52 5c 70 69 70-65 5c 4d 53 53 51 4c 24 |\ABC\pip e\MSSQL$|
0060 47 45 4e 5c 73 71 6c 5c-71 75 65 72 79 3b 3b |DEF\sql\ query;;|

net.c:185:Connecting to 204.xxx.xx.xx port 1197 (TDS version 8.0)
net.c:240:connect(2) returned "Unknown error"
util.c:120:Changing query state from IDLE to DEAD
net.c:310:tds_open_socket() failed
token.c:2217:tds_client_msg: #20009: "Server is unavailable or does not
exist.". Connection state is now 4.
dblib.c:1105:dbclose(02047A30)
dblib.c:253:dblib_del_connection(025048A8, 02048230)
mem.c :565:tds_free_all_results()
dblib.c:294:dblib_release_tds_ctx(1)
dblib.c:5426:dbfreebuf(02047A30)
dblib.c:438:dbloginfree(020486B8)
--------

On 12/18/07, James K. Lowden <jklowden AT freetds.org> wrote:
>
> Patrick Corbett wrote:
> > Yes, very close... I'm on a windows machine, do you think I need to
> > download a specific build of php for this?
>
> No, no. I guess I wasn't clear.
>
> > On 12/18/07, James K. Lowden < jklowden AT freetds.org> wrote:
> > > You can just change your freetds.conf thus:
> > >
> > > - host = abc.adomain.com
> > > + host = a.b.c.d
> > >
> > > where a.b.c.d is the internal address you want to connect to. That's
> > > valid.
>
> This is just a matter of getting your freetds.conf right. You should test
>
> it with tsql -- it works on Win32, yes? -- before you try PHP.
>
> Just put your dataserver's IP address (4 numbers, no port) on your "host"
> line. I think that's all you'll need to get yourself connected.
>
> (I knew it was a Windows box by the logfile name and the fact that
> connect(2) showed a failure in the log without a valid error code.)
>
> What you have here is pilot error. But you can blame Windows if you like.
>
> Why not? ;-)
>
> --jkl
> _______________________________________________
> 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