Database Wierdness

[jimmyskliff]

Okay,

Can someone explain this one to me. I have an application that I built at work that accesses a database running on MSSQL 7. This database is called "Projects Database". I have slowly begun to rewrite the application from ASP to PHP.

However I ran into a problem when trying to connect to the db. It seems that the mssql_select_db() funtion does not like spaces in the database name.

For example, I renamed the database to "Projects" and the problem was fixed. But when I renamed it back to "Projects Database"
I got an error "PHP Warning: MS SQL message: Incorrect syntax near the keyword 'Database'. (severity 15) ".

Is this a bug or am I doing something wrong..... Please let me know

[[deleted]]

lol

So MS-SQL supports spaces in database names, but their API doesn't. That's MicroShit for you :-)

Anyway, the rest of the world has a convention that databasenames etc do not contain spaces, ever.

BTW: neither do they contain mixed-case. It's always all uppercase or all lowercase, never a mix.

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[jimmyskliff]

Well that is a great explaination!!!!! Thanks dude..... As for the guy who created this database, I will most certainly pass that "fact" about no spaces along to him.....Time to scold.....lol!