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
...

???