I am new to Business Objects n i am working for a very small company.
My company was using BO 5.x n only one user is generating reports,now they asked me to install BO on one more desktop n share those existing universes.
I installed BO n copied BOMain.key from other system to newly installed system.When i tried to open BO i am getting the following error:
“IM002 [Microsoft][ODBC Drive Manager] Data source name not found and no default driver specified”.
on ODBC DataSource Administrator
system DSN–>ADD–> SQLSERVER—>Name(Datasource Name)–>Servername—>I selected SQL server authentication—>Default database—>Finish
then i tested the data source, i got following message.
Microsoft SQL Server ODBC Driver Version 03.85.1022
Running connectivity tests…
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
Then i copied the locdata folder from old system to newly installed machine.Still i am getting the same error !!!
On the new machine did you name the DSN exactly the same as it is on the old machine?
Yeh i did create with the same name.
I noticed in older machine had two system DSN names.
How do we know which DSN used for that repository?(becose somebody created that before).
Choose one, and click Modify, and see if it is pointing to the correct database. If not, then you know that you’ve found the one that can probably be deleted.
It seems i am doing something wrong in whole process.
I will explain what need to accomplish.In my organization one user is generating reports through his desktop n repository is on SQL server.I installed same version of BO on other desktop n want to use the same repository(i.e Universes,reports etc).WHat is the exact procedure do i follow?? Pls explain me in detail …Thanks in advance
Let me put on my Moderator hat for a monent. You keep inserting an “n” into your sentences. I don’t know what this means, and probably most BOB members don’t either. Can you please take the time to spell out your words? Thanks.
OK, back to the issue. The steps would be as follows: Install middleware Configure needed connections Install BO software Copy the .key file into the LocData folder
That’s it. Did you go through all these steps? Since you’re using ODBC, I know that the sirst step has been done. The second step is what concerns me. The name of the connection must be exactly the same on all machines.
OK SIR.From now,there is no one word “n” in my posts.
I did foloow the exact steps which you are pointed.
Install middleware
Configure needed connections
Install BO software
Copy the .key file into the LocData folder
I observed ,the locdata(BOMain.key) folder is on network i.e on server machine.In old machine,the locdata(BOMain.key) folder is on my networkplaces under Vol1 which is on server and one more Locdata(No BOMain.key)folder is on C:/Program Files/Business Objects.I could not understand which Locdata folder is using the old machine!!!
Any Help ??
I checked Locdata Folder in old Machine but there is no BOMain.key in that folder.I found that BOMain.key On Server machine.I couldn’t understand how he is able to connect to repository without BOMain.key on his machine?
Aha! We may be on to something here. If the old machine doesn’t have a .key file, then the user won’t be asked to enter a User Name and Password when launching BusinessObjects. Is that the case? You can still open BusinessObjects and use it as a standalone system, however, you won’t be connected to the repository.
Do you have Supervisor installed on the old machine? If so, create a new .key file on that machine. Test it, then copy it to the new machine.
I searched for *.key which is in
My Networkplaces \E:\Vol1\Business Objects\LocData
and in My Networkplaces \E:\Vol1\Business Objects\ShData
E : is the server drive
(BOB member since 2002-08-16)
(BOB member since 2002-06-25)
(BOB member since 2002-08-08)
You keep inserting an “n” into your sentences. I don’t know what this means, and probably most BOB members don’t either. Can you please take the time to spell out your words? Thanks.
Install middleware
(BOB member since 2002-08-08)
(BOB member since 2002-06-20)