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

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

Contact Us
Site Map

Search

Web
aspfaq.com
tutorials.aspfaq.com
databases.aspfaq.com

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." 
    else 
        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>;" & _  
        "Password=<pwd>"  
 
    set conn = CreateObject("ADODB.Connection") 
    conn.open connStr 
 
    SQL = "SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA" & _ 
        " WHERE CATALOG_NAME='" & databaseName & "'" 
 
    set rs = conn.execute(sql) 
 
    if not rs.eof then 
        response.write("Database exists.") 
    else 
        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...