| Author |
Message
|
| genius_in_making |
 Posted: Thu Apr 20, 2006 10:06 pm Post subject: ODBC Drivers Lost (Urgent) |
 |
|
Novice
Joined: 23 Feb 2006
Posts: 14
|
Today we restarted the machine in which ConfigMgr was running.
After restarting & starting broker we are getting error . I've checked the event log & it says
"( WBRKBK ) The broker made an unsuccessful attempt to access its database WBRKBKDB with userid db2admin.
The broker's database could not be accessed using the userid and password supplied.
Ensure that the database is running and that the userid and password are correct"
"( WBRKBK ) Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'.
The error has the following diagnostic information: SQL State 'IM002' SQL Native Error Code '0' SQL Error Text '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I've checked in ODBC datasource administrator & to my surprise there in no entry of broker database and i was shocked to see all the odbc drivers including IBM DB2 ODBC DRIVER missing. 
without the drivers can't create a dsn entry for broker database  and withoyt that broker won't run . |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Apr 20, 2006 10:39 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi genius_in_making,
The driver files don't get deleted unless its a serious virus attack or some genius (not indicative to you  but pun intended) deleted them.
Is there any other database running....I just want to be sure that all databases are un-accessible once the driver is lost.
You could try to get a copy of the driver file from another system and paste into your system directories....I guess it will be possible to find were the drivers are stored by default.
Last resort should be reinstall DB...Take a backup, should be possible....else you will lose the link to your Broker....bigger problems.
Regards. |
|
| Back to top |
|
|
| genius_in_making |
| Posted: Thu Apr 20, 2006 11:16 pm Post subject: |
|
|
Novice
Joined: 23 Feb 2006
Posts: 14
|
Hi Elvis,
Drivers files are not deleted but lost 
May a link has been broken as i'm not able to access drivers thru ODBC datasource administrator window.
what u think we can do 2 solve the issue of broken link |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Apr 21, 2006 3:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So you have a broker running on the same machine as the configmgr?
Or why did you mention the Configmgr?
If Windows lost track of the ODBC drivers - then something drastically changed in the OS - maybe the machine got booted in 'safe' mode or something?
You need to work with your System Admin's to understand what changed.
You can try using Add/Remove programs to see if you can "Repair" the installation of WMB.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Fri Apr 21, 2006 3:49 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| Have you changed the passwords of your serviceids recently? |
|
| Back to top |
|
|
| genius_in_making |
| Posted: Fri Apr 21, 2006 8:28 pm Post subject: |
|
|
Novice
Joined: 23 Feb 2006
Posts: 14
|
Hurray !!!!!!
Issue resolved.
Took the registry entry for ODBC driver erom system running with same configuration and applied on my system and to my relief it worked!.
Thanks everyone for their suggestion  |
|
| Back to top |
|
|
|
|
