BlackBaud Raiser's Edge 6.x -- Embedded UID and Password for DB

This should be simple if I can connect with right people.  RE version 6.x

I can not make an ODBC connection with the RE.DB.;  It asks for the User ID and Password.
I have used the default Application UID -Supervisor and Password - admin; No luck.

Does anyone know if Blackbaud embedded a database UID and Password that prohibits getting into the DB without going through the actual Raiser's Edge application?

Thanks,
--Steve
smantzDirector of TechnologyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Not sure, ...

But are you quote sure that the default Application UID=Supervisor and the Password=admin
?
Are you sure you have spelled them correctly?
0
smantzDirector of TechnologyAuthor Commented:
Yes, to log-in to the application the User is Supervisor and Password is admin.  I think what I am looking for is the SA credentials.
0
Jeffrey CoachmanMIS LiasonCommented:
Just to be clear, I am not sure if, or how RE might deny Access via ODBC, ...

But also make sure you have the most recent ODBC driver installed...

Also have you tried contacting RE support directly?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

smantzDirector of TechnologyAuthor Commented:
This software has been at end of life for quite sometime and to talk with RE support, it appears you need a current contract.
The OBDC drivers are the ones that came with the software.  The connections seem to work up to the point you need a UID and PWD.

The INI files for the connection appear to not need an UID or PWD (I'll attach those if requested) but maybe I'm not reading them correctly.
0
Jeffrey CoachmanMIS LiasonCommented:
To be clear, are you connecting via code or with the table link wizard?
0
smantzDirector of TechnologyAuthor Commented:
I'm using the OBDC administrator, although there is a basic registry entry for RE created by the 32bit OBDC update.  The ini files in the Windows directory were created by the app and are primarily for running the 16 bit drivers (pre registry).  

I also have some downloaded tools for also creating links --- Sybase Interactive SQl and Sybase iAnywhere Editor.

I have tried to hardwire the user and pwd in the OBDC registry entry but it doesn't work with the credentials I have on hand.

Hope this answers some questions.
0
Jeffrey CoachmanMIS LiasonCommented:
<I'm using the OBDC administrator,>
Again,lets be clear...

If you created a blank Access database, and wanted to link to the RE table(s), ...what are the *exact* steps you would take to do this...
0
smantzDirector of TechnologyAuthor Commented:
New Database -->external Data --> ODBC Database--> Link to the data source by creating a Linked table--> Machine Data Source.

Select: Blackbaud32 DSN (type user).  There is

Now it asks for User ID and Password, none of which work.

--Steve
0
Jeffrey CoachmanMIS LiasonCommented:
Then your best bet at this point may be to contact Blackbaud  directly...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.