SQL connection on other server

HCL Domino Domino Forum
1

Hi…I have to connect lotus notes to SQL/MySQL server through Lotus notes. My code is as follows

Dim con As New ODBCConnection

Dim qry As New ODBCQuery

Dim result As New ODBCResultSet

Set qry.Connection = con

Set result.Query = qry

Call con.ConnectTo("IP Address of sql server","username","passwd")

If (con.IsConnected) Then

	Print "Connected to DB... DSN=" & con.DataSourceName

End If

This code does not connect to the SQL server.

ODBC driver has to be installed on LN server? or is there anything else we are missing on??

Our server is running on Linux red hat 5.0

Please help…

2

Subject: You would need an ODBC driver on your server

Since the code is running on your server you would need the ODBC driver on the server.

Howard

3

Subject: Java Agent

If you could create your agent using Java you can use JDBC to handle the connectivity to your MySQL, SQLServer or DB2 RDBMS. I do it all the time and it works great and has been running for years.

Also, you could check into LEI (Lotus Enterprise Integration).