| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-07-26 : 01:33:25
|
| Hello, everybody! I have a database called Business_BI, and I was asked to give access to my database from a BO system, which has a problem with this name (because of the underline). I don't want to change DB name,if it's possible, I'd like to create the second (logical) name that will allow connect from BO without making changes in my application. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-26 : 02:13:00
|
Have you tried using brackets?[Business_BI]
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-07-26 : 05:33:58
|
| Hi! I asked my collegue that works with BO to try ,but it didn't help |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-26 : 07:06:30
|
What is 'BO'?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-26 : 07:24:03
|
Which data access library are you using, that cannot access underscored names?See a lot of examples here for different connection stringswww.connectionstrings.com
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-07-26 : 09:12:36
|
| Access to SQL Server from Business Objects, BO developer is chosing my database from the existing list and receives error. I was told that it's an old bug in Business Objects, so they are asking me to change my DB name. I just wanted to give them an alias name' if it's possible, without making a lot of changes in my SSIS-SSAS-SSRS application |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-26 : 09:19:23
|
Well, I just tried connection to a database from Access to a SQL Server database named "Peso_Yak".No problem here.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-07-26 : 09:25:30
|
| It looks like the problem is only with BO application, because I also have no problems with Oracle. Besides we cteated DB named TEST, and connection from BO works. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-26 : 09:49:33
|
I would show the www.connectionstrings.com site for your BO developer.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-07-26 : 10:05:06
|
| I did so, but she is making connection only through wizard and cannot change things, and she is the only one that works with BO, so as you may understand, the question is now how I make it work |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-26 : 10:30:12
|
I think there is no way to use an alias for a database (it's a pity).If your database is very small i.e it has only a little number of objects (tables, procedures, etc.) there could be a chance to use synonyms.Look here:http://www.tek-tips.com/viewthread.cfm?qid=1503821&page=5
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
Other name for a database