Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Access lotus notes database with SQL 2008 R2 Expand / Collapse
Author
Message
Posted Monday, May 16, 2011 5:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 27, 2012 4:00 AM
Points: 2, Visits: 18
I need to migrate old SQL 2000 databases into a new SQL 2008 R2 server.
however, these old databases use DTS packages to access Lotus notes databases and AS400 DB2 databases.

I didn't find lotus notes odbc 64bit drivers.
How can you continue to access the lotus notes databases with SQL 2008 R2 ?
Thanks for you help
Post #1109219
Posted Monday, May 16, 2011 9:24 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:50 AM
Points: 33,078, Visits: 15,193
Short answer, test. Not sure how the 32 bit drivers will work, but I'd install them on a x64 instance and see if you can access things. There is a DTS runtime that you can use in SQL 2008 R2, but I believe that is going away in the next version, so I'd start warning people these need to migrate to SSIS.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1109472
Posted Monday, May 16, 2011 9:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 27, 2012 4:00 AM
Points: 2, Visits: 18
the problem with SQLNotes odbc driver is that there is only 32 bits driver and the 32 bits ODBC Drivers are not visible it in a default SSIS package.
but I think I found a solution, I will test and let you know.
http://msdn.microsoft.com/en-us/library/ms141766.aspx

thanks for your update.
Post #1109525
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse