ODBC connect VB - Personal Oracle 8

From: Pierre Gagnon <pgagnon_at_profitkey.com>
Date: Mon, 28 Feb 2000 09:17:33 -0500
Message-ID: <38ba83ca.0@news.profitkey.com>

I'm trying a connection to Personal Oracle 8 using my System DSN in VB..

Set mCon = New ADODB.Connection

'sConnStr = "DSN=OraLink;UID=pkdb726;PWD=pkdb726;"
'sConnStr = "UID=pkdb726;PWD=pkdb726;DRIVER={Oracle ODBC

Driver};SERVER=spooky;"


    'sConnStr = "Provider=MSDAORA.1;UserID=pkdb726;DataSource=spooky;Persist


Security Info = False;"

'sConnStr = "ODBC;DATABASE=pkdb726;UID=pkdb726;PWD=pkdb726;DSN=OraLink;"
sConnStr = "DSN=OraLink;DBQ=spooky;UID=pkdb726;PWD=pkdb726;" mCon.Provider = "MSDAORA.1"
mCon.Open sConnStr

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

i need directions and/or suggestions Received on Mon Feb 28 2000 - 08:17:33 CST