Member Avatar for Sawe
Sawe 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 66 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.