Welcome to WebmasterWorld Guest from 54.162.93.137

Forum Moderators: open

Message Too Old, No Replies

mssql remote connect limit data query?

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

5+ Year Member



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)

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



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)

5+ Year Member



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
 

Featured Threads

Hot Threads This Week

Hot Threads This Month