DSN less connection to db

Results 1 to 2 of 2

Thread: DSN less connection to db

  1. #1
    Join Date
    Dec 1969

    Default DSN less connection to db

    Hi,<BR>I&#039;m trying to connect to an Oracle 9i database using DSN less connection.<BR>Here is the code that I&#039;m using.<BR>But I get an error saying that:<BR>ADODB.Connection (0x800A0E7A)<BR>Provider cannot be found. It may not be properly installed.<BR><BR><BR><BR>&#060;% <BR>set conn = server.CreateObject("ADODB.Connection")<BR>conn.Op en("Provider=OraOLEDB.Oracle;Data Source=ztfdata;Port = 1521;DB = ztfdata; SID = ztfdata; User ID=xxxx;Password=xxxx")<BR>&#039;connstr.Open "ztfdata"<BR>set rs = Server.CreateObject("ADODB.recordset")<BR>rs.Open " Select * from lib ",conn<BR>for each x in rs.Fields<BR>Response.Write(x.name)<BR>Response.Wr ite("=")<BR>Response.Write(x.value)<BR>next<BR>%&# 062;

  2. #2
    Join Date
    Dec 1969

    Default I think error msg is clear...

    It&#039;s saying that OraOLEDB.Oracle isn&#039;t available as a provider.<BR><BR>Check your installation instructions for that OLEDB provider and make sure it was installed and tested properly.<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