Connection string

[puitar]

I need to test a Lotus Notes ODBC connection from asp.
I have named the ODBC system data source 'LotusTest'

The error reads....

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Lotus][ODBC Lotus Notes]Unable to find path to server
/connectiontest/connectiontest.asp, line 12

my code includes......


<%
dim myConn
set myConn = server.createobject(&quot;ADODB.Connection&quot

myConn.Open &quot;LotusTest&quot;

If myConn.state = 1 then
response.write(&quot;Connection opened successfully<p>&quot
else
response.write(&quot;Error. Connection could not be opened.<P>&quot
end if

myconn.close
set myConn = Nothing

%>


help me please

 

[Microbe]

It looks like you do not have the data source defined.

You need something like myConn.Open &quot;DSN=LotusTest&quot; assuming that you have it set up like that.

I am not sure of the driver needed for Lotus. Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au