List Database names of by Driver type and server name using ADO.

by Ustes Greenridge (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Sun 23^rd January 2000
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate List Database names of by Driver type and server name using ADO.




Dim cn As New ADODB.Connection
Dim rsSchema As New ADODB.Recordset
Dim ConnStr As String

ConnStr = "driver={" & strDriver & "};"
ConnStr = ConnStr & "server=" & strServer & ";"
ConnStr = ConnStr & "uid=sa;pwd=;"

cn.ConnectionString = ConnStr
cn.Open

Set rsSchema = cn.OpenSchema(adSchemaCatalogs)

Do Until rsSchema.EOF
  cboToFill.AddItem rsSchema!Catalog_Name
  rsSchema.MoveNext
Loop

End Sub

Download this snippet Add to My Saved Code

List Database names of by Driver type and server name using ADO. Comments

No comments have been posted about List Database names of by Driver type and server name using ADO.. Why not be the first to post a comment about List Database names of by Driver type and server name using ADO..

List Database names of by Driver type and server name using ADO.

List Database names of by Driver type and server name using ADO. Comments

Post your comment

Difficulty