Hi,
I'm currently working on an Access database. I also have a Lotus Approach database which I need to connect to via .Net.

I want to write a simpel program that copies data each night.
Writing the program isn't a problem, as soon as I have a decent connection/connection string. I've tried the .udl trick for retreiving the string but no luck.
Is it possible to create a connection and how do you do it ? When I have a connection, do the same ADO principles still apply for Approach?

Kind regards

Joeri Konings

I'm not familiar with Lotus applications but this might help you get started:

http://www.connectionstrings.com/?carrier=lotusnotes

-Peter

Thnx! This was just what I needed. Now I only hope the programming isn't too hard.

Glad that worked!

When you connect to Lotus using the System.Data.Odbc classes then you'll be able to use the standard .NET data behaviors I would imagine and it should be pretty straight forward. Of course, you'll have to figure out the details of what kind of queries you can execute and such that is specific to Lotus. But handling the data using DataTables and DataReaders will be similar to SqlClient and the other ADO.NET classes.

-Peter