Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

mssql_execute problems: msg#00010

db.tds.freetds

Subject: mssql_execute problems

Hey All,

System: RH9, Apache 1.3.27, PHP 4.3.2, FreeTDS 0.61 connecting to a Win2K
Server, MSSQL Server 2K

Problem: mssql_execute hangs when run. The script just never comes back.

The code is as follows:
$macn = mssql_connect("SERVER", "UID", "PWD");
mssql_select_db("DB");
$stmt = mssql_init("dbo.Grade2_GET", $macn);
$result = mssql_execute($stmt);

I have compiled PHP with the --with-mssql option so it does find the functions.
Also, the Stored Proc will run just fine if executed via mssql_query(). But, I
have some stored procedures that have output parameters and thus I need to use
mssql_execute(). I have searched rather extensively on the 'net, and have seen
a couple of posts about people saying that it works correctly for them, but I
am unable to get it to work. I have even gone as far as to try the nightly
build
of FreeTDS (0.62) just to see.

We have used SQL Profiler to trace the incoming connection, and it
pushes through correctly when mssql_query() is used. However, when
mssql_execute() is used, the Profiler does not detect anything. It
appears that the problem is with the mssql_execute() function as
everything operates correctly up until the execution of this function.
I am not sophisticated enough to be able to verify this however.

Also, my env includes TDSVER = 7.0 per documentation.

I have also tried to downgrade to FreeTDS 0.53 but then PHP does not
recognize all of the mssql functions...

Does anyone have any ideas? I am currently stumped and cannot seem to
find any answers via research...

If it helps, following is the FreeTDS log:
2003-07-28 11:44:11 Connecting addr 10.0.0.220 port 1433
2003-07-28 11:44:11 inside tds_process_login_tokens()
Received header @ 2003-07-28 11:44:11
0000 04 01 01 8d 00 ab 01 00 |........|


Received packet @ 2003-07-28 11:44:11
0000 e3 1f 00 01 08 48 00 65 00 72 00 69 00 74 00 61 |.....H.e. r.i.t.a|
0010 00 67 00 65 00 06 6d 00 61 00 73 00 74 00 65 00 |.g.e..m.a .s.t.e.|
0020 72 00 ab 70 00 45 16 00 00 02 00 27 00 43 00 68 |r..p.E... ..'.C.h|
0030 00 61 00 6e 00 67 00 65 00 64 00 20 00 64 00 61 |.a.n.g.e. d. .d.a|
0040 00 74 00 61 00 62 00 61 00 73 00 65 00 20 00 63 |.t.a.b.a. s.e. .c|
0050 00 6f 00 6e 00 74 00 65 00 78 00 74 00 20 00 74 |.o.n.t.e. x.t. .t|
0060 00 6f 00 20 00 27 00 48 00 65 00 72 00 69 00 74 |.o. .'.H. e.r.i.t|
0070 00 61 00 67 00 65 00 27 00 2e 00 0b 53 00 51 00 |.a.g.e.'. ...S.Q.|
0080 4c 00 2d 00 52 00 2d 00 57 00 45 00 42 00 30 00 |L.-.R.-.W .E.B.0.|
0090 31 00 00 00 00 e3 08 00 07 05 09 04 d0 00 34 00 |1........ .....4.|
00a0 e3 17 00 02 0a 75 00 73 00 5f 00 65 00 6e 00 67 |.....u.s. _.e.n.g|
00b0 00 6c 00 69 00 73 00 68 00 00 ab 70 00 47 16 00 |.l.i.s.h. ..p.G..|
00c0 00 01 00 27 00 43 00 68 00 61 00 6e 00 67 00 65 |...'.C.h. a.n.g.e|
00d0 00 64 00 20 00 6c 00 61 00 6e 00 67 00 75 00 61 |.d. .l.a. n.g.u.a|
00e0 00 67 00 65 00 20 00 73 00 65 00 74 00 74 00 69 |.g.e. .s. e.t.t.i|
00f0 00 6e 00 67 00 20 00 74 00 6f 00 20 00 75 00 73 |.n.g. .t. o. .u.s|
0100 00 5f 00 65 00 6e 00 67 00 6c 00 69 00 73 00 68 |._.e.n.g. l.i.s.h|
0110 00 2e 00 0b 53 00 51 00 4c 00 2d 00 52 00 2d 00 |....S.Q.L .-.R.-.|
0120 57 00 45 00 42 00 30 00 31 00 00 00 00 ad 36 00 |W.E.B.0.1 .....6.|
0130 01 07 01 00 00 16 4d 00 69 00 63 00 72 00 6f 00 |......M.i .c.r.o.|
0140 73 00 6f 00 66 00 74 00 20 00 53 00 51 00 4c 00 |s.o.f.t. .S.Q.L.|
0150 20 00 53 00 65 00 72 00 76 00 65 00 72 00 00 00 | .S.e.r.v .e.r...|
0160 00 00 08 00 00 c2 e3 13 00 04 04 34 00 30 00 39 |......... ..4.0.9|
0170 00 36 00 04 34 00 30 00 39 00 36 00 fd 00 00 00 |.6..4.0.9 .6.....|
0180 00 00 00 00 00 |.....|


2003-07-28 11:44:11 inside tds_process_default_tokens() marker is e3
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is ab
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is e3
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is e3
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is ab
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is e3
2003-07-28 11:44:11 increasing block size from 4096 to 4096
2003-07-28 11:44:11 inside tds_process_default_tokens() marker is fd
2003-07-28 11:44:11 leaving tds_process_login_tokens() returning 1
Sending packet @ 2003-07-28 11:44:11
0000 01 01 00 2a 00 00 01 00 73 00 65 00 74 00 20 00 |...*....s .e.t. .|
0010 74 00 65 00 78 00 74 00 73 00 69 00 7a 00 65 00 |t.e.x.t.s .i.z.e.|
0020 20 00 38 00 30 00 30 00 30 00 | .8.0.0.0 .|

Received header @ 2003-07-28 11:44:11
0000 04 01 00 11 00 ab 01 00 |........|

Received packet @ 2003-07-28 11:44:11
0000 fd 00 00 be 00 00 00 00 00 |......... |

2003-07-28 11:44:11 processing result tokens. marker is fd

Thanks in advance for any help.

Tom


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
hardware.arm.at...    cms.citadel.dev...    video.gstreamer...    java.facelets.u...    misc.basics.qna...    web.wiki.instik...    network.uip.use...    xdg.devel/2003-...    tex.bibtex.bibd...    finance.quotesp...    ietf.zeroconf/2...    redhat.blinux.g...    suse.db2/2003-0...    php.phpesp/2004...    uml.devel/2003-...    gnome.labyrinth...    qnx.openqnx.dev...    boot-loaders.gr...    db.dataperfect....    audio.audacity....    linux.uclinux.m...    editors.j.devel...    os.openbsd.tech...    kde.users.multi...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation