LCConnection problem - it worked on 6.5

HCL Domino Domino Forum
1

Hi,

I have a problem with our recently installed Domino 8 server. I have the next code :

Dim conexiune As New LCConnection(“trace”)

Call SeteazaParametri(conexiune)

…

Where SeteazaParametri is:

Sub SeteazaParametri(c As LCConnection)

c.ConnectorName="oracle8"

c.server = "server/serv"

c.UserID= "IDUser"

c.Password= "Pass"

End Sub

This code worked on 6.5 , but since the upgrade to domino 8 server ( with server oracle 10.2.3. and oracle client 10g) i have some errors:

1.Error: Cannot find Connector, Connector ‘trace’ at line

Sub SeteazaParametri(c As LCConnection)

  1. If I set

Dim conexiune As New LCConnection(“oracle8”)

I received Error: Cannot find Connector ‘oracle8’ at line : Dim conexiune As New LCConnection(“oracle8”)

  1. If i have :

Dim conexiune As New LCConnection(“trace”)

Call SeteazaParametri(conexiune)

…

Where SeteazaParametri is:

Sub SeteazaParametri(c As LCConnection)

c.ConnectorName="trace"

c.server = "server/serv"

c.UserID= "IDUser"

c.Password= "Pass"

End Sub

I received error :

Instance member SERVER does not exist

Very strange is that exactly this code worked on 6.5.

The new Domino Server (8) was installed on a new server, so it wasn’t really an upgrade.

I think I have to install someting else on server but I don’t know exactly what.

Do u know what can be the problem?

Thanks.

2

Subject: 64 Bit

I forgot something:

Is a 64 bit Domino Server. I read that here is a problem to connect to ODBC. Is that true?

3

Subject: cannot find connector

I have exactly same problem on a notes client.

I have windows xp machine, with oracle 8 client software. ndctest to oracle works fine.

I have a notes 8.0.1 client, uppgraded it to a 8.0.2. all lss files and dcx files are there.

I have an agent which creates a connection to an oracle server, using the next line,

Set oracleConnection = New LCConnection(“oracle8”)

But the agents stops at this line and I get an error Cannot find connector ‘oracle8’

My notesclient is installed in c:\notes and the data files are in c:\notes\data

Does anyone has a solution for this problem?

4

Subject: installed client versie 9 and it works now

our oracle server is version 8, our domino server/notes client is 8.0.1.

our clients used oracle client 8 in the past with notes 5 client to make an lcconnection.

creating an lcconnection worked then, but it doesn’t work with notes 8.0.1 anymore (even though ndctest results without an error)

after upgrading the oracle client to version 9, the lcconnection works again.