Posted by: Athanasios Papadopoulos
I am connecting to two servers via VPN connection.
The software works properly exchanging data between the two servers but when
disconnecting the cursors I get tn 00184 error
Software in CTD 3.1 PTF 2
SqlBase 8.5 PTF3 in both sites. I have patched the installed database with
pt3 assuming that it includes the ptf1 and ptf2.
- Site Admin
- Posts: 2368
- Joined: 04 Mar 2017, 18:34
- Location: Palm Springs, California
Posted by: Jeff Luther
Strange! error 184 is:
00184 SQL ISN Invalid server name
Reason: The specified database server name is not valid.
Remedy: Correct the database server name. The maximum length of a server name
is 8 characters and must begin with a letter and cannot contain special characters.
(I just used an older version of DBERROR to get this info.)
I would think this error might occur on connecting a handle, not DISconnecting.
I don't have v8.3 or v3.1 but I'd use Animate to highlight the error (you could
break and turn on animate in the SAM_SqlError and single-step back to your SAL
code where the error occured) just to sure the error is occuring where/when you
think it is.
(For example: I could see a coding bug where a SqlConnect() was--incorrectly--called
and SqlDatase was a null string.)
Jeff Luther/PC Design
Posted by: Jim McNamara
8.5 no PTF threw this error if you connected to db's on different servers,
disconnected one, then tried to connect again. That was fixed in PTF1.
Haven't tested for what you are experiencing.
BTW - PTF's are cumulative so 3 includes 1 & 2 fixes.
Who is online
Users browsing this forum: [Ccbot] and 0 guests