Welcome to WebmasterWorld Guest from 50.17.114.227

Forum Moderators: open

Message Too Old, No Replies

mssql remote connect limit data query?

     
4:41 am on Nov 9, 2009 (gmt 0)

Junior Member

5+ Year Member

joined:Apr 20, 2009
posts: 133
votes: 0


Localhost connection query all data..
ex. 123456

$connect = mssql_connect("#*$!","sa","XX") or die(mssql_error());
$test = mssql_select_db("XX", $connect) or die (mssql_error());

but in remote connection it will limit the query.. ?
ex.1234


$connect = "Provider=SQLOLEDB.1; Data Source=192.#*$!.XX.#*$!; NetworkLibrary=DBMSSOCN; Initial Catalog=#*$!;uid=xXa;pwd=XX;";

anybody? tnx

11:43 pm on Jan 4, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
posts:3416
votes: 0


I was hoping someone would chime in with an idea of what was going on here. :/

Did you happen to find a solution that might be able to help others if they run into this same problem?

12:28 am on Jan 5, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:Apr 20, 2009
posts: 133
votes: 0


gregg still for now i dont have any idea why the remote connection limits the query.. mybe im lacking a driver or what? T_T

but the this connection string with ODBC works..


$conn = new COM("ADODB.Connection");
$connstr="Provider=SQLOLEDB.1;Data Source=#*$!XX;Persist Security Info=False;User ID=#*$!;Password=#*$!;Initial Catalog=#*$!";
$conn->open($connstr);

but the syntax is weird to study and i don't like IT.. T_T