MSSQL and ODBC Connections with PHP on Windows

Hi,

I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using PHP o=
n Windows with MSSQL database on a single machine? (The PHP and MSSQL datab=
ase are not set up remotely on two different servers.

I have set up both, and my ODBC Driver does work when I run it from the=
test without using PHP, and yet when I put it in PHP, my entire screen goe=
s blank.


$dsn=3D"MSSQL";
$username=3D"user";
$password=3D"password";

$sqlconnect=3Dodbc_connect($dsn,$username,$password);
$sqlquery=3D"SELECT title FROM books";
$process=3Dodbc_exec($sqlconnect, $sqlquery);

while(odbc_fetch_row($process)){
$Name =3D odbc_result($process,"Name");
echo "$Name
"; }
odbc_close($sqlconnect);


The similar thing happens when I use the code by using a slight modificatio=
n from http://us3.php.net/manual/en/function.mssql-connect.php.

Can anyone please provide me some tips and solutions on what additional mod=
ules or set up I need to get this to work? I was told that if I use Windows=
, I may not have to use FreeTDS.

Thanks in advance.
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MSSQL and ODBC Connections with PHP on Windows

Why use odbc?
Why not something like:

$server = "localhost";
$username = "USER";
$password = "Password";
$sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't
Connect to server.");

$sqldb = mssql_select_db("DB", $sqlconnect);
$SqlSelectData = "select * from tablename";
$results = mssql_query($SqlSelectData);

while($nameresults = mssql_fetch_array($results)){
$Name = $namereults(['Name']);
echo "$Name
";
}
Mssql_Close($sqlconnect)


Or somethignt like that. You need to make sure that the mssql extension is
loaded in your php.ini.
-----Original Message-----
From: Wei, Alice J. [mailto:ajwei@indiana.edu]
Sent: Wednesday, June 18, 2008 10:45 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

Hi,

I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using PHP on
Windows with MSSQL database on a single machine? (The PHP and MSSQL database
are not set up remotely on two different servers.

I have set up both, and my ODBC Driver does work when I run it from the
test without using PHP, and yet when I put it in PHP, my entire screen goes
blank.


$dsn="MSSQL";
$username="user";
$password="password";

$sqlconnect=odbc_connect($dsn,$username,$password);
$sqlquery="SELECT title FROM books";
$process=odbc_exec($sqlconnect, $sqlquery);

while(odbc_fetch_row($process)){
$Name = odbc_result($process,"Name");
echo "$Name
"; }
odbc_close($sqlconnect);


The similar thing happens when I use the code by using a slight modification
from http://us3.php.net/manual/en/function.mssql-connect.php.

Can anyone please provide me some tips and solutions on what additional
modules or set up I need to get this to work? I was told that if I use
Windows, I may not have to use FreeTDS.

Thanks in advance.
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: MSSQL and ODBC Connections with PHP on Windows

I would recommend using PDO for MSSQL, because it performs better in most.

You have to enable both php_pdo.dll and php_pdo_mssql.dll in your php.ini, restart the web server and you should be ready to go.

Here's a sample code taken from http://de.php.net/manual/en/ref.pdo-dblib.php
[CODE]
try {
$hostname = "myhost";
$port = 1433;
$dbname = "tempdb";
$username = "dbuser";
$pw = "password";
$dbh = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$p w");
} catch (PDOException $e) {
echo "Failed to get DB handle: " . $e->getMessage() . "\n";
exit;
}
$stmt = $dbh->prepare("select name from master..sysdatabases where name = db_name()");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
unset($dbh); unset($stmt);
?>
[/CODE]

I especially like the fetchAll() function, that's really fast!

Best regards,

Sascha
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MSSQL and ODBC Connections with PHP on Windows

Hi,

Using the mssql connection has so far given me more trouble, and I did us=
e your code, which only gives me error messages. I did try to telnet it to =
make sure that the server exists, and I was in.

Here is the code:






echo "

hello

Here are the results:

$Name
";
$n++;
}
mssql_close($sqlconnect);
?>



In my php.ini file, extension=3Dphp_mssql.dll was downloaded and loaded int=
o C:/PHP/ext. I have added a line to give me errors, and it does pop up a w=
indow that says mssql was loaded. Therefore, does this mean that my extensi=
on is working? Or, is there is any glitch for me to see additonal error rep=
orts to show what kind of error I may be really getting?

Thanks in advance.

Alice
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu
________________________________________
From: Zephaniah ha Levi [zleviticus@fitnessnow.org]
Sent: Wednesday, June 18, 2008 10:53 AM
To: Wei, Alice J.; php-windows@lists.php.net
Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

Why use odbc?
Why not something like:

$server =3D "localhost";
$username =3D "USER";
$password =3D "Password";
$sqlconnect =3D mssql_connect($server, $username, $password) or DIE("Can't
Connect to server.");

$sqldb =3D mssql_select_db("DB", $sqlconnect);
$SqlSelectData =3D "select * from tablename";
$results =3D mssql_query($SqlSelectData);

while($nameresults =3D mssql_fetch_array($results)){
$Name =3D $namereults(['Name']);
echo "$Name
";
}
Mssql_Close($sqlconnect)


Or somethignt like that. You need to make sure that the mssql extension is
loaded in your php.ini.
-----Original Message-----
From: Wei, Alice J. [mailto:ajwei@indiana.edu]
Sent: Wednesday, June 18, 2008 10:45 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

Hi,

I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using PHP o=
n
Windows with MSSQL database on a single machine? (The PHP and MSSQL databas=
e
are not set up remotely on two different servers.

I have set up both, and my ODBC Driver does work when I run it from the
test without using PHP, and yet when I put it in PHP, my entire screen goes
blank.


$dsn=3D"MSSQL";
$username=3D"user";
$password=3D"password";

$sqlconnect=3Dodbc_connect($dsn,$username,$password);
$sqlquery=3D"SELECT title FROM books";
$process=3Dodbc_exec($sqlconnect, $sqlquery);

while(odbc_fetch_row($process)){
$Name =3D odbc_result($process,"Name");
echo "$Name
"; }
odbc_close($sqlconnect);


The similar thing happens when I use the code by using a slight modificatio=
n
from http://us3.php.net/manual/en/function.mssql-connect.php.

Can anyone please provide me some tips and solutions on what additional
modules or set up I need to get this to work? I was told that if I use
Windows, I may not have to use FreeTDS.

Thanks in advance.
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MSSQL and ODBC Connections with PHP on Windows

SGksDQoNCiAgIFRoYW5rcyBmb3IgdGhlIGZvbGxvdyB1cC4NCiAgIFRvIGFu c3dlciB5b3VyIHF1
ZXN0aW9ucywNCg0KICAgMSkgSSBzZWUgbm8gYWRkaXRpb25hbCBlcnJvcnMg b3RoZXIgdGhhbiB0
aGUgbWVzc2FnZXMgYWZ0ZXIgd2hhdCBJIGhhdmUgc2V0IHVwIGZvciAiQ2Fu J3QgQ29ubmVjdCB0
byBzZXJ2ZXIiIGFzIGFwcGVhcmVkIGluIG15IGVycm9yIGFmdGVyIGl0IGRp ZXMgZnJvbSB0aGUg
Y29ubmVjdGlvbi4NCiAgIDIpIGFuZCAzKSBUaGVyZWZvcmUsIEkgY2Fubm90 IGNvbm5lY3Qgb3Ig
ZXZlbiBzZWxlY3QgYSBkYXRhYmFzZSBhdCBhbGwsIG5vdCBldmVuIHRvIG1l bnRpb24gdGhhdCB0
aGlzIG1lYW5zIEkgY2Fubm90IHJldHJpZXZlIHRoZSBkYXRhIGZyb20gdGhl IGRhdGEgc291cmNl
Lg0KDQpEb2VzIHRoaXMgZ2l2ZSB5b3UgbW9yZSBpbmZvcm1hdGlvbiBvZiB3 aHkgYW0gSSBub3Qg
Z2V0dGluZyBhbnkgZGF0YSBvdXRwdXQgb3IgdHJvdWJsZSB3aXRoIGNvbm5l Y3Rpb25zPw0KDQpB
bGljZQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogRXJp YyBMZWUgW21haWx0
bzplcmljQG15cHJvamVjdHMuc3Job3N0LmluZm9dDQpTZW50OiBXZWRuZXNk YXksIEp1bmUgMTgs
IDIwMDggNjo1NSBQTQ0KVG86IFdlaSwgQWxpY2UgSi47IFplcGhhbmlhaCBo YSBMZXZpOyBwaHAt
d2luZG93c0BsaXN0cy5waHAubmV0DQpTdWJqZWN0OiBSZTogW1BIUC1XSU5d IE1TU1FMIGFuZCBP
REJDIENvbm5lY3Rpb25zIHdpdGggUEhQIG9uIFdpbmRvd3MNCg0KSGksDQoN CkNvdWxkIHlvdSBh
YmxlIGRldGFpbCB0aGUgZXJyb3JzID8NCkkgYW0gcHJlZmVyIGEgbWV0aG9k IHRoYXQgc2VwZXJh
dGUgdGhlIGNvbm5lY3Rpb24gc3RlcHMgYXMNCg0KMS4pIENvdWxkIHlvdSBh YmxlIGNvbm5lY3Rp
b24gdG8gdGhlIHNlcnZlciB3aXRob3V0IGVycm9yID8NCjIuKSBBYmxlIHRv IHNlbGVjdCBhIGRp
ZmZlcmVudCBkYXRhYmFzZSA/DQozLikgZ2V0IHRoZSBkYXRhIGZyb20gZGF0 YWJhc2UgeW91IG5l
ZWQgdG8gdXNlLg0KDQpJdCBpcyBiZXN0IGFsc28gcHJvdmlkZSB0aGUgZXJy b3IgbWVzc2FnZXMg
dGhhdCBkaXNwbGF5ZWQgb24geW91ciBzY3JlZW4uDQoNCg0KUmVnYXJkcywN CkVyaWMNCg0KDQo6
DQo6LS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLQ0KOkZyb206ICJXZWks IEFsaWNlIEouIiA8
YWp3ZWlAaW5kaWFuYS5lZHU+DQo6VG86ICJaZXBoYW5pYWggaGEgTGV2aSIg PHpsZXZpdGljdXNA
Zml0bmVzc25vdy5vcmc+OyA8cGhwLXdpbmRvd3NAbGlzdHMucGhwLm5ldD4N CjpTZW50OiBUaHVy
c2RheSwgSnVuZSAxOSwgMjAwOCA0OjQ3IEFNDQo6U3ViamVjdDogUkU6IFtQ SFAtV0lOXSBNU1NR
TCBhbmQgT0RCQyBDb25uZWN0aW9ucyB3aXRoIFBIUCBvbiBXaW5kb3dzDQo6 DQo6DQo6SGksDQo6
DQo6ICBVc2luZyB0aGUgbXNzcWwgY29ubmVjdGlvbiBoYXMgc28gZmFyIGdp dmVuIG1lIG1vcmUg
dHJvdWJsZSwgYW5kIEkgZGlkIHVzZSB5b3VyIGNvZGUsIHdoaWNoIG9ubHkg Z2l2ZXMgbWUgZXJy
b3IgbWVzc2FnZXMuIEkgZGlkIHRyeSB0byB0ZWxuZXQgaXQgdG8gbWFrZSBz dXJlIHRoYXQgdGhl
IHNlcnZlciBleGlzdHMsIGFuZCBJIHdhcyBpbi4NCjoNCjpIZXJlIGlzIHRo ZSBjb2RlOg0KOg0K
OjxodG1sPg0KOjxoZWFkPg0KOjx0aXRsZT5QSFAgU1FMIERhdGFiYXNlPC90 aXRsZT4NCjo8L2hl
YWQ+DQo6PGJvZHk+DQo6PD9waHANCjplY2hvICI8cD5oZWxsbzwvcD4iOw0K OiRzZXJ2ZXIgPSAi
bG9jYWxob3N0LDE0MzMiOw0KOiR1c2VybmFtZSA9ICJ1c2VybmFtZSI7DQo6 JHBhc3N3b3JkID0g
InBhc3MiOw0KOiRzcWxjb25uZWN0ID0gbXNzcWxfY29ubmVjdCgkc2VydmVy LCAkdXNlcm5hbWUs
ICRwYXNzd29yZCkgb3IgRElFKCJDYW4ndA0KOkNvbm5lY3QgdG8gc2VydmVy LiIpOw0KOiRzcWxk
YiA9IG1zc3FsX3NlbGVjdF9kYigibXlkYiIsICRzcWxjb25uZWN0KTsNCjok U3FsU2VsZWN0RGF0
YSA9ICJzZWxlY3QgTmFtZSBmcm9tIHBhdGllbnQiOw0KOiRyZXN1bHRzID0g bXNzcWxfcXVlcnko
JFNxbFNlbGVjdERhdGEpOw0KOndoaWxlKCRuYW1lcmVzdWx0cyA9IG1zc3Fs X2ZldGNoX2FycmF5
KCRyZXN1bHRzKSl7DQo6JE5hbWUgPSAkbmFtZXJldWx0c1snTmFtZSddOw0K OmVjaG8gIjxwPkhl
cmUgYXJlIHRoZSByZXN1bHRzOjwvcD4iOw0KOmVjaG8gIjxwPiROYW1lPGJy PiI7DQo6JG4rKzsN
Cjp9DQo6bXNzcWxfY2xvc2UoJHNxbGNvbm5lY3QpOw0KOj8+DQo6PC9ib2R5 Pg0KOjwvaHRtbD4N
CjoNCjpJbiBteSBwaHAuaW5pIGZpbGUsIGV4dGVuc2lvbj1waHBfbXNzcWwu ZGxsIHdhcyBkb3du
bG9hZGVkIGFuZCBsb2FkZWQgaW50byBDOi9QSFAvZXh0LiBJIGhhdmUgYWRk ZWQgYSBsaW5lIHRv
IGdpdmUgbWUgZXJyb3JzLCBhbmQgaXQgZG9lcyBwb3AgdXAgYSB3aW5kb3cg dGhhdCBzYXlzIG1z
c3FsIHdhcyBsb2FkZWQuIFRoZXJlZm9yZSwgZG9lcyB0aGlzIG1lYW4gdGhh dCBteSBleHRlbnNp
b24gaXMgd29ya2luZz8gT3IsIGlzIHRoZXJlIGlzIGFueSBnbGl0Y2ggZm9y IG1lIHRvIHNlZSBh
ZGRpdG9uYWwgZXJyb3IgcmVwb3J0cyB0byBzaG93IHdoYXQga2luZCBvZiBl cnJvciBJIG1heSBi
ZSByZWFsbHkgZ2V0dGluZz8NCjoNCjpUaGFua3MgaW4gYWR2YW5jZS4NCjoN CjpBbGljZQ0KOj09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PQ0KOkFs
aWNlIFdlaQ0KOk1JUyAyMDA5DQo6U2Nob29sIG9mIExpYnJhcnkgYW5kIElu Zm9ybWF0aW9uIFNj
aWVuY2UNCjpJbmRpYW5hIFVuaXZlcnNpdHkgQmxvb21pbmd0b24NCjphandl aUBpbmRpYW5hLmVk
dQ0KOl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18N CjpGcm9tOiBaZXBo
YW5pYWggaGEgTGV2aSBbemxldml0aWN1c0BmaXRuZXNzbm93Lm9yZ10NCjpT ZW50OiBXZWRuZXNk
YXksIEp1bmUgMTgsIDIwMDggMTA6NTMgQU0NCjpUbzogV2VpLCBBbGljZSBK LjsgcGhwLXdpbmRv
d3NAbGlzdHMucGhwLm5ldA0KOlN1YmplY3Q6IFJFOiBbUEhQLVdJTl0gTVNT UUwgYW5kIE9EQkMg
Q29ubmVjdGlvbnMgd2l0aCBQSFAgb24gV2luZG93cw0KOg0KOldoeSB1c2Ug b2RiYz8NCjpXaHkg
bm90IHNvbWV0aGluZyBsaWtlOg0KOg0KOiRzZXJ2ZXIgPSAibG9jYWxob3N0 IjsNCjokdXNlcm5h
bWUgPSAiVVNFUiI7DQo6JHBhc3N3b3JkID0gIlBhc3N3b3JkIjsNCjokc3Fs Y29ubmVjdCA9IG1z
c3FsX2Nvbm5lY3QoJHNlcnZlciwgJHVzZXJuYW1lLCAkcGFzc3dvcmQpIG9y IERJRSgiQ2FuJ3QN
CjpDb25uZWN0IHRvIHNlcnZlci4iKTsNCjoNCjokc3FsZGIgPSBtc3NxbF9z ZWxlY3RfZGIoIkRC
IiwgJHNxbGNvbm5lY3QpOw0KOiRTcWxTZWxlY3REYXRhID0gInNlbGVjdCAq IGZyb20gdGFibGVu
YW1lIjsNCjokcmVzdWx0cyA9IG1zc3FsX3F1ZXJ5KCRTcWxTZWxlY3REYXRh KTsNCjoNCjp3aGls
ZSgkbmFtZXJlc3VsdHMgPSBtc3NxbF9mZXRjaF9hcnJheSgkcmVzdWx0cykp ew0KOiAkTmFtZSA9
ICRuYW1lcmV1bHRzKFsnTmFtZSddKTsNCjplY2hvICIkTmFtZTxicj4iOw0K On0NCjpNc3NxbF9D
bG9zZSgkc3FsY29ubmVjdCkNCjoNCjoNCjpPciBzb21ldGhpZ250IGxpa2Ug dGhhdC4gWW91IG5l
ZWQgdG8gbWFrZSBzdXJlIHRoYXQgdGhlIG1zc3FsIGV4dGVuc2lvbiBpcw0K OmxvYWRlZCBpbiB5
b3VyIHBocC5pbmkuDQo6LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCjpG cm9tOiBXZWksIEFs
aWNlIEouIFttYWlsdG86YWp3ZWlAaW5kaWFuYS5lZHVdDQo6U2VudDogV2Vk bmVzZGF5LCBKdW5l
IDE4LCAyMDA4IDEwOjQ1IEFNDQo6VG86IHBocC13aW5kb3dzQGxpc3RzLnBo cC5uZXQNCjpTdWJq
ZWN0OiBbUEhQLVdJTl0gTVNTUUwgYW5kIE9EQkMgQ29ubmVjdGlvbnMgd2l0 aCBQSFAgb24gV2lu
ZG93cw0KOg0KOkhpLA0KOg0KOiAgIEkgYW0gYSBuZXdiaWUgdXNpbmcgdGhl IGNvbWJpbmF0aW9u
IG9mIFBIUCBhbmQgTVNTUUwgdG9nZXRoZXIuDQo6ICAgQ2FuIGFueW9uZSB0 ZWxsIG1lIHdoaWNo
IG1ldGhvZCBpdCBtaWdodCBiZSBiZXR0ZXIgYXMgZmFyIGFzIHVzaW5nIFBI UCBvbg0KOldpbmRv
d3Mgd2l0aCBNU1NRTCBkYXRhYmFzZSBvbiBhIHNpbmdsZSBtYWNoaW5lPyAo VGhlIFBIUCBhbmQg
TVNTUUwgZGF0YWJhc2UNCjphcmUgbm90IHNldCB1cCByZW1vdGVseSBvbiB0 d28gZGlmZmVyZW50
IHNlcnZlcnMuDQo6DQo6ICAgIEkgaGF2ZSBzZXQgdXAgYm90aCwgYW5kIG15 IE9EQkMgRHJpdmVy
IGRvZXMgd29yayB3aGVuIEkgcnVuIGl0IGZyb20gdGhlDQo6dGVzdCB3aXRo b3V0IHVzaW5nIFBI
UCwgYW5kIHlldCB3aGVuIEkgcHV0IGl0IGluIFBIUCwgbXkgZW50aXJlIHNj cmVlbiBnb2VzDQo6
YmxhbmsuDQo6DQo6DQo6JGRzbj0iTVNTUUwiOw0KOiR1c2VybmFtZT0idXNl ciI7DQo6JHBhc3N3
b3JkPSJwYXNzd29yZCI7DQo6DQo6JHNxbGNvbm5lY3Q9b2RiY19jb25uZWN0 KCRkc24sJHVzZXJu
YW1lLCRwYXNzd29yZCk7DQo6JHNxbHF1ZXJ5PSJTRUxFQ1QgdGl0bGUgRlJP TSBib29rcyI7DQo6
JHByb2Nlc3M9b2RiY19leGVjKCRzcWxjb25uZWN0LCAkc3FscXVlcnkpOw0K Og0KOndoaWxlKG9k
YmNfZmV0Y2hfcm93KCRwcm9jZXNzKSl7DQo6JE5hbWUgPSBvZGJjX3Jlc3Vs dCgkcHJvY2Vzcywi
TmFtZSIpOw0KOmVjaG8gIiROYW1lPGJyPiI7IH0NCjpvZGJjX2Nsb3NlKCRz cWxjb25uZWN0KTsN
CjoNCjoNCjpUaGUgc2ltaWxhciB0aGluZyBoYXBwZW5zIHdoZW4gSSB1c2Ug dGhlIGNvZGUgYnkg
dXNpbmcgYSBzbGlnaHQgbW9kaWZpY2F0aW9uDQo6ZnJvbSBodHRwOi8vdXMz LnBocC5uZXQvbWFu
dWFsL2VuL2Z1bmN0aW9uLm1zc3FsLWNvbm5lY3QucGhwLg0KOg0KOkNhbiBh bnlvbmUgcGxlYXNl
IHByb3ZpZGUgbWUgc29tZSB0aXBzIGFuZCBzb2x1dGlvbnMgb24gd2hhdCBh ZGRpdGlvbmFsDQo6
bW9kdWxlcyBvciBzZXQgdXAgSSBuZWVkIHRvIGdldCB0aGlzIHRvIHdvcms/ IEkgd2FzIHRvbGQg
dGhhdCBpZiBJIHVzZQ0KOldpbmRvd3MsIEkgbWF5IG5vdCBoYXZlIHRvIHVz ZSBGcmVlVERTLg0K
Og0KOlRoYW5rcyBpbiBhZHZhbmNlLg0KOj09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PQ0KOkFsaWNlIFdlaQ0KOk1JUyAyMDA5 DQo6U2Nob29sIG9m
IExpYnJhcnkgYW5kIEluZm9ybWF0aW9uIFNjaWVuY2UNCjpJbmRpYW5hIFVu aXZlcnNpdHkgQmxv
b21pbmd0b24NCjphandlaUBpbmRpYW5hLmVkdQ0KOg0KOi0tDQo6UEhQIFdp bmRvd3MgTWFpbGlu
ZyBMaXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQ0KOlRvIHVuc3Vic2NyaWJl LCB2aXNpdDogaHR0
cDovL3d3dy5waHAubmV0L3Vuc3ViLnBocA0KOg0KOi0tDQo6UEhQIFdpbmRv d3MgTWFpbGluZyBM
aXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQ0KOlRvIHVuc3Vic2NyaWJlLCB2 aXNpdDogaHR0cDov
L3d3dy5waHAubmV0L3Vuc3ViLnBocA0KOg0K

Re: MSSQL and ODBC Connections with PHP on Windows

Please download this newer ntwdblib.dll from here
http://myprojects.srhost.info/download/ntwdblib.zip

and place this file into %systemroot%\system32 folder

Also, do you use intergrated auth. or mixed auth mode of mssql server =
auth. ?



----- Original Message -----=20
From: "Wei, Alice J."
To: "Zephaniah ha Levi" ; =

Sent: Thursday, June 19, 2008 4:47 AM
Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows


Hi,

Using the mssql connection has so far given me more trouble, and I did =
use your code, which only gives me error messages. I did try to telnet =
it to make sure that the server exists, and I was in.

Here is the code:






echo "

hello

Here are the results:

$Name
";
$n++;
}
mssql_close($sqlconnect);
?>



In my php.ini file, extension=3Dphp_mssql.dll was downloaded and loaded =
into C:/PHP/ext. I have added a line to give me errors, and it does pop =
up a window that says mssql was loaded. Therefore, does this mean that =
my extension is working? Or, is there is any glitch for me to see =
additonal error reports to show what kind of error I may be really =
getting?

Thanks in advance.

Alice
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu
________________________________________
From: Zephaniah ha Levi [zleviticus@fitnessnow.org]
Sent: Wednesday, June 18, 2008 10:53 AM
To: Wei, Alice J.; php-windows@lists.php.net
Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

Why use odbc?
Why not something like:

$server =3D "localhost";
$username =3D "USER";
$password =3D "Password";
$sqlconnect =3D mssql_connect($server, $username, $password) or =
DIE("Can't
Connect to server.");

$sqldb =3D mssql_select_db("DB", $sqlconnect);
$SqlSelectData =3D "select * from tablename";
$results =3D mssql_query($SqlSelectData);

while($nameresults =3D mssql_fetch_array($results)){
$Name =3D $namereults(['Name']);
echo "$Name
";
}
Mssql_Close($sqlconnect)


Or somethignt like that. You need to make sure that the mssql extension =
is
loaded in your php.ini.
-----Original Message-----
From: Wei, Alice J. [mailto:ajwei@indiana.edu]
Sent: Wednesday, June 18, 2008 10:45 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

Hi,

I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using =
PHP on
Windows with MSSQL database on a single machine? (The PHP and MSSQL =
database
are not set up remotely on two different servers.

I have set up both, and my ODBC Driver does work when I run it from =
the
test without using PHP, and yet when I put it in PHP, my entire screen =
goes
blank.


$dsn=3D"MSSQL";
$username=3D"user";
$password=3D"password";

$sqlconnect=3Dodbc_connect($dsn,$username,$password);
$sqlquery=3D"SELECT title FROM books";
$process=3Dodbc_exec($sqlconnect, $sqlquery);

while(odbc_fetch_row($process)){
$Name =3D odbc_result($process,"Name");
echo "$Name
"; }
odbc_close($sqlconnect);


The similar thing happens when I use the code by using a slight =
modification
from http://us3.php.net/manual/en/function.mssql-connect.php.

Can anyone please provide me some tips and solutions on what additional
modules or set up I need to get this to work? I was told that if I use
Windows, I may not have to use FreeTDS.

Thanks in advance.
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--=20
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MSSQL and ODBC Connections with PHP on Windows

SGksIEVyaWM6DQoNCiAgIEkgdXNlIGJvdGgsIGFsdGhvdWdoIEkgZm91bmQg dGhhdCBJIGhhdmUg
b25seSBiZWVuIHVzaW5nIFdpbmRvd3MgQXV0aCB3aGVuIEkgbG9nIG9uLCBz aW5jZSBJIGhhdmUg
bm90IHlldCBmaWd1cmVkIG91dCBob3cgdG8gZ2V0IHRoZSAibXNzcWwgc2Vy dmVyIGF1dGgiIHRv
IHdvcmsuIFdvdWxkIHRoaXMgbWF0dGVyIHdpdGggdGhlIGNvbm5lY3Rpb24/ DQoNCiAgIFdoYXQg
eWVhciBpcyB0aGlzIGRsbCBmaWxlPyBMYXN0IHRpbWUgd2hlbiBJIGRvd25s b2FkZWQgb25lIGZy
b20gb25saW5lLCAoSSBhbSBub3Qgc3VyZSB3aGF0IHllYXIgaXQgd2FzIHB1 Ymxpc2hlZCksIG15
IFBIUCBjb3VsZCBubyBsb25nZXIgd3JvbmcuIEJ1dCwgSSB3aWxsIGdpdmUg aXQgYSBzaG90Lg0K
DQpBbGljZQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTog RXJpYyBbbWFpbHRv
OmJsdWVyYXkyMDQ4QHlhaG9vLmNvbV0NClNlbnQ6IFRodXJzZGF5LCBKdW5l IDE5LCAyMDA4IDM6
MzIgQU0NClRvOiBQSFAtV0lORE9XUzsgV2VpLCBBbGljZSBKLg0KU3ViamVj dDogUmU6IFtQSFAt
V0lOXSBNU1NRTCBhbmQgT0RCQyBDb25uZWN0aW9ucyB3aXRoIFBIUCBvbiBX aW5kb3dzDQoNClBs
ZWFzZSBkb3dubG9hZCB0aGlzIG5ld2VyIG50d2RibGliLmRsbCBmcm9tIGhl cmUNCmh0dHA6Ly9t
eXByb2plY3RzLnNyaG9zdC5pbmZvL2Rvd25sb2FkL250d2RibGliLnppcA0K DQphbmQgcGxhY2Ug
dGhpcyBmaWxlIGludG8gJXN5c3RlbXJvb3QlXHN5c3RlbTMyIGZvbGRlcg0K DQpBbHNvLCBkbyB5
b3UgdXNlIGludGVyZ3JhdGVkIGF1dGguIG9yIG1peGVkIGF1dGggbW9kZSBv ZiBtc3NxbCBzZXJ2
ZXIgYXV0aC4gPw0KDQoNCg0KLS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0t LQ0KRnJvbTogIldl
aSwgQWxpY2UgSi4iIDxhandlaUBpbmRpYW5hLmVkdT4NClRvOiAiWmVwaGFu aWFoIGhhIExldmki
IDx6bGV2aXRpY3VzQGZpdG5lc3Nub3cub3JnPjsgPHBocC13aW5kb3dzQGxp c3RzLnBocC5uZXQ+
DQpTZW50OiBUaHVyc2RheSwgSnVuZSAxOSwgMjAwOCA0OjQ3IEFNDQpTdWJq ZWN0OiBSRTogW1BI
UC1XSU5dIE1TU1FMIGFuZCBPREJDIENvbm5lY3Rpb25zIHdpdGggUEhQIG9u IFdpbmRvd3MNCg0K
DQpIaSwNCg0KICBVc2luZyB0aGUgbXNzcWwgY29ubmVjdGlvbiBoYXMgc28g ZmFyIGdpdmVuIG1l
IG1vcmUgdHJvdWJsZSwgYW5kIEkgZGlkIHVzZSB5b3VyIGNvZGUsIHdoaWNo IG9ubHkgZ2l2ZXMg
bWUgZXJyb3IgbWVzc2FnZXMuIEkgZGlkIHRyeSB0byB0ZWxuZXQgaXQgdG8g bWFrZSBzdXJlIHRo
YXQgdGhlIHNlcnZlciBleGlzdHMsIGFuZCBJIHdhcyBpbi4NCg0KSGVyZSBp cyB0aGUgY29kZToN
Cg0KPGh0bWw+DQo8aGVhZD4NCjx0aXRsZT5QSFAgU1FMIERhdGFiYXNlPC90 aXRsZT4NCjwvaGVh
ZD4NCjxib2R5Pg0KPD9waHANCmVjaG8gIjxwPmhlbGxvPC9wPiI7DQokc2Vy dmVyID0gImxvY2Fs
aG9zdCwxNDMzIjsNCiR1c2VybmFtZSA9ICJ1c2VybmFtZSI7DQokcGFzc3dv cmQgPSAicGFzcyI7
DQokc3FsY29ubmVjdCA9IG1zc3FsX2Nvbm5lY3QoJHNlcnZlciwgJHVzZXJu YW1lLCAkcGFzc3dv
cmQpIG9yIERJRSgiQ2FuJ3QNCkNvbm5lY3QgdG8gc2VydmVyLiIpOw0KJHNx bGRiID0gbXNzcWxf
c2VsZWN0X2RiKCJteWRiIiwgJHNxbGNvbm5lY3QpOw0KJFNxbFNlbGVjdERh dGEgPSAic2VsZWN0
IE5hbWUgZnJvbSBwYXRpZW50IjsNCiRyZXN1bHRzID0gbXNzcWxfcXVlcnko JFNxbFNlbGVjdERh
dGEpOw0Kd2hpbGUoJG5hbWVyZXN1bHRzID0gbXNzcWxfZmV0Y2hfYXJyYXko JHJlc3VsdHMpKXsN
CiROYW1lID0gJG5hbWVyZXVsdHNbJ05hbWUnXTsNCmVjaG8gIjxwPkhlcmUg YXJlIHRoZSByZXN1
bHRzOjwvcD4iOw0KZWNobyAiPHA+JE5hbWU8YnI+IjsNCiRuKys7DQp9DQpt c3NxbF9jbG9zZSgk
c3FsY29ubmVjdCk7DQo/Pg0KPC9ib2R5Pg0KPC9odG1sPg0KDQpJbiBteSBw aHAuaW5pIGZpbGUs
IGV4dGVuc2lvbj1waHBfbXNzcWwuZGxsIHdhcyBkb3dubG9hZGVkIGFuZCBs b2FkZWQgaW50byBD
Oi9QSFAvZXh0LiBJIGhhdmUgYWRkZWQgYSBsaW5lIHRvIGdpdmUgbWUgZXJy b3JzLCBhbmQgaXQg
ZG9lcyBwb3AgdXAgYSB3aW5kb3cgdGhhdCBzYXlzIG1zc3FsIHdhcyBsb2Fk ZWQuIFRoZXJlZm9y
ZSwgZG9lcyB0aGlzIG1lYW4gdGhhdCBteSBleHRlbnNpb24gaXMgd29ya2lu Zz8gT3IsIGlzIHRo
ZXJlIGlzIGFueSBnbGl0Y2ggZm9yIG1lIHRvIHNlZSBhZGRpdG9uYWwgZXJy b3IgcmVwb3J0cyB0
byBzaG93IHdoYXQga2luZCBvZiBlcnJvciBJIG1heSBiZSByZWFsbHkgZ2V0 dGluZz8NCg0KVGhh
bmtzIGluIGFkdmFuY2UuDQoNCkFsaWNlDQo9PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT0NCkFsaWNlIFdlaQ0KTUlTIDIwMDkN ClNjaG9vbCBvZiBM
aWJyYXJ5IGFuZCBJbmZvcm1hdGlvbiBTY2llbmNlDQpJbmRpYW5hIFVuaXZl cnNpdHkgQmxvb21p
bmd0b24NCmFqd2VpQGluZGlhbmEuZWR1DQpfX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fDQpGcm9tOiBaZXBoYW5pYWggaGEgTGV2aSBbemxldml0aWN1 c0BmaXRuZXNzbm93
Lm9yZ10NClNlbnQ6IFdlZG5lc2RheSwgSnVuZSAxOCwgMjAwOCAxMDo1MyBB TQ0KVG86IFdlaSwg
QWxpY2UgSi47IHBocC13aW5kb3dzQGxpc3RzLnBocC5uZXQNClN1YmplY3Q6 IFJFOiBbUEhQLVdJ
Tl0gTVNTUUwgYW5kIE9EQkMgQ29ubmVjdGlvbnMgd2l0aCBQSFAgb24gV2lu ZG93cw0KDQpXaHkg
dXNlIG9kYmM/DQpXaHkgbm90IHNvbWV0aGluZyBsaWtlOg0KDQokc2VydmVy ID0gImxvY2FsaG9z
dCI7DQokdXNlcm5hbWUgPSAiVVNFUiI7DQokcGFzc3dvcmQgPSAiUGFzc3dv cmQiOw0KJHNxbGNv
bm5lY3QgPSBtc3NxbF9jb25uZWN0KCRzZXJ2ZXIsICR1c2VybmFtZSwgJHBh c3N3b3JkKSBvciBE
SUUoIkNhbid0DQpDb25uZWN0IHRvIHNlcnZlci4iKTsNCg0KJHNxbGRiID0g bXNzcWxfc2VsZWN0
X2RiKCJEQiIsICRzcWxjb25uZWN0KTsNCiRTcWxTZWxlY3REYXRhID0gInNl bGVjdCAqIGZyb20g
dGFibGVuYW1lIjsNCiRyZXN1bHRzID0gbXNzcWxfcXVlcnkoJFNxbFNlbGVj dERhdGEpOw0KDQp3
aGlsZSgkbmFtZXJlc3VsdHMgPSBtc3NxbF9mZXRjaF9hcnJheSgkcmVzdWx0 cykpew0KICROYW1l
ID0gJG5hbWVyZXVsdHMoWydOYW1lJ10pOw0KZWNobyAiJE5hbWU8YnI+IjsN Cn0NCk1zc3FsX0Ns
b3NlKCRzcWxjb25uZWN0KQ0KDQoNCk9yIHNvbWV0aGlnbnQgbGlrZSB0aGF0 LiBZb3UgbmVlZCB0
byBtYWtlIHN1cmUgdGhhdCB0aGUgbXNzcWwgZXh0ZW5zaW9uIGlzDQpsb2Fk ZWQgaW4geW91ciBw
aHAuaW5pLg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFdl aSwgQWxpY2UgSi4g
W21haWx0bzphandlaUBpbmRpYW5hLmVkdV0NClNlbnQ6IFdlZG5lc2RheSwg SnVuZSAxOCwgMjAw
OCAxMDo0NSBBTQ0KVG86IHBocC13aW5kb3dzQGxpc3RzLnBocC5uZXQNClN1 YmplY3Q6IFtQSFAt
V0lOXSBNU1NRTCBhbmQgT0RCQyBDb25uZWN0aW9ucyB3aXRoIFBIUCBvbiBX aW5kb3dzDQoNCkhp
LA0KDQogICBJIGFtIGEgbmV3YmllIHVzaW5nIHRoZSBjb21iaW5hdGlvbiBv ZiBQSFAgYW5kIE1T
U1FMIHRvZ2V0aGVyLg0KICAgQ2FuIGFueW9uZSB0ZWxsIG1lIHdoaWNoIG1l dGhvZCBpdCBtaWdo
dCBiZSBiZXR0ZXIgYXMgZmFyIGFzIHVzaW5nIFBIUCBvbg0KV2luZG93cyB3 aXRoIE1TU1FMIGRh
dGFiYXNlIG9uIGEgc2luZ2xlIG1hY2hpbmU/IChUaGUgUEhQIGFuZCBNU1NR TCBkYXRhYmFzZQ0K
YXJlIG5vdCBzZXQgdXAgcmVtb3RlbHkgb24gdHdvIGRpZmZlcmVudCBzZXJ2 ZXJzLg0KDQogICAg
SSBoYXZlIHNldCB1cCBib3RoLCBhbmQgbXkgT0RCQyBEcml2ZXIgZG9lcyB3 b3JrIHdoZW4gSSBy
dW4gaXQgZnJvbSB0aGUNCnRlc3Qgd2l0aG91dCB1c2luZyBQSFAsIGFuZCB5 ZXQgd2hlbiBJIHB1
dCBpdCBpbiBQSFAsIG15IGVudGlyZSBzY3JlZW4gZ29lcw0KYmxhbmsuDQoN Cg0KJGRzbj0iTVNT
UUwiOw0KJHVzZXJuYW1lPSJ1c2VyIjsNCiRwYXNzd29yZD0icGFzc3dvcmQi Ow0KDQokc3FsY29u
bmVjdD1vZGJjX2Nvbm5lY3QoJGRzbiwkdXNlcm5hbWUsJHBhc3N3b3JkKTsN CiRzcWxxdWVyeT0i
U0VMRUNUIHRpdGxlIEZST00gYm9va3MiOw0KJHByb2Nlc3M9b2RiY19leGVj KCRzcWxjb25uZWN0
LCAkc3FscXVlcnkpOw0KDQp3aGlsZShvZGJjX2ZldGNoX3JvdygkcHJvY2Vz cykpew0KJE5hbWUg
PSBvZGJjX3Jlc3VsdCgkcHJvY2VzcywiTmFtZSIpOw0KZWNobyAiJE5hbWU8 YnI+IjsgfQ0Kb2Ri
Y19jbG9zZSgkc3FsY29ubmVjdCk7DQoNCg0KVGhlIHNpbWlsYXIgdGhpbmcg aGFwcGVucyB3aGVu
IEkgdXNlIHRoZSBjb2RlIGJ5IHVzaW5nIGEgc2xpZ2h0IG1vZGlmaWNhdGlv bg0KZnJvbSBodHRw
Oi8vdXMzLnBocC5uZXQvbWFudWFsL2VuL2Z1bmN0aW9uLm1zc3FsLWNvbm5l Y3QucGhwLg0KDQpD
YW4gYW55b25lIHBsZWFzZSBwcm92aWRlIG1lIHNvbWUgdGlwcyBhbmQgc29s dXRpb25zIG9uIHdo
YXQgYWRkaXRpb25hbA0KbW9kdWxlcyBvciBzZXQgdXAgSSBuZWVkIHRvIGdl dCB0aGlzIHRvIHdv
cms/IEkgd2FzIHRvbGQgdGhhdCBpZiBJIHVzZQ0KV2luZG93cywgSSBtYXkg bm90IGhhdmUgdG8g
dXNlIEZyZWVURFMuDQoNClRoYW5rcyBpbiBhZHZhbmNlLg0KPT09PT09PT09 PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQpBbGljZSBXZWkN Ck1JUyAyMDA5DQpT
Y2hvb2wgb2YgTGlicmFyeSBhbmQgSW5mb3JtYXRpb24gU2NpZW5jZQ0KSW5k aWFuYSBVbml2ZXJz
aXR5IEJsb29taW5ndG9uDQphandlaUBpbmRpYW5hLmVkdQ0KDQotLQ0KUEhQ IFdpbmRvd3MgTWFp
bGluZyBMaXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQ0KVG8gdW5zdWJzY3Jp YmUsIHZpc2l0OiBo
dHRwOi8vd3d3LnBocC5uZXQvdW5zdWIucGhwDQoNCi0tDQpQSFAgV2luZG93 cyBNYWlsaW5nIExp
c3QgKGh0dHA6Ly93d3cucGhwLm5ldC8pDQpUbyB1bnN1YnNjcmliZSwgdmlz aXQ6IGh0dHA6Ly93
d3cucGhwLm5ldC91bnN1Yi5waHANCg==