mssql remote connect limit data query?

Forum Moderators: open

Message Too Old, No Replies

mssql remote connect limit data query?

nanat

4:41 am on Nov 9, 2009 (gmt 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

whoisgregg

11:43 pm on Jan 4, 2010 (gmt 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?

nanat

12:28 am on Jan 5, 2010 (gmt 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