Unable to connect to SQL Server

<i><b>Originally posted by : confusious (aditya@axiomsys.com)</b></i><br />I just migrated to SQL Server from Access.<br />But now I can not connect to the SQL Server <br />tables from my ASP code.<br />Here is what I am using :<br />Set oConn = Server.CreateObject("ADODB.Connection")<br />oConn.Open "DATABASE=clients;DSN=MasterDb;UID=sa;Password=;"<br />[MasterDb is my new system DSN for the imported database]<br />I get :-<br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br />[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'clients'. Login fails<br /><br />Seems it has got something to do with my databases' security settings or some option setting while creating the system DSN. <br /><br />I am stuck here for nearly a day. Badly need help!<br /><br />...Thanks<br />...Confusious<br />

<i><b>Originally posted by : confusious</b></i><br />Well, I fixed the error.<br />I was trying to open the 'clients' table before<br />opening my database! Thanks to u all anyway!<br /><br /><br />------------<br />confusious at 4/4/2000 10:39:55 AM<br /><br />I just migrated to SQL Server from Access.<br />But now I can not connect to the SQL Server <br />tables from my ASP code.<br />Here is what I am using :<br />Set oConn = Server.CreateObject("ADODB.Connection")<br />oConn.Open "DATABASE=clients;DSN=MasterDb;UID=sa;Password=;"<br />[MasterDb is my new system DSN for the imported database]<br />I get :-<br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br />[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'clients'. Login fails<br /><br />Seems it has got something to do with my databases' security settings or some option setting while creating the system DSN. <br /><br />I am stuck here for nearly a day. Badly need help!<br /><br />...Thanks<br />...Confusious<br />