Winows 7 DSN Creation and DSN Enrty in Registry
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15018
Printed Date: 03 May 2024 at 3:51am
Topic: Winows 7 DSN Creation and DSN Enrty in Registry
Posted By: nisha815
Subject: Winows 7 DSN Creation and DSN Enrty in Registry
Date Posted: 23 Nov 2011 at 10:33pm
|
Hi ,
I have learned that DSN creation in Windows 7 needs DSN entries in Registry also, where we specify the Datbase Name, Driver name i.e. the Path for the SQLserver dll, Username and the Server name.
These enteries are usually performed under this path HKEY_LOCAL_MACHINE>>SOFTWARE>>WOW6432node>>ODBC>>ODBC.IN>>
DSN_NAME.
I have created DSN on my local machine, but was not able to locate this path in Registry.
 I working on Windows 7 32 bit system, Service Pack 1.
Can anybody Help me out with this, as I am not able to run crystal report locally.
Reply asap would be highly appericated.
 Thanks in Advance
------------- Thanks & Regards Nish |
Replies:
Posted By: comatt1
Date Posted: 14 Dec 2011 at 2:56am
|
Think you need to use the 32bit ODBC,
C:\Windows\SysWOW64\odbcad32.exe
set the connections up there
|
Posted By: nisha815
Date Posted: 14 Dec 2011 at 5:43pm
|
Thanks a lot for the reply...actually my reports are running locally now.. I just updated the DSN once...no entries in the Regedit were required...And i guess the solution that you have mentioned could also be used as one of the trail method....Thanks a lot again.really appericate the help this forum give.... ------------- Thanks & Regards Nish |