NT Authentication & oo4o OpenDatabase method - OO4O and Wizards(Archived)

I just set up my server and client to use NT Authentication (by using Oracle8i Administrator's Guide
Release 2 (8.1.6) for Windows NT
Chapter 8 'Authenticating Database Users with Windows' #
http://technet.oracle.com/doc/oracle8i_816/nt.816/a73008/ch7.htm#1036322)
It all works fine when connecting with Oracle admin tools or SQL*Plus.
The problem comes when trying to get my existing VB app that uses oo4o to connect to the database. Here's my old code:
Set OraSession = New OracleInProcServer.OraSessionClass
Set OraDB = OraSession.OpenDatabase("net8service", "user/password", 0)
I tried about 100 diff variations (including "") for the username and password but I can't seem to get the connect to work.
Any suggestions would be greatly appreciated.
TIA
Blaise

Related

VB 6 - Oracle(Unix)

I am trying to connect to an Oracle DB on a Unix Box.
My VBApp is on NT Workstation and the Network is a Windows
Network.
VB6 - Oracle 8i - ADO 2.6
My code snippet for the connection is as follows;
cn.Open "Provider=MSDAORA;User
ID=MyUid;Password=MyPwd;Data Source=MyServer;Persist
Security Info=False"
This code returns an error from the workstation;
Error Number = -2147467259
Error Desc = Oracle error occurred, but error message could not
be retrieved from Oracle.
But it works fine when I placed it on the NT Server Machine
runing NT4SP6, my workststion runs NT4SP5,
From my desktop SqlPlus and SqlNavigator connects to the Oracle
DB without problems.
Does anyone one know what the problem here is? Could this be a
problem with Net Libraries on the Work Station
You might try searching microsoft.com for the error number to
see what they say. When we swtiched from ODBC to MS OLE DB
Provider, we had to make changes to Windows Registry:
HKEY_LOCAL_MACHINE\Software\Microsoft\Transaction Server\Local
Computer\My Computer:
In here, we had to change Data for things like OracleOCILib,
etc. so that ADO 2.5 would use correct Oracle 8.1.6 .dll's.
These Registry changes, and other related items, are discussed
at microsoft.com when searching for articles about ADO. MTS and
Oracle.
Hope this helps........

ASP and Oracle 8i

Hi All,
Problem:
I get the following error when I run an simple ASP script connecting to an Oracle 8.1.6 database.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-12638: Credential retrieval failed
/ultradev/sec.asp, line 3
Environment:
Server: Oracle 8.1.6 on W2K Server
Client: Oracle Client on W2K Professional
Webserver: IIS installed on the same machine as Oracle Client.
Net8: Net8 is accurately configured i.e. I can connect to the database using sqlplus.
DSN: I have defined a dsn named ora
Development tool: I am using UltraDev. I am convinced that the problem is not with Ultradev because in design mode I can query the database.. see the tables.. rows... everything! and also because ultimately it writes the following ASP Code in the file
<%#LANGUAGE="VBSCRIPT"%> <%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = "dsn=ora;uid=system;pwd=manager;"
Recordset1.Source = "select * from tab;"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open
Recordset1_numRows = 0
%>
I have tested the dsn using Oracle ODBC Test and it works without any problem.
Any help is gratefully appreciated.
Thanks.
null 
Judging from the error message, I'd suspect that IIS is trying to use some authentication service for the user. Are you using something like a "single sign-on" (Windows NT native authentication, NDS authentication, etc.?
As a test, you could try downloading the Oracle OLEDB driver to see if that solves the problem.
Unfortunately, nothing jumps out at me here as obviously wrong or an obvious path to getting this working.
Justin Cave
ODBC Development 
Did you ever resolve this issue?

Can't connect to remote db ASP Win2K Oracle 9.2

Following is the error I get upon attempt to connect to my remote db server from my ASP script residing on my machine along with my IIS:
Error Type:
OraOLEDB (0x80004005)
???
/portal/auth.asp, line 21
I am using Win2K Server and Oracle 9.0 on the remote machine; Oracle 9.2 Client Tools on my machine. Everything can connect to the db server except for my ADO connection objects via IIS. I don't know what else to do at this point, any suggestions?
Phil
What's at line 21 in the ASP file?
One common problem is a failure to give the IIS user appropriate privs on the Oracle directories. There have been a number of posts recently that go over the permissions that need to be given.
Justin
Phil,
Your posting was helpful, as was Justin's reply.
Granted READ access to Oracle's \BIN directory to Windows 2K account IUSR_YourMachineNameHere and was able to render ASP Pages connecting to Oracle Database utilizing the following connection code. Technologies used are Oracle 9.2.0.1.0, Win2K/IIS 5.0/ASP 3.0. Thank You.
Dim objConn     'set the connection
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString ="UID=YourUserName;PWD=YourPassword;DRIVER={Microsoft ODBC for Oracle};SERVER=YourServerName;"
     
objConn.Open     'open the ADO connection
=============
Tim

Personal Oracle 7.3.4 on XP and Service?

We have a Personal Oracle DB on a XP Pro Pentium IV box. VB is being used to open the DB through the Oracle InProc Server type library, See code below. The Oracle Service has a status of stopped. If we run another aplication written with Oracle Tools the service starts and all works. My question is why doesn't the service automatically kick off throught the code below, and is ther something else I can try in code?
Many thanks,
Mark.
' Workaround to raise a message (and avoid an error) that the user does not have access to SSS
On Error Resume Next
Set objOracleSession = CreateObject("OracleInProcServer.XOraSession")
If Err.Number = 429 Then 'ie: the users do not have the oracle drivers on the PC
Exit Function
End If
Set objOracleDatabase = objOracleSession.dbOpenDatabase("", "testuser/testing", &H0&)
If Not (objOracleDatabase Is Nothing) Then
Set rsRetrievedDynaset = objOracleDatabase.dbCreateDynaset(strSQL, 0&)
' Tidy up
objOracleDatabase.Close
End If 
We had similar problems with Oracle 8.0.6 server running on XP Pro.
The Oracle service was fine and we were able to connect locally on the server (without the listener).
When we tried connecting from another machine on the network we got the message "No Listener".
The Listener service would appear to start but as soon as the first connection attempt was made the Listener service would stop.
We did not pursue it because I believe that only Oracle 9 is certified to be compatible with windows XP.
Regards
Adrian 
Hi,
thanks for the reply...
What I did was switch to ADO and OLEDB for Oracle, works so very little change required.
Cheers,
Mark.

OS authentication - ODP.NET

Hi,
I'm trying to use the OS authentication :
- Server : Oracle 8.1.7
- Client : ODP.NET 9.2 (and parallel Oracle client 8.1.7)
I've configured the database server (remote_os_authent=true / os_authent_prefix = "" and create the user with a role giving access to the db objects - also connect and create session right).
When using sqlplus with 'sqlplus /#myalias', all works fine. When trying an Open on an OracleConnection in .NET (with the connect string : "user id=/; data source=myalias"), I become an exception with the error ORA-01017 (wrong login/password). Using my connection (OracleConnection) starting with an Oracle identified user works fine. I'm probably missing something, could someone give me some hints please ? (I'v also set in registry OSAUTH_PREFIX_DOMAIN to FALSE - as string key).
Thanks 
Try here. Specify / as a user name and see if this works. This has to go on the .net server
http://support.microsoft.com/default.aspx?scid=kb;[LN];306158 
Hi Tony,
Are you trying to use ASP.NET? If yes, you need to add a line <identity impersonate="true"/> inside <system.web> in the file Web.config.
Wing

Categories

Resources