[freetds] RE: nightly snapshot updated (James K. Lowden)

Damian Marinaccio dxmwml at rit.edu
Fri May 14 09:29:19 EDT 2004


I found another occurrence of test -L. Here is the output.

if test ! -r doc/freetds-0.63.dev.20040514/userguide/index.htm ; then \
        echo '<html><P>at <a
HREF="http://www.freetds.org/userguide/">www.freetds.org</a></html>'
\
        > .index.htm && \
        mv .index.htm doc/freetds-0.63.dev.20040514/userguide/index.htm;
\
fi
test -f doc/freetds-0.63.dev.20040514/userguide/index.htm
cd doc/freetds-0.63.dev.20040514/userguide && if test ! -L index.html ;
then ln -s index.htm index.html; fi
/bin/sh: test: argument expected
make[1]: *** [doc/freetds-0.63.dev.20040514/userguide/index.htm] Error 1
make[1]: Leaving directory `/src/freetds-0.63.dev.20040514/doc'
make: *** [all-recursive] Error 1


Hope this helps!

Damian

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of
freetds-request at lists.ibiblio.org
Sent: Thursday, May 13, 2004 8:41 PM
To: freetds at lists.ibiblio.org
Subject: FreeTDS Digest, Vol 16, Issue 15


Send FreeTDS mailing list submissions to
	freetds at lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
	freetds-request at lists.ibiblio.org

You can reach the person managing the list at
	freetds-owner at lists.ibiblio.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of FreeTDS digest..."


Today's Topics:

   1. RE: Another OTL question / problem (Michael Peppler)
   2. Cannot Connect (rconner at commspeed.net)
   3. Re: Cannot Connect (Daniel Fazekas)
   4. nightly snapshot updated (James K. Lowden)
   5. Re: Freetds 0.60.1 vs freetds 0.62.3 and unixODBC 2.2.8
      (James K. Lowden)
   6. Server - Problems with TDS 4.2 COLFMT token (Steve Kirkendall)


----------------------------------------------------------------------

Message: 1
Date: Thu, 13 May 2004 20:00:59 +0200
From: Michael Peppler <mpeppler at peppler.org>
Subject: RE: [freetds] Another OTL question / problem
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <1084471259.4626.2.camel at elanor.peppler.org>
Content-Type: text/plain

On Thu, 2004-05-13 at 15:51, Lowden, James K wrote:
> > From: freetds-bounces at lists.ibiblio.org 
> > [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of
> > > On Thu, 13 May 2004, Frediano Ziglio <freddyz77 at tin.it> wrote:
> > > > - getting store procedure informations (I don't know how)
> > > 
> > > What information, exactly?
> > 
> > The first recordset types returned (and possibly store procedure 
> > parameters list)
> 

> Then comes this glorious Alice-in-Wonderland observation:
> 
> "In SQL Server, only the column information about input and output 
> parameters for the stored procedure are [sic] returned."
> 
> One wonders what besides SQL Server runs sp_sproc_columns?

In any case it is impossible to know what result sets and columns a proc
might return without running it, as it may very well return completely
different result sets when passed different parameters. Consider:

create proc my_proc @flag int
as
if @flag = 1
   select * from sysusers
else
   select * from sysobjects
go

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler at peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html




------------------------------

Message: 2
Date: Thu, 13 May 2004 14:03:47 -0700 (MST)
From: rconner at commspeed.net
Subject: [freetds] Cannot Connect
To: freetds at lists.ibiblio.org
Message-ID: <52392.134.134.136.1.1084482227.squirrel at 216.19.2.97>
Content-Type: text/plain;charset=iso-8859-1

So about a month ago I posted a few times to this group about not being
able to connect to a mssql server.  All the settings seemed good and I
couldnt figure it out.  Then while messing around with it one day it
started working.  It actually worked GREAT until the server I run Apache
and php from crashed and had to be rebuilt.  I am back trying to get
FreeTDS to work again.

Here is what I have

==============
Freetds.conf
==============

; For example, on Windows:
[mypool]
        host = 127.0.0.1
        port = 5000
        tds version = 4.2

# A typical Microsoft SQL Server 7.0 configuration ;[MyServer70]
;       host = ntmachine.domain.com
;       port = 1433
;       tds version = 7.0

# A typical Microsoft SQL Server 2000 configuration
[myServer]
        host = NQLSQL01
        port = 1433
        tds version = 7.0

# A typical Microsoft SQL Server 6.x configuration ;[MyServer65]
;       host = ntmachine.domain.com
;       port = 1433
;       tds version = 4.2


==============

====================
php compiled with
====================

'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql'
'--with-sybase=/usr/local/freetds'

======================


======================
php.ini (well the part i think i need)
======================

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the
following ; syntax: ;
;   extension=modulename.extension
;
; For example, on Windows:
;
;   extension=msql.dll
;
; ... or under UNIX:
;
   extension=msql.so
   extension=mssql.so
;
; Note that it should be the name of the module only; no directory
information



=========================


========================
php connect statement
=======================

<?php

$myServer = "servername";
$mssql_Username = "user";
$mssql_Password = "secret";
$mssql_DBName = "AMATS";

// create mysql connection
$new_Connect = @mssql_connect($myServer, $mssql_Username,
$mssql_Password)
    or die ( "could not connect to $myServer");
// select database
$new_Db = @mssql_select_db($mssql_DBName, $new_Connect)
    or die("Couldn't select database");


?>


=========================



But I get a undable to connect.  Any Ideas?

Also i did a locate on the msql.so and mssql.so and i didnt ahve either
file.  Could someone check theirs?

Conner


------------------------------

Message: 3
Date: Thu, 13 May 2004 23:33:21 +0200
From: Daniel Fazekas <fdsubs at axelero.hu>
Subject: [freetds] Re: Cannot Connect
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <285291DE-A525-11D8-A676-000A9574B604 at axelero.hu>
Content-Type: text/plain; charset=US-ASCII; format=flowed


On May 13, 2004, at 23:03, rconner at commspeed.net wrote:

[...]
> able to connect to a mssql server.
[... php configure line ...]
> './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' 
> '--with-mysql' '--with-sybase=/usr/local/freetds'
>
> php.ini (well the part i think i need)
> ; Dynamic Extensions ;
>    extension=msql.so
>    extension=mssql.so
>

MSQL has absolutely nothing to do with FreeTDS or MSSQL. You probably 
never even heard of that database.

Second, you have to make up your mind on which PHP extension you wish 
to use, the native choices being sybase, sybase_ct and mssql; plus 
whether you want them built-in to your PHP binary or loaded as a 
dynamic extension.

According to your email, you've chosen to compile in the sybase 
extension statically. In this case, it doesn't have to be loaded via 
php.ini or by any other means -- it's built-in and active all the time.

So the lines you uncommented in your php.ini are only causing error 
messages referencing non-existent files. You can build the shared 
module by specifying the shared option to PHP's configure script, for 
example:

--with-mssql=shared,/usr/local

This would build you the mssql.so you wanted.

[...]
> [myServer]
>         host = NQLSQL01
>         port = 1433
>         tds version = 7.0
[...]
> <?php
>
> $myServer = "servername";
> $mssql_Username = "user";
> $mssql_Password = "secret";
> $mssql_DBName = "AMATS";
>
> // create mysql connection
> $new_Connect = @mssql_connect($myServer, $mssql_Username,
> $mssql_Password)

1. Make sure that NQLSQL01 is not [only] a NetBIOS name but a valid DNS 
host name.

Check that you can:

host NQLSQL01

or

ping NQLSQL01

on the Linux machine's console.

If not, you'll have to edit your name server's configuration or simply 
enter the numerical IP address.

2. change the $myServer line so it is set to the same name you put 
between the square brackets in freetds.conf:
$myServer = "myServer";


--
fds



------------------------------

Message: 4
Date: Thu, 13 May 2004 20:01:20 -0400
From: "James K. Lowden" <jklowden at schemamania.org>
Subject: [freetds] nightly snapshot updated
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <20040513200120.7a00769a.jklowden at schemamania.org>
Content-Type: text/plain; charset=US-ASCII

On Thu, 13 May 2004, "Damian Marinaccio" <dxmwml at rit.edu> wrote:
> The Snapshot available on the website still seems to be from 5-07?

Thanks for pointing that out.  I updated it, and I think I solved the
problem. 

--jkl


------------------------------

Message: 5
Date: Thu, 13 May 2004 20:09:49 -0400
From: "James K. Lowden" <jklowden at schemamania.org>
Subject: Re: [freetds] Freetds 0.60.1 vs freetds 0.62.3 and unixODBC
	2.2.8
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <20040513200949.1e9056e3.jklowden at schemamania.org>
Content-Type: text/plain; charset=US-ASCII

On Thu, 13 May 2004 11:44:51 -0400, "Novick, Jeff" <novickj at toysrus.com>
wrote:
> Thank you, but, that's where freetds.conf is currently located. 
> root at pollerint:~/source/freetds-0.62.3# ls -l /etc/freetds.conf
> ls: /etc/freetds.conf: No such file or directory
> 
> ls -l /usr/local/etc/freetds.conf
> -rw-r--r--    1 root     root         3663 May 13 07:21
> /usr/local/etc/freetds.conf
> 
> So I tried this, and still no good.

Try setting TDSDUMPCONFIG.  When the FreeTDS ODBC driver is called on to
look up the servername, it will log its search attempts to that file.  

Alternatively, look in your TDSDUMP log.  If it says it can't connect to
server SYBASE, it's likely freetds.conf was not consulted.  It may be
that your odbc.ini doesn't correctly reflect where FreeTDS is installed.


HTH.

--jkl


------------------------------

Message: 6
Date: Thu, 13 May 2004 17:39:44 -0700
From: Steve Kirkendall <skirkendall at dsl-only.net>
Subject: [freetds] Server - Problems with TDS 4.2 COLFMT token
To: FreeTDS <freetds at lists.ibiblio.org>
Message-ID: <20040513173944.00cf42c0.skirkendall at dsl-only.net>
Content-Type: text/plain; charset="us-ascii"

I'm hoping this will be obvious to somebody...

Most of my success in writing a tiny SQL server has come with TDS 5.0.
Now I'm making another attempt at using TDS 4.2, and I'm running into a
problem.  It seems that the client (the FreeTDS ODBC driver on a Windows
machine) is parsing the 0xA1(COLFMT) token incorrectly.  It keeps
reading column info past the end of the token.

Also, the description of the COLFMT token in "tds.html" seems to be way
off.  It shows 0xA1 as containing column names (duplicating the names
sent via 0xA0(COLNAME) tokens) but really it just contains four NUL
bytes, a type byte and optionally a length byte for each column...
assuming the tds_send_colinfo() function in src/server/server.c is
correct.

Anyway, I'd appreciate it if somebody could look through the attached
log file from the client, and tell me why it dies on the COLFMT token.
Maybe it has something to do with the tds_free_all_results() call
immediately before it processes the COLFMT token?

-- 
Steve Kirkendall    |A:It is confusing, since people don't read that way
kirkenda at cs.pdx.edu |Q:Why is top-posting bad?
                    |A:It is adding comments to the top of a message
                    |Q:What is top-posting?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FreeTDS.log
Type: application/octet-stream
Size: 12760 bytes
Desc: not available
Url :
http://lists.ibiblio.org/pipermail/freetds/attachments/20040513/71cea7cf
/FreeTDS.obj

------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 16, Issue 15
***************************************



More information about the FreeTDS mailing list