database and vb6

How can I attach mdf and ldf files using Visual Basic 6.0?

Help me

See SQL Server Books Online topic

Server.AttachDatabase Method (String, StringCollection)

http://msdn2.microsoft.com/en-us/library/ms210158.aspx

There are many code examples in many languages.

'Connect to the local, default instance of SQL Server.

Dim srv As Server

srv = New Server

Dim owner As String

Dim logstr as String

Dim datastr as String

owner = srv.Databases("AdventureWorks").Owner

'Detach the AdventureWorks database.

srv.DetachDatabase("AdventureWorks", False, False)

'Display information about the detached database.

Dim d As DataTable

Datastr = "C:\Program Files\Microsoft SQL Server"

Datastr = datastr + "\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf"

Logstr = "C:\Program Files\Microsoft SQL Server"

Logstr = datastr + "\MSSQL.1\MSSQL\Data\AdventureWorks_Log.ldf"

d = srv.DetachedDatabaseInfo(datastr)

Dim r As DataRow

Dim c As DataColumn

For Each r In d.Rows

Console.WriteLine("==========================")

For Each c In r.Table.Columns

Console.WriteLine(c.ColumnName + " = " + r(c).ToString)

Next

Next

'Check whether the file is a detached primary file.

Console.WriteLine(srv.IsDetachedPrimaryFile(datastr))

'Attach the database

Dim sc As StringCollection

sc = New StringCollection

sc.Add(datastr)

sc.Add(logstr)

srv.AttachDatabase("AdventureWorks", sc, owner, AttachOptions.None)

|||

i m making project in vb 6.

i need to make the database connectivity.

however the object used for it (database object) is not availabe in my version.

there is a data object instead having properties like database and connection.

can u please tell me another way to connect to the database.

also can u please tell me how to use the connection and command object.

thanks