I am unable to connect to Access database using dsn less <BR><BR>conn = "driver = Microsoft Aceess (*.mdb), dbq = path of database.<BR><BR>but thro ole db provider it is working fine. i.e<BR>conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= c:sam estsamtest.mdb"<BR><BR>While reverse is case in SQL server. I am unable to connect to sql server using OLE db provider<BR><BR>&#039dsn less sql server connection using OLE DB not working<BR>&#039strconn = "Provider=SQLOLEDB;Data source= :sam estsamtest.mdb"<BR><BR>&#039Dsn less connection for SQL server working<BR>strconn = "Driver={SQL Server};Server=SamirM;uid=sa;pwd=;database=pubs"<B R><BR>Can some one point out where Error is<BR>