April 16, 2009 at 11:07 am
Been having a problem with a certain DB and it just occured to me that the creators of this DB has included a dot in the name ie: My.database_name
Can I assume other programs such as Crystal reports would have a problem pooling data from this database. (I'm asking cause it is having problems but not sure why).
Using SQL 2000 with OLE DB(ADO) sql server connection in Crystal Reports.
April 16, 2009 at 11:13 am
It's likely causing issues. SQL allows many characters in object names, some of which cause issues in other products, or in things like XML documents.
April 16, 2009 at 11:31 am
try qualifying your db name with []...for example [test.db]
April 16, 2009 at 11:39 am
The further I read about decimals in database names the more I realize it's not a good idea.
We are taking steps to rename, or create another DB.
Seams like the . is a object separator. so if I have my.database .
SQL or another program might see "my" as the database name and "database" as another level in my database, making everything off.
Thank you for your help guys.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply