Database connection

itHighway · March 14th, 2009, 05:04 PM

Hello,

I have a form where a user provide database connection info and than click "Test" button to check if given database info is correct or not.

If database is MS Access then user provides database name and path and if it is Sql Server than user provides sql server connection info.

Is there any command or script that check database connection info and find whether info provided by user is correct or not?

Thank you,

Old Pedant · March 16th, 2009, 04:28 AM

Ummm...just try to make the connection and test to see if it worked or not???

Code:

Set conn = Server.CreateObject("ADODB.Connection")
On Error Resume Next
    conn.Open "...user supplied connection info goes here ... "
    If Err.Number <> 0 Then
        Response.Write "Invalid connection information"
    End If
On Error GoTo 0
...

???

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database Connection to Access Database	reachsevar	ASP.NET 2.0 Basics	1	November 28th, 2007 08:56 AM
Database Connection	kapi.goel	SQL Language	2	February 14th, 2006 07:01 PM
Database connection	fogofogo	Classic ASP Professional	2	December 1st, 2005 12:45 PM
Need help w/ Database connection	brkd63	Dreamweaver (all versions)	1	August 5th, 2004 01:14 AM