SQL 2000 integration with Lotus Notes 6.5

[high100]

Hi Experts

One of my business application is runing from Lotus Notes 6.5.

we get orders in Lotus Notes in DBF type file attachments . once it is there in INBOX automatically it gets download and upload it to SQL Server 2k and then further processes are done.

On SQL Server 2k no NotesSQL driver is found....

Could anyone explain me how it could be manged...so that I can concentrate on related subject.

Thanks in advance...

 

[SQL_Hell]

Hi there,

Can you give me little more information?

This automated process of importing the .dbf files into sql server.....

Is this a process that has been working and is now failing?

Or is this something new you want to set up?

Lotus notes .dbf files are in dbase fomat, which can be imported to sql server using DTS and the dbase odbc driver

 

[high100]

Hi SQL_Hell,

thanks for your valuable reply.

system is still running very fine. Actaully, I hv to setup new system on this basis but the developer of the application is not with us right now.

i m a SAP consultant but really liked the way this application is running & i want to built this system right from scratch on my own..

the flow of system is something like this..
there are many people (users ) at various locations. They run a small application (VB form), fill it up and click on send button. The data is sent via their installed mail client to us (we dont know which client).

The data is received by a dedicated id on LN server.

*here our IT activities start
One VB form is opened and again one button is clicked as SEND/RECEIVE. now this email which has attachment as DBF gets upload to SQL server & the respective mail gets deleted from INBOX...(i m interested in this part particularly. How it happens).
Your hints will help me lot, so that I could study the correct material. It will save my lot of time..

 

[SQL_Hell]

Hi again

Sorry for the late reply, I did actaully answer this the other day but my connection timed out and I lost the text

I cannot be sure exactly how this works without seeing the system, but I can suggest how it probably works


1. custom vb code to extract email attachment and move to file location
2. Call to execute a sql server dts package, which interogates the .dbf file and dumps the contents into a sql server table.
3. Custom Vb code, deletes email once the dts package has registered success.

 

[high100]

Hi there,

You are right Meanwhile, I could able to find some info :

1. Users are sending their requirement as an attachment in dbf file
2. Now after receiving mails in a specific Lotus Notes ID (reserved), one VB form is opened under this there is one Vb code which actually, starts one Lotus Notes AGENT & then the further process happens.

As you say it happens exactly the same, only one LN Agent they have added to it.

Thanks a lot dear for your valuable reply.
Have a nice day.