Hi<BR>Can you give sime help on that<BR>Thank in advance<BR>A.K<BR><BR><%@ Language=VBScript %><BR><%<BR> <BR><BR>set conn=server.CreateObject("adodb.connection")<BR>co nn.Open ("Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=127.0.0.1;Persist Security Info=True" ) <BR><BR><BR> <BR>set rec=server.CreateObject("adodb.recordset")<BR> rec.ActiveConnection = conn<BR> <BR> rec.Open "Select * from EMP"%><BR>I get that error message:<BR>=======================<BR>Microsoft OLE DB Provider for Oracle error ' 80004005' <BR><BR>ORA-12514: Message 12514 not found; product=RDBMS80; facility=ORA <BR><BR>/sql_exam/oracle_show_Table.asp, line 8 <BR>
Hi Derek<BR>Thanks for your help<BR>I run the Oracle on my NT<BR>What is the Data Source or the Server name? where I see it<BR>did I have to write 127.0.0.1 or local ? or something else<BR>Thanks in advance<BR>Jenny
Jenny, the Data Source is your network name for the Oracle server. If you don't know what it is, open up the Systems Management control panel (if you have it) and the netbios name will be what you want. If you don't have this control panel, open up the system control panel and click on the user profiles tab. You should be able to get the machine name from one of those entries. You could also get the info from the User Manager Administrative tool. I'd think that local, (local), or localhost would also work but I don't have Oracle on this machine so I don't know for sure. [(local) works for SQL Server.]
I don't recognize that error, but I think your problem lies in using an ip address instead of a network name. (I tried the ip address with sql server and it didn't work.) See my response to Jenny below regarding network computer names.