Skip to Content.
Sympa Menu

freetds - RE: help: access ms sql server 7 with php3

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: help: access ms sql server 7 with php3

Chronological Thread  
    < Chronological >       < Thread >
  • From: "Sam Sam" <s4m AT mailcity.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: help: access ms sql server 7 with php3
  • Date: Mon, 01 May 2000 06:48:19 -0700

>month or so, so I will only be investigating bugs that come with code to
>reproduce them along with the table def's and inserts to populate them.
>Vague 'it doesn't work' reports are not going to get much attention (not
>trying to be mean, just very limited on time for a >while).

ok.. now I'm running apache 1.3.12 with php3 with freetds. Everything goes
fine, (connect to my sql server 7.0, select from ms sql server) but something
wrong when I tried to insert data. Check this code below

<html>
<head>
<title>HAhiihi</title>
</head>
<body><h1>YELLLLLLLLLLLOOOOWWWWW!!</h1>
<?
$sybase=mssql_connect("10.21.1.50","sam","");
mssql_select_db("pubs",$sybase);

$cuery="INSERT INTO stores
VALUES(2040,\"Nine\",\"99Sx\",\"Portland\",\"PT\",\"80912\")";

$hasil=mssql_query($cuery,$sybase);
// mssql_free_result($hasil);
mssql_close($sybase);
print("<h1>BLUEEE ONE</h1>");
?>
</body>
</html>

It should print 'YELLLLOOWW' and insert some data to ms sql server 7.0 and
print 'BLUEEEE ONE'. But In reality..
it just insert data to ms sql server 7.0 but didn't print anything..when I
tried to reload the page with same data(same primary key..
it said.. that 'duplicate primary key' but the weird thing is the 'YELLLOWWW'
and 'BLUEEE ONE' got printed.
But if the data doesn't exist it just insert the data and return nothing..(in
IE it's said Document Contain no DATA) but.. when I checked ms sql server 7.0
they get inserted..

any clue..??

best regards,
Sam

ps: here your code Brian =))


Get your FREE Email at http://mailcity.lycos.com
Get your PERSONALIZED START PAGE at http://my.lycos.com

From tazwin1 AT yahoo.com Mon May 01 12:56:36 2000
X-Mailer: Lyris Web Interface
Date: Mon, 1 May 2000 12:56:22
Subject: Problem getting freetds and sqsh working
To: freetds
From: "Bob Wilson" <tazwin1 AT yahoo.com>


I'm trying to connect to Sybase running on a remote unix server. I
downloaded Freetds and compiled just fine. When I try and run the files in
samples, I seem to connect and thats about it. I never come back from a
select call. I saw where in some of the test samples they were using sqsh.
I download the binary first and that didn't work and then download the
source and tried to build that. When I try an build I get a problem on
missing libs "libblk libcs libcomn libtcl libintl". I have my Sybase and
LD_LIBRARY paths set up to point to my freetds install path. Should I be
able to run cttest and dbtest directly after changing the login and passwd
and other vars?

I running on a RS600 box running AIX 4.2.1


Archive powered by MHonArc 2.6.24.

Top of Page