Dear Friends, I have been using MS Access as the backend and presently I have planned to use SQL Server as the back end. The connecting string to MS ACCESS is cmd = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & CurDir & "\Data\mr_data6.mdb;Uid=Admin; Pwd=abc" Set cn = New ADODB.Connection cn.ConnectionString = cmd1 cn.Open In the case of SQL SERVER how do i connect. Can you help me. Thanx in advance. Regards Malini

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=yourdatabasename;Data Source=yourdataservername

If we're talking about ADO? then I find this website excellent for example connection strings. It shows different ways including DSN based strings, one's that include username and password rather that Intergrated Security. It also covers all major database formats: http://www.able-consulting.com/ADO_Conn.htm