Home » Infrastructure » Windows » OLE DB Connect VB - Oracle 7.3.4 (HPUX)
OLE DB Connect VB - Oracle 7.3.4 (HPUX) [message #101245] Mon, 05 July 2004 03:09 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
RedRabbit
Messages: 1
Registered: December 2005
Junior Member
Sharanamma wrote on Mon, 05 July 2004 03:09

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


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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 02:12:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.