Skip to Content.
Sympa Menu

freetds - Re: sql server 7 problem - php

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick Gigger" <rick AT alpinenetworking.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: sql server 7 problem - php
  • Date: Thu, 22 Mar 2001 13:00:26 -0800


Some tests fail. I will put my exact build instructions here:

% ./configure --with-tdsver=4.2

Works fine. For some reason it is even working if I don't use
the --enable-dbmfix.



% make

works fine



$make install

ends with:
<<<<<<<
make[2]: Entering directory `/home/rick/src/freetds-0.51/src/server'
make[2]: Leaving directory `/home/rick/src/freetds-0.51/src/server'
make[1]: Leaving directory `/home/rick/src/freetds-0.51/src'
/bin/sh ./mkinstalldirs /usr/local/freetds
if [ -f /usr/local/freetds/interfaces ]; \
then :; \
else \
/usr/bin/install -c -m 644 interfaces /usr/local/freetds; \
fi
>>>>>>

Is that supposed to happen? It looks like all of the files are being copied
over and PHP doesn't complain about anything at compile, link, or execute
time.

PWD has been set like this

<<<<<<<<<<
# This file was taken from DBD::Sybase :-) It is used by 'make test' to test
# the installation

UID=the_mssql_user_id
PWD=the_correct_password
SRV=the_ip_address_of_the_server
DB=the_database_i_want_to_connect_to
>>>>>>>>>>>>>

I then run

% make check > makecheck.txt

It passed many of the tests but the following errors are returned

<<<<<<<<<<<<<<
DB-LIBRARY error (severity 7):
Attempt to initiate a new SQL Server operation with results pending.
DB-LIBRARY error (severity 7):
Attempt to initiate a new SQL Server operation with results pending.
DB-LIBRARY error (severity 7):
Attempt to initiate a new SQL Server operation with results pending.
dblib okay for t0008.c
Expected |abcdef|, found |abcdef|
dblib failed for t0009.c
dblib passed for t0010.c
Usage: lt-t0013 infile outfile
Usage: lt-t0014 infile outfile
select
select
select
The following invalid column error is normal.
DB-LIBRARY error (severity 16):
Invalid column name 'dsjfkl'.
make[7]: *** [check-TESTS] Error 1
make[6]: *** [check] Error 2
make[5]: *** [check-recursive] Error 1
make[4]: *** [check] Error 2
make[3]: *** [check-recursive] Error 1
make[2]: *** [check] Error 2
make[1]: *** [check-recursive] Error 1
make: *** [check] Error 2
>>>>>>>>>>>>>>>>>

Here is an example of some of the test resutls piped to makecheck.txt


<<<<<<<<<<<<<<<<<<<<<<<<

t0001.c: Testing login, logout
PASS: t0001
t0002.c: Test basic submit query, results
PASS: t0002
t0003.c: Testing DB change -- 'use tempdb'
PASS: t0003
t0004.c: Test large (>512 bytes) queries
PASS: t0004
t0005.c: Test large (>512 bytes) replies
PASS: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
PASS: t0006

....

make[6]: Entering directory
`/home/rick/src/freetds-0.51/src/dblib/unittests'
make check-TESTS
make[7]: Entering directory
`/home/rick/src/freetds-0.51/src/dblib/unittests'
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0001 values (0, 'row 000')
insert into dblib0001 values (1, 'row 001')
insert into dblib0001 values (2, 'row 002')
insert into dblib0001 values (3, 'row 003')
insert into dblib0001 values (4, 'row 004')
insert into dblib0001 values (5, 'row 005')
insert into dblib0001 values (6, 'row 006')

.............

Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
dblib okay on t0001.c
PASS: t0001
Start
About to logon
About to open
Dropping table
creating table

>>>>>>>>>>>>>>>>>>>>>>>>


Anyway it seem to be connecting and many of them are working.

>From PHP however it doesn't work.

Sorry for the length of my email, but I wanted to be specific.

Thanks

Rick Gigger










-----Original Message-----
From: bounce-freetds-128533 AT franklin.oit.unc.edu
[mailto:bounce-freetds-128533 AT franklin.oit.unc.edu]On Behalf Of Brian
Bruns
Sent: Thursday, March 22, 2001 5:13 AM
To: TDS Development Group
Subject: [freetds] Re: sql server 7 problem - php


Please edit the PWD file and run 'make check' to see if you can reach the
server without using PHP.

Brian

On Wed, 21 Mar 2001, Rick Gigger wrote:

> Everything works great until make install. The last output of make
install
> is as follows:
>
> make[2]: Leaving directory `/home/rick/src/freetds-0.51/src/odbc'
> Making install in server
> make[2]: Entering directory `/home/rick/src/freetds-0.51/src/server'
> make[2]: Leaving directory `/home/rick/src/freetds-0.51/src/server'
> make[1]: Leaving directory `/home/rick/src/freetds-0.51/src'
> /bin/sh ./mkinstalldirs /usr/local/freetds
> if [ -f /usr/local/freetds/interfaces ]; \
> then :; \
> else \
> /usr/bin/install -c -m 644 interfaces /usr/local/freetds; \
> fi
>
>
> I'm guessing that this is not supposed to happen. It happens everytime.
>
> I'm on Redhat 7 with freetds 0.51
>
> Any suggestions?
>
> Rick Gigger
> rick AT alpinenetworking.com
>
>
> -----Original Message-----
> From: bounce-freetds-128533 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-128533 AT franklin.oit.unc.edu]On Behalf Of Darryl
> Friesen
> Sent: Wednesday, March 21, 2001 7:28 PM
> To: TDS Development Group
> Subject: [freetds] Re: sql server 7 problem - php
>
>
>
>
> > I am trying to connect to sqlserver 7 from linux/php.
> >
> > I am using redhat 7, php 4.0.4pl1, sql server 7, freetds 0.51
> >
> > I am trying to connect like this
> >
> > $mssqlcon = mssql_pconnect("the_ip_of_the_sqlserver", "myusername",
> > "mypassword");
>
> That could be the problem there. The IP address and port number of the
> server go in the interface file (default location is the directory where
> FreeTDS is installed). Associated with that info is a server name (not
DNS
> name). That's what you use in the connect.
>
>
> - Darryl
>
> ----------------------------------------------------------------------
> Darryl Friesen, B.Sc., Programmer/Analyst Darryl.Friesen AT usask.ca
> Education & Research Technology Services, http://gollum.usask.ca/
> Department of Computing Services,
> University of Saskatchewan
> ----------------------------------------------------------------------
> "Go not to the Elves for counsel, for they will say both no and yes"
>
>
>
> ---
> You are currently subscribed to freetds as: [rick AT alpinenetworking.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>


---
You are currently subscribed to freetds as: [rick AT alpinenetworking.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page