BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: No events within the next 45 days.

Copy ODBC Configurations from one PC to another


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
bodla k
Senior Member
Senior Member



Joined: 31 May 2007

Posts: 41



PostPosted: Wed Oct 10, 2007 8:55 am 
Post subject: Copy ODBC Configurations from one PC to another

Hi all,

we have 20-25 different ODBC configurations setup. Instead of creating the same ODBC configurations on each Developers PC, Is there any way to copy the "ini" file or other procedure to copy the ODBC configurations from one PC to another?

i would appriciate any quick response.
thanks

Bob
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 12500
Location: England


flag
PostPosted: Wed Oct 10, 2007 10:14 am 
Post subject: Re: Copy ODBC Configurations from one PC to another

I would guess you could find the relevant information in the windows registry and export the appropriate registry keys from your PC and export them to the other PCs.
_________________
cheers, Nick
Back to top
JimBuckRG
Senior Member
Senior Member



Joined: 17 Jul 2006

Posts: 60
Location: Boston, MA


flag
PostPosted: Wed Oct 10, 2007 10:16 am 
Post subject: Re: Copy ODBC Configurations from one PC to another

We had our Desktop Engineering guys use SMS to push our ODBC settings to all of our users. Other than using an application like that, I am not sure of another way to do it automatically.

You can try to copy the ODBC.ini file in "C:\WINDOWS" from the source computer to others. Problem with this approach is that it will overwrite the destination file and any saved settings (good if that is the goal, bad if people use ODBC for other apps as well). Also doesn't ensure that people have the same drivers installed.

Good luck.
Back to top
bodla k
Senior Member
Senior Member



Joined: 31 May 2007

Posts: 41



PostPosted: Wed Oct 10, 2007 12:36 pm 
Post subject: Re: Copy ODBC Configurations from one PC to another

Thanks for the response

we have all the developers with same drivers installed. I tried copying the ODBC.ini file but it did not work...

bob
Back to top
JimBuckRG
Senior Member
Senior Member



Joined: 17 Jul 2006

Posts: 60
Location: Boston, MA


flag
PostPosted: Wed Oct 10, 2007 1:06 pm 
Post subject: Re: Copy ODBC Configurations from one PC to another

I was not sure it would work either. Did it still not work after a reboot? Because the ODBC settings are also in the Registry, it may take a reboot for Windows to recognize the new settings.

Just a thought ...
Back to top
BIA
Forum Member
Forum Member



Joined: 10 Oct 2007

Posts: 4



PostPosted: Thu Oct 11, 2007 11:36 am 
Post subject: Re: Copy ODBC Configurations from one PC to another

I am pretty sure that that odbc administrator creates a connection string in the registry when you stop through that proeccess. If you can find that key and export/import it. It may just work.
Back to top
bodla k
Senior Member
Senior Member



Joined: 31 May 2007

Posts: 41



PostPosted: Fri Dec 14, 2007 3:58 pm 
Post subject: Re: Copy ODBC Configurations from one PC to another

It worked for me...

what i did :
1) open the registry editor
2) select the ODBC folder under HKEY_LOCAL_MACHINE > SOFTWARE
3) export (xxx.reg file)

4) Import it into the registry on a different machine and reboot..

it works.

bob.
Back to top
dmarks
Principal Member
Principal Member



Joined: 16 Apr 2003
ASUG Icon
speaker.gif*4
Posts: 100
Location: Southwest Ohio


flag
PostPosted: Tue Feb 14, 2012 5:22 pm 
Post subject: Re: Copy ODBC Configurations from one PC to another

In 64-bit Windows,
Code:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
is where the 64-bit DSN's are stored. 32-bit DSN's are stored in
Code:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
.

SAP BusinessObjects Business Intelligence 4.0 (BI4) is primarily 64-bit, so most data sources will be looking for 64-bit DSN's. However, Crystal Reports 2011 is 32-bit (even on the BI4 server), so it will look for DSN's in the second Wow6432Node.

_________________

Dallas Marks - EVtechnologies
SAP Certified Application Associate - SAP BusinessObjects Enterprise, Web Intelligence
Sharing my daring and mundane adventures in business intelligence at DallasMarks.org

Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0444 seconds using 17 queries. (SQL 0.0021 Parse 0.0338 Other 0.0085)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo