OraFAQ Forum: Windows » Cannot connect to remote Oracle via VB

Home » Infrastructure » Windows » Cannot connect to remote Oracle via VB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot connect to remote Oracle via VB [message #99696]

Thu, 21 February 2002 10:48

SW
Messages: 1
Registered: February 2002

Junior Member

I am trying to write a VB application that requires to connect to a remote Oracle database but I encoutered the following error message:

TNS-12560: TNS:Protocol adapter error
TNS-00530: Protocol adapter error 32-bit Windows Error:
161 : Unknown Error

I have no problem connecting to the database via SQLPlus.
I turned on the tracer and get the following:

VB6 3c4-5ec ENTER SQLAllocEnv
HENV * 1F70D574

VB6 3c4-5ec EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F70D574 ( 0x040f15c8)

VB6 3c4-5ec ENTER SQLGetEnvAttr
SQLHENV 040F15C8
SQLINTEGER 201 <unknown>
SQLPOINTER [[Unknown attribute 201]]
SQLINTEGER 4
SQLINTEGER * 0x0012B140

VB6 3c4-5ec EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 040F15C8
SQLINTEGER 201 <unknown>
SQLPOINTER [[Unknown attribute 201]]
SQLINTEGER 4
SQLINTEGER * 0x0012B140 (1836932)

VB6 3c4-5ec ENTER SQLAllocEnv
HENV * 1F70D578

VB6 3c4-5ec EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F70D578 ( 0x040f1670)

VB6 3c4-5ec ENTER SQLSetEnvAttr
SQLHENV 040F1670
SQLINTEGER 201 <unknown>
SQLPOINTER [[Unknown attribute 201]]
SQLINTEGER -6

VB6 3c4-5ec EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 040F1670
SQLINTEGER 201 <unknown>
SQLPOINTER [[Unknown attribute 201]]
SQLINTEGER -6

VB6 3c4-5ec ENTER SQLAllocConnect
HENV 040F1670
HDBC * 0012BC14

VB6 3c4-5ec EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 040F1670
HDBC * 0x0012BC14 ( 0x040f1718)

VB6 3c4-5ec ENTER SQLGetInfoW
HDBC 040F1718
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012BBE4
SWORD 22
SWORD * 0x00000000

VB6 3c4-5ec EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 040F1718
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012BBE4
SWORD 22
SWORD * 0x00000000

VB6 3c4-5ec ENTER SQLSetConnectAttrW
SQLHDBC 040F1718
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001
SQLINTEGER -6

VB6 3c4-5ec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 040F1718
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER -6

VB6 3c4-5ec ENTER SQLSetConnectAttrW
SQLHDBC 040F1718
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -6

VB6 3c4-5ec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 040F1718
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -6

VB6 3c4-5ec ENTER SQLDriverConnectW
HDBC 040F1718
HWND 00000000
WCHAR * 0x1F7F8B88 [[ -3]] "****** 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

VB6 3c4-5ec EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 040F1718
HWND 00000000
WCHAR * 0x1F7F8B88 [[ -3]] "****** 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

DIAG [[IM006]] [[Microsoft]][[ODBC Driver Manager]] Driver's SQLSetConnectAttr failed (0)

DIAG [[IM006]] [[Microsoft]][[ODBC Driver Manager]] Driver's SQLSetConnectAttr failed (0)

DIAG [[01S00]] [[Microsoft]][[ODBC driver for Oracle]]Invalid connection string attribute (0)

VB6 3c4-5ec ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 1
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C

VB6 3c4-5ec EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 1
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94 (0)
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C (66)

VB6 3c4-5ec ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 2
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C

VB6 3c4-5ec EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 2
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94 (0)
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C (66)

VB6 3c4-5ec ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 3
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C

VB6 3c4-5ec EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 3
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94 (0)
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C (70)

VB6 3c4-5ec ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 4
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C

VB6 3c4-5ec EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2
SQLHANDLE 040F1718
SQLSMALLINT 4
SQLWCHAR * 0x0012BB78 (NYI)
SQLINTEGER * 0x0012BB94
SQLWCHAR * 0x0012B778 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012BB9C

VB6 3c4-5ec ENTER SQLFreeConnect
HDBC 040F1718

VB6 3c4-5ec EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 040F1718

Report message to a moderator

Re: Cannot connect to remote Oracle via VB [message #99864 is a reply to message #99696]

Thu, 02 May 2002 04:02

David Quinlan
Messages: 2
Registered: May 2002

Junior Member

Hi,

I have had similar problems.

It depends on the connect string you us in VB to open your connection to the Oracle Database.

Using the Microsoft ODBC Driver for Oracle, it doesn't work (although I'm sure it has in the past with MDAC2.5)

Using the Oracle ODBC Driver it works...

Try:

Provider=OraOLEDB.Oracle.1;Password={your password};Persist Security Info=True;User ID={Your User ID};Data Source={Your Data Source}

Regards

David

PDMS Business Solutions

Report message to a moderator

Re: procedure to connect Oracle sql to VB6 [message #99991 is a reply to message #99696]

Mon, 10 June 2002 23:45

mak
Messages: 6
Registered: June 2002

Junior Member

hello
i would aprreciate if u mail me the procedure to connect sql plus with vb
thanks

Report message to a moderator

Re: Cannot connect to remote Oracle via VB [message #100211 is a reply to message #99696]

Mon, 09 September 2002 00:04

somorjit yambemcha
Messages: 1
Registered: September 2002

Junior Member

sir
i am trying to connect vb and oracle.i have an error that give message IM006:[[microsoft]][[odbc]]Drivermanager]]driver's SQLsetconnectattr fail ,i try a lot but i didn't got the solution,and i also installed the oracle8 personel for windows95 &NT to windows 98.is it due to incompatable OS or due to coding,please help in my problem and i will remain you forever if you help me,it is for my project
yours
somorjit

Report message to a moderator

Re: procedure to connect Oracle sql to VB6 [message #100271 is a reply to message #99991]

Fri, 27 September 2002 21:06

chaduthra
Messages: 1
Registered: September 2002

Junior Member

How to connect Oracle with VB Tell me in full detail,Please

Report message to a moderator

Re: Cannot connect to remote Oracle via VB [message #100325 is a reply to message #99696]

Tue, 15 October 2002 04:14

Ashish Moses
Messages: 1
Registered: October 2002

Junior Member

Hi! I am also having the same problem. I would like to know the exact connection string and references to use for an ADO connection. If you have found a way to do it, please reply.

in earnest
Ashish

Report message to a moderator