dsn

Hi

I calling crystal report into vb6
for that i want to create the dsn from system
Can anybody help how to create dsn from vb6.

'connection to database for entry moudle
Public Sub Data_connect()
Dim loadMdb As String
loadMdb = App.Path & "\gold.mdb"
Set Conect_Database = New ADODB.Connection
Conect_Database.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & loadMdb 'Without Password
'Conect_Database.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & loadMdb & ";Jet OLEDB:Database Password=SKM;" 'With password (skm)
Conect_Database.Open
End Sub


Thanks

You don't need it if you are using ADO with Access.
You can open MDB files directly.

Are you looking to create a DSN or USE a DSN?

I want to create a dsn through vb code.
(for SQL Server 2000 & Access2000)


thanks

Quote:

---

Originally Posted by asm

I want to create a dsn through vb code.
(for SQL Server 2000 & Access2000)


thanks

---

Quick search on http://groups.google.com/groups?q=vb+create+dsn

with this nice link.
http://support.microsoft.com/Default.aspx?id=184608