File DSN

Results 1 to 2 of 2

Thread: File DSN

  1. #1
    Vivek Nama Guest

    Default File DSN

    What connection string to provide to open a ADO connection using a local file DSN?could you please give an example

  2. #2
    Vivek Nama Guest

    Default File DSN not accessible from an ASP page

    I am able to use file dsn inside a VB program but the same is unusable on an ASP page <BR> The error reported is as follows:<BR>Provider error &#039 800a01b0&#039 <BR>File name or class name not found during Automation operation<BR>_____________________________________ ______________<BR>The code is as follows<BR>_______________________________________ ____________ <BR><BR> &#060;% @language=vbscript %&#062;<BR> &#060;% dim rs<BR> dim Myconn<BR> dim st<BR> st = "FILE NAME=\AnotherMachine estADOpubs.dsn" <BR> set Myconn = server.createobject("ADODB.Connection")<BR> Myconn.open st,"username","passwaord"<BR> set rs= server.CreateObject("ADODB.Recordset")<BR> rs.Open "select * from titles",myconn<BR> %&#062;<BR> &#060;%= rs.Fields(2).Value %&#062;

Posting Permissions

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