Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-03 : 08:26:42
|
| Walter writes "Can I import data from a Lotus Notes db into SQL Server?I'm running SQL Server 7.0 w/sp4 on Windows 2000 server." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-03 : 12:32:54
|
| If you have an ODBC driver for Lotus Notes, then yes. You can use DTS for this.Tara |
 |
|
|
pcapazzi
Starting Member
2 Posts |
Posted - 2005-04-05 : 11:36:04
|
| I'm having trouble connecting SQL Server 2000 to a Notes Domino server as a linked server. I have created an ODBC entry that works with MS Access. I can browse the tables and pull data. When I create a Linked Server entry in SQL 2000 it freezes Enterprise Manager. Any suggestions would be greatly appreciated.SQL 2000 has SP3 installed and ODBC is using the latest NotesSQL driver (downloaded from IBM site yesterday).I used this as a guide:http://www.databasejournal.com/features/mssql/article.php/3462011Here's the properties of the linked server:My linked server properties areProvider Name: Microsoft OLE DB Provider for ODBC DriversProduct name: Tracking_System {copied from dsn name}Data source: Tracking_System {copied from dsn name}Provider String/Location/Catalog: {null}Security Tab - use this security context: (Notes user ID - fully qualified) and my password - the same info I used to create ODBC which worked.Server Options: Data Access and Use Remote Collation are the only items checked... timeouts are both zero |
|
|
|
|
|
|
Importing data from Lotus Notes into SQL Server