Saturday, February 25, 2012

dbuse function, and spaces

Hi,
We have a problem when using the dbuse function, with a database that
include a space in its name.
Any suggestions ?
I try to wrape it with 'db name' - got 000170 015 Line 1: Incorrect
syntax near

And with "db name" and got the same.

Thanks
EyalHi

You may be able to use the square brackets around the name, otherwise check
out setting quoted identifiers.

To do this you will need to set the DB Library Option DBQUOTEDIDENT see
Books Online:

mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dbl
ibc.chm::/dbc_pdcapa_6vhv.htm

John

"Eyal Goren" <eyal_goren@.bmc.com> wrote in message
news:88eabf1e.0401040029.238db349@.posting.google.c om...
> Hi,
> We have a problem when using the dbuse function, with a database that
> include a space in its name.
> Any suggestions ?
> I try to wrape it with 'db name' - got 000170 015 Line 1: Incorrect
> syntax near
> And with "db name" and got the same.
> Thanks
> Eyal

No comments:

Post a Comment