OraFAQ Forum: Windows » OLE DB Connect VB

Home » Infrastructure » Windows » OLE DB Connect VB - Oracle 7.3.4 (HPUX)

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

OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101245]

Mon, 05 July 2004 03:09

Sharanamma
Messages: 3
Registered: July 2004

Junior Member

I'm trying to connect to Oracle 7.3.4 (HPUX) from VB 6.0 using OLE DB.

dim con as new adodb.connection

con.open "provider=MSDAORA;data source=oracle73;uid=moon;pwd=lunar"

I get --- ORA-01004: default username feature not supported; logon denied

i need directions and/or suggestions

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101438 is a reply to message #101245]

Thu, 30 September 2004 19:39

deepak gupta
Messages: 1
Registered: September 2004

Junior Member

hi
please send me the brief idea about oledb.
thanx

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101575 is a reply to message #101245]

Fri, 17 December 2004 11:36

Mahmoud
Messages: 5
Registered: November 2001

Junior Member

hello
i need help
hoo can i make a conniction between orcale and vb6

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101576 is a reply to message #101575]

Fri, 17 December 2004 18:29

Sharanamma
Messages: 3
Registered: July 2004

Junior Member

hello
i need help
hoo can i make a conniction between orcale and vb6

declear object variale
con as ADOSB.Connection
declear Record set variale
rs as ADODB.RecordSet

in form1_load write the code
Con.Open "UID=username;PWD=password;DRIVER={Microsoft ODBC for Oracle};SERVER=oracle73;"

if ur specifying server name then no nedd of DSN name in the Connection string ,Otherwise u have to include the DSN name int he Connection string .

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101577 is a reply to message #101575]

Fri, 17 December 2004 18:31

Sharanamma
Messages: 3
Registered: July 2004

Junior Member

hello
i need help
hoo can i make a conniction between orcale and vb6

Reply

declear object variale
con as ADOSB.Connection
declear Record set variale
rs as ADODB.RecordSet

in form1_load write the code
Con.Open "UID=username;PWD=password;DRIVER={Microsoft ODBC for Oracle};SERVER=oracle73;"

if ur specifying server name then no nedd of DSN name in the Connection string ,Otherwise u have to include the DSN name int he Connection string .

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #149973 is a reply to message #101245]

Mon, 05 December 2005 20:11

RedRabbit
Messages: 1
Registered: December 2005

Junior Member

Sharanamma wrote on Mon, 05 July 2004 03:09

i have met a similar problem in ASP before.
finally solve like this:
conn = "Provider=MSDAORA; " & "Data Source=scrbd;"
objConnection.Open conn, Session("username"), Session("password")

but i dont why Smile

who kown more , email me please

Report message to a moderator

Re: OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #150079 is a reply to message #149973]

Tue, 06 December 2005 03:05

sauravda
Messages: 2
Registered: December 2005
Location: KOLKATA

Junior Member

use 'ADMIN' as username and password and try to connect.

saurav das

Report message to a moderator

Previous Topic:	OEM on windows 2000 professional
Next Topic:	Oracle 10g beta at Win XP SP 2- Install-memory problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 02:30:26 CST 2025