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