//  home   //  advanced search   //  news   //  categories   //  sql build chart   //  downloads   //  statistics
ASP FAQ Tutorials

   8000XXXX Errors
   ASP.NET 2.0
   Classic ASP 1.0
      Access DB & ADO
      General SQL Server & Access Articles
      Other Articles
      Schema Tutorials
      Sql Server 2000
      Sql Server 2005
   General Concepts
   Search Engine Optimization (SEO)

Contact Us
Site Map



ASP FAQ Tutorials :: Databases :: General SQL Server & Access Articles :: How do I determine if a database exists?

How do I determine if a database exists?

With Access, you would simply use FileSystemObject's FileExists method to verify the location of the MDB file. e.g.: 
    databaseName = "databaseName" 
    set fso = CreateObject("Scripting.FileSystemObject") 
    if fso.fileExists(server.MapPath("/" & databaseName & ".mdb")) then 
        response.write "Database exists." 
        response.write "Database does not exist." 
    end if 
    set fso = nothing 
With SQL Server, you can run the following query: 
    databaseName = "databaseName" 
    cst = "Provider=SQLOLEDB;" & _  
        "Data Source=<x.x.x.x>;" & _  
        "Network=DBMSSOCN;" & _  
        "User Id=<uid>;" & _  
    set conn = CreateObject("ADODB.Connection") 
    conn.open connStr 
        " WHERE CATALOG_NAME='" & databaseName & "'" 
    set rs = conn.execute(sql) 
    if not rs.eof then 
        response.write("Database exists.") 
        response.write("Database does not exist.") 
    end if 
    rs.close: set rs = nothing 
    conn.close: set conn = nothing 

Related Articles

Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all?
Could I get some help with JOINs?
How can I tell which version of MDAC I'm running?
How do I access MIN, MAX, SUM, COUNT values from SQL statements?
How do I change column order in a table structure?
How do I change the order of columns in a table?
How do I concatenate strings from a column into a single row?
How do I convert columns of values into a single list?
How do I document / compare my SQL Server database(s)?
How do I get the IDENTITY / AUTONUMBER value for the row I inserted?
How do I solve 'ADO Could Not Find The Specified Provider'?
Should I use BETWEEN in my database queries?
Why can't I use the * wildcard in a database search?
Why do I get 'Syntax Error in INSERT INTO Statement' with Access?
Why do I get weird results when using both AND and OR in a query?
Why do some SQL strings have an 'N' prefix?
Why does AbsolutePosition return as -1?
Why doesn't SQL Server allow me to separate DATE and TIME?
Why is Query Analyzer only returning 255 characters?
Why should I avoid NULLs in my database?
How do I deal with an apostrophe (') in a SQL statement?



Created: 8/10/2002 | Last Updated: 3/24/2005 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (145)


Copyright 1999-2006, All rights reserved.
Finding content
Finding content.  An error has occured...