connecting to a ms sql server

[mkohl]

Does anyone know the script I can use to connect to a ms sql server.

I tried this basic code, and this did not work.

<?php
<?php
$dsn ="dsn";
$uid ="uid";
$pwd ="pwd";
$network="network";
$connect = odbc_connect($dsn,$uid,$pwd);
echo "This is a test.";
?>

I basically wrote this script just to see if a connection is established. I also tried "mssql_connect" that did not seem to work either.

my boss, gave me information for variable "$network" but I'm unsure how this will be involved in the data connection.

-Mike

 

[likelylad]

I am like yourself just starting to talk to an ms sql server.

Just is what I done to get things working

I am using php 5.0.3 on a windows 2000 pc.

I went into the php.ini file and enabled the mssql.dll line.

I then restarted apache.

I then used the following code

<?php
$db = @mssql_connect("server","username","password") or die("Unable to connect to server");
mssql_select_db("dbname");
$result = mssql_query("SELECT * FROM tablename");
print("<table border=1>");
print("<tr><th>Name</th></tr>");
for ($i=0; $i < mssql_num_fields($result); $i++) {
    print("<tr>");
    printf("<td>%s</td>", mssql_field_name($result, $i));
    print("</tr>");
}
print("</table>");
?>

 

[KarveR]

remove the @ from this line while testing to get any errors displyed

$db = @mssql_connect(

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.