tripleM

hi, When i try with the above command, i am getting the following error. Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'user'. Thanks, tripleM

hi, here username is sf and given permissions to this ordinary user. but still problem persists. Thanks, tripleM

Still not resolved my problem..

Hi, got code from the Production Server along with the DB backup. here we are using a setupfile for providing connection details like DBServer name and username, password and other details. Not using the simple command like mssql() i am just trying to restore the application on my system, so iguess no need to change any code except the DB details. Thanks, Majeed

As i specified, Prior to DB backup, prefixes are there and its running on the production server. Thanks, tripleM

Hi All, I am tryint to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which is running smoothly on a system in UK. I got the code and database backup from the Production Server. Restored the DB backup and table names are like sf.tablename and dbo.tablename. Same structure i got in my local system. When i try to run the application, i am getting error DBConnect Failed. I analysed the problem and made changes to a very first query like prefixed the schema name to the tablename in the code. for example select user from sf.Users. Then login and validation done succesfully. But i cant change it everywhere. and its not required as in the production its running without the schema name. So i am not sure if any change is required on SQLServer side. So pls let me know if any configuration/setting is required from SQLServer side? In simple words, from the PHP code if i run query like " select * from users " is not running . if i modify query in the code like " select * from sf.users ". its working fine. but my query is i wont change it in the code. if i required i will change any configuration on SQLServer. Thanks, tripleM

Hi All, I am tryint to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which is running smoothly on a system in UK. I got the code and database backup from the Production Server. Restored the DB backup and table names are like sf.tablename and dbo.tablename. Same structure i got in my local system. When i try to run the application, i am getting error DBConnect Failed. I analysed the problem and made changes to a very first query like prefixed the schema name to the tablename in the code. for example select user from sf.Users. Then login and validation done succesfully. But i cant change it everywhere. and its not required as in the production its running without the schema name. So i am not sure if any change is required on SQLServer side. So pls let me know if any configuration/setting is required from SQLServer side? Thanks, tripleM

Thanks Jon, that line is not reachable. Please let me know the significance of include_once($DirStarfish.$Plugins["Users"]-> Dir."UsersAuth{$UsersAuthMethod}.php"); After UserAuth{$UsersAuthMethod}.php. What is this?

Its defined in another php like $UsersAuthMethod = SetupVar("UsersAuthMethod"); include_once($RootDir.$Plugins["Users"]->Dir."UsersAuth{$UsersAuthMethod}.php"); $UsersAuthMethodObjectName = "UsersAuth{$UsersAuthMethod}"; $UsersAuth = new $UsersAuthMethodObjectName();

Thats my doubt, which page/file i can provide. I dont know, from which page these errors. Because in login page, at the following numbers are comments. thanks,trileM

Hi, I am getting this error from login page. Fatal error: Call to a member function getUserLogin() on a non-object Code Snippet:- function UsersGetMyLogin() { global $UsersAuth; return $UsersAuth->getUserLogin(); //here the error Could you please help me out? Thanks, tripleM

hi I am getting the following errors, when i run a login page. Notice: Undefined offset: 18 Notice: Undefined offset: 19 Notice: Undefined index: LeftSideText Notice: Undefined index: MainText and so on.. I dont understand, where and why i am getting these? Thanks, tripleM

here the folder name .LibStd. but how we can create a folder name starting with .(DOT) Regards, tripleM

/* Standard library. Must be read first. Exceptionally connected here. Not in /Plugins/setupdata.php! */ include_once($Dirname."Plugins/.LibStd/sample.php"); here $Dirname="'C:/Apache/localfolder"

No Luck . Actually i am getting the following error Warning: include(C:/Apache/localfolder/Plugins/.LibStd/sample.php) [function.include]: failed to open stream: No such file or directory in C:\Program Files\Apache Group\Apache2\htdocs\Apache\localfolder\Plugins\Users\login.php on line 8 Warning: include() [function.include]: Failed opening 'C:/Apache/localfolder/Plugins/.LibStd/sample.php' for inclusion (include_path='.;C:\php5\pear') in C:\Program Files\Apache Group\Apache2\htdocs\Apache\localfolder\Plugins\Users\login.php on line 8. Thanks, tripleM

Warning: include(C:/Apache/localfolder/Plugins/.LibStd/sample.php) [function.include]: failed to open stream: No such file or directory in C:\Program Files\Apache Group\Apache2\htdocs\Apache\localfolder\Plugins\Users\login.php on line 8 Warning: include() [function.include]: Failed opening 'C:/Apache/localfolder/Plugins/.LibStd/sample.php' for inclusion (include_path='.;C:\php5\pear') in C:\Program Files\Apache Group\Apache2\htdocs\Apache\localfolder\Plugins\Users\login.php on line 8 When i run a login page, i am getting this error. I am not able to find .LibStd What could be the reason> Regards, tripleM

Hi, I got PHP Code which is working somewhere. My job is to change DataBase name(SQLServer) hosted internally and need to run it internally. But I am unable to find , where the connection to SQLServer details have been provided. Even i searched for mssql_xx() function in the entire folder. But no luck. Could any one please tell me where could be the connection details? And also i found some where like include($Dir."Plugs/.LibStd/newfile.php"). What is .LibStd here. Because i am unable to find that.LibStd inside Plugs folder? I guess, if i find .LibStd folder and newfile.php, there could be the connection details. Thanks, tripleM

hi, I have installed SQSH in my system running on linux and able to access SQLServer running on another system. Here i need to take database backup of sqlserver from my system i.e Linux. Please let me know the commands to take database backup from SQLServer using sqsh. Regards, tripleM

No. From my system running Linux Operating System, I need to take databackup from SQLServer host on another system. Thanks, tripleM

Hi, Can we communicate MSSQLServer2000 via LINUX?Please let me know if yes! Thanks, Majeed

Hi, Actually I need connection from PHP to SQLServer2000 and done it thru simple steps. But i want to know like for a web application is there any common place to configure database details like servername , username, password? Please let me know! Thanks, tripleM

Thanks djclaux. My problem solved

Please find the following lines for MSQL details. msql--> MSQL Support --enabled Allow Persistent Links -- yes Persistent Links -- 0/unlimited Total Links -- 0/unlimited Thanks, tripleM