asp and oracle

Results 1 to 2 of 2

Thread: asp and oracle

  1. #1
    Join Date
    Dec 1969

    Default asp and oracle

    I am trying to create a table from asp heres the code <BR><BR>dim cn<BR>dim rs<BR>dim cnstr<BR>set cn = server.CreateObject("ADODB.Connection")<BR>set rs = server.CreateObject("ADODB.Recordset")<BR>cnstr = "Provider=MSDAORA.1;User ID=xxxx;Data Source=xxxx;Persist Security Info=False"<BR>cn.Open cnstr,"xxxx","xxxx"<BR>dim query<BR>query = "create table xxx( said number(10), add varchar2(30))"<BR>cn.Execute query<BR>Response.Write "Table Created Successfully"<BR><BR>but i get a error <BR><BR>Microsoft OLE DB Provider for Oracle error &#039;80004005&#039; <BR><BR>Error while trying to retrieve text for error ORA-12154 <BR><BR><BR>Is this a code problem or oracle problem ..<BR><BR>brij <BR>

  2. #2
    Join Date
    Dec 1969

    Default This looks suspect to me

    cnstr = "Provider=MSDAORA.1;User ID=xxxx;Data Source=xxxx;Persist Security Info=False" <BR>cn.Open cnstr,"xxxx","xxxx" <BR><BR>Try this<BR><BR>cnstr = "Provider=MSDAORA;Data Source=yourTNSname;User ID=yourDBid;Password=yourdbpasswd" <BR>cn.Open cnstr<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts