
February 18th, 2004, 08:47 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
DTS & Lotus Notes via ODBC
Hello,
I am quiet far in setting up a DTS connection between a Lotus Notes database and SQL-DTS. I am stuck at the moment where I need to access the Lotus Notes Database via a SQL-query.
If a database is called "RBS Test" and the ODBC connection (local machine) is called "RBS M10" and the table (form) is called "fo_Person" how do I do an insert?
These did not work:
Insert into [fo_person]
Insert into [RBS M10].[fo_person]
Insert into [RBS Test].[fo_person]
Maybe the spaces are a problem?
Thanks for helping me here!
Bye, Bert.
|