Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 05-11-2008, 03:35 PM   #1 (permalink)
Member

Join Date: Jan 2007
Location: Chicago
Posts: 57
Rep Power: 2 CChesler is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Education Edge (EE)
- NetCommunity (BBNC)

Finding the Dbase files for a sql query

I have a consultant who is going to write a custom report for us on our EducationEdge application. He wants to create a query using MS Query - but I'm not able to tell him how to link to the database. We are running EE version 7.5 - I know the name of the database - just not sure how to create the link.
Any suggestions you can give me would be greatly appreciated.
Thanks
__________________
Candace Chesler
The Frances Xavier Warde School
Chicago, IL
www.fxw.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 05-12-2008, 08:13 AM   #2 (permalink)
Crystal Reports Guru

DrewAllen's Avatar

Join Date: May 2006
Location: Philadelphia, PA
Posts: 1,152
Rep Power: 4 DrewAllen is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Information Edge (TIE)
- API/VBA

Assuming that it's the same as RE, it creates an ODBC connection to your database when you install EE. You simply use that to connect to the database. I can't help you with the database structure, because I don't have access to EE.

Drew
__________________
J. Drew Allen
Children's Hospital of Philadelphia

Crystal Reports and SQL Server Consultant

It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 05-16-2008, 12:43 PM   #3 (permalink)
Member

Join Date: Jan 2007
Location: Chicago
Posts: 57
Rep Power: 2 CChesler is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Education Edge (EE)
- NetCommunity (BBNC)

Thanks Drew - turns out - I needed an unlock code in order to establish the ODBC connection with EE. I'm on my way - although now I have a new slew of questions - which I will be posting under appropriate headings.
Moving on!
__________________
Candace Chesler
The Frances Xavier Warde School
Chicago, IL
www.fxw.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
ms query, sql server


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Electricity - Loans - Credit Cards - Loans
All times are GMT -6. The time now is 02:04 AM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64