Help! Upgrade to 702FP1. Cannot create New LCConnection!

Hi all,

We have upgraded from 701 to 702FP1

Now some code that used…

Dim srcCon As New LCConnection (“sybase”)

…does not work!

This is in an agent that is called via RunOnServer, so I have been checking the ODBC Sources on the server.

There is not a system DSN called sybase, so I think this code creates its own. The error occurs on this line, before adding the connection details as follows.

srcCon.Server = “…”

srcCon.Database = “…”

srcCon.Userid = “…”

srcCon.Password = “…”

(example)

I created a system DSN with name “sybase”, but this made no difference.

Unfortunately, the person who designed the code is not with us. Has the upgrade possibly removed some notes.ini settings ?

Any help much appreciated.


Code Extract

Option Public

Uselsx “*lsxlc”

Use “CLASSError”

Sub Initialize

Dim session As New LCSession

Dim srcCon As New LCConnection("sybase")

End Sub

Subject: Help! Upgrade to 702FP1. Cannot create New LCConnection!

ND 6.5.5 & ND 7.0.2 compiled to work with Sybase 15 client

Alternative to upgrading Sybase client is to replace nsybase.dcx with an older version.