I'm new to MSSQL and have a big problem.
I need to install a php script designed for both mySQL and MSSQL but can't get it to work with MSSQL on my local server.
I run IIS and MSSQL 7 with PHP 4.2.2 under Windows 2000 Pro.
When trying to log into my script I get the following error:
Warning: MS SQL message: Invalid object name 'licences'. (severity 16) in c:\inetpub\wwwroot\osiris\tools\mssql_db.inc on line 83
Warning: MS SQL: Query failed in c:\inetpub\wwwroot\osiris\tools\mssql_db.inc on line 83
select id, username, password, name, address, zip, city, state, phone, fax, mobile, email, web, annotation, disabled, mode, demo, create_date, last_login, number_logins from licences where username='asfd'
The table licenses exists in the database osiris (when I look in the enterprise manager).
Is it a login problem or did I something wrong with the MSSQL config?
I hope you will be able to help me!