i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login.

ALSO i can login well using the sql server login FROM query analyser and enterprise manager, but cannot do so from VB.NET.

FROM VB.NET, i can drag a data adapter and preview the data by right clicking on the dataset and 'Fill dataset' at design time. but during runtime

sqldaDBGames.Fill(dsMembers,"tblMembers")

this gives me an error

PLease help