MSSQL connect string issue 1

[irbk]

I have a database name that has a space in it. When I run

mssql_connect(server, user, password)

It connects to the server, however, when I run

mssql_select_db(data base)

I get an error that says "Could not locate entry in sysdatabases for database 'data'." Followed by "Unable to select database: data base" Now, since I know that the name of the database is "data base" (with the space) the first error seems to tell me that something about the space is causing issue with the mssql_select_db call. Is there some kind of place holder that I can use to connect to "data base" (like using "data%base" but % doesn't work either).

Thanks in advance.

 

[cLFlaVA]

1) use quotation marks
2) in the future, don't use spaces in database names, table names, nor column names.

mssql_select_db("data base")

*cLFlaVA
----------------------------
[tt]somebody set up us the bomb![/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[sleipnir214]

The only thing I can think of off-hand is "\ " (backslash space).

The real fix is to rename the database, replacing the space with an underscore character ("_").



Want the best answers? Ask the best questions! TANSTAAFL!

 

[irbk]

cLFLaVA
1. Technically it's already quoted. I was trying to simplify the code. The entire connection string is

define ('DB_SERVER', '<server>');
define ('DB_USER', '<user>');
define ('DB_PASSWORD', '<password>');
define ('DB_NAME', '<data base>');
$dbc = mssql_connect (DB_SERVER, DB_USER, DB_PASSWORD)
	or die ('Could not connect to MSSQL');
mssql_select_db (DB_NAME)
	or die ('Could not select the database')

2. Yep, I know better then to use spaces. Unfortunatly, I wasn't the one that created the database and when the person that did create the database learns they are going to have to redo their database so the connection works, there going to learn that lesson too.

sleipnir214
Good guess but no joy

Keep the tips coming!

 

[sleipnir214]

Of course, had any of use actually looked in the PHP online manual entry for mssql_select_db() (link), we would have seen the text:

To escape the name of a database that contains spaces, hyphens ("-"), or any other exceptional characters, the database name must be enclosed in brackets, as is shown in the example, below. This technique must also be applied when selecting a database name that is also a reserved word (such as "primary").

Want the best answers? Ask the best questions! TANSTAAFL!

 

[sleipnir214]

The link in my last post was wrong. Instead, try:

http://www.php.net/function.mssql-select-db

Want the best answers? Ask the best questions! TANSTAAFL!

 

[cLFlaVA]

*cLFlaVA
----------------------------
[tt]somebody set up us the bomb![/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[sleipnir214]

CLFlaVA:
Yep.

Or course, I was operating under the assumption that irbk had already looked in the manual and not found what he was looking for.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[irbk]

DOH! Why is it that I always seem to miss the simple answers when they are RIGHT IN THE MANUAL. A serious case of RTFM. I'm no better then a user! E

http://wwww!

Thanks a TON to both of you for the posts.