| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|mssql remote connect limit data query?|
| 4:41 am on Nov 9, 2009 (gmt 0)|
Localhost connection query all data..
$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.. ?
$connect = "Provider=SQLOLEDB.1; Data Source=192.#*$!.XX.#*$!; NetworkLibrary=DBMSSOCN; Initial Catalog=#*$!;uid=xXa;pwd=XX;";
| 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?
| 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=#*$!";
but the syntax is weird to study and i don't like IT.. T_T
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved