Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Connecting to 7.3.4 from VB 6/W2K Term Server
I am having problems with connection from VB program (VB 6.0, Visual Studio
6.0/SP 5) to an Oracle 7.3.4 server. The VB program is running on a Windows
2000 Terminal Server with Citrix installed; I am seeing the connection
difficulty now, though, running directly from the Terminal Server console,
without using Citrix.
The Terminal Server has the Oracle 8.0.6 client installed on it, and the Oracle ODBC driver (v. 8.0.66.00) is installed and I am able to create a data source using this driver and access the database using Microsoft Access. We have another W2K terminal server similarly configured (as best I can tell, anyway), and we are able to access the database successfully from it using the following connect string:
"Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User
ID=*****;Extended
Properties=""DSN=CONT42;UID=*****;PWD=*****;DBQ=CONT42;DBA=W;APA=T;EXC=F;FEN
=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI
=F;CSR=F;FWC=F;PFC=10;TLO=0;"""
This does not work from the new terminal server. We have also tried the
following connect string, using the data source created for and successfully
used by MS Access:
"Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=*****;Data Source=CONT42"
In either case, within VB, when watching the connection object, I see two errors in the ADO connection's ERRORS collection when I attempt to open the connection. Here are these error details:
Error 1 = : Number : -2147217887 : Long : frmConTest.ConnectDB : Description : "Multiple-step OLE DB operation generated errors.Check each OLE DB status value, if available. No work was done." : String : frmConTest.ConnectDB
Error 2 = : Number : -2147217887 : Long : frmConTest.ConnectDB : Description : "Provider does not support the property." :String : frmConTest.ConnectDB
On the database server, I have turned on User level tracing on the Server through the TRACE_LEVEL_SERVER variable in SQLNET.ORA, and here is a sample trace file:
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
TRACE_LEVEL_SERVER = USER
names.directory_path = (TNSNAMES)
TRACE_DIRECTORY_SERVER = C:\ORANT\NETWORK\TRACE
name.default_zone = world
names.default_domain = world
TRACE_FILE_SERVER = SRVR
--- PARAMETER SOURCE INFORMATION ENDS ---
As you can see, I'm getting an error 3111 from Oracle, and this is what the documentation has to say about error 3111:
ORA-03111 break received on communication channel
Cause: A break was processed on the communications channel, but was not
properly handled by SQL*Net software. This is an internal error message not
usually issued.
Action: Contact customer support.
Anybody have any ideas before I take the documentation's recommended course of action?
Thanks in advance,
Scott Ashby
Swedish Match North America
scott.ashby_at_smna.com
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Oct 24 2002 - 05:55:51 CDT