Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Posts
    36

    Unanswered: [ODBC Driver Manager] Data source name not found and no default driver specified

    Hi
    I am frefrring a file
    using #Include file
    IN that file i have defined database connection string

    Proceedure Library - Proc.asp
    Dim ConnString
    ConnString = "server=xxxx;uid=sa;pwd=admin;initial catalog=xxxx"

    then in the file i am referring it

    <% @language = "VBScript"%>
    <!--#Include File="adovbs.inc"-->
    <!--#Include File="proc.asp"-->

    <html>
    <head>

    when i try to open the connection using

    set conn1=server.createobject("adodb.connection")
    conn1.Open ConnString

    It throws the error

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    I am not able to trace it
    All the files are in same direcory
    please help me out
    Thanks
    Ravi

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    move the include to be in between the <head> tags.
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Also, what does
    Code:
    Response.Write(ConnSTring)
    yeild/?
    George
    Home | Blog

Posting Permissions

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