table adapter login fails

[tcl4p]

I set up a new dataset linked to a table. When I open the dataset I can preview the data, but the first time I opened the dataset I was asked for the password to access the data. It also asks if I want to save the password, which I checked. However when I try to use the dataset's table adapter in code, when it hits the GetData() method, I get a login failure. Note, I don't get any compile errors, this is a run time error.
Does anyone know why this is happening since once the password was set I could view the data? If this is a problem, is there any way to set the password in code?

Thanks,
Tom

Here's the code. I'm using it to bind to a telerik datagrid.

Dim ds2a As New ds2TruckTableAdapters.TruckTableAdapter
Dim template As GridViewTemplate = New GridViewTemplate
template.DataSource = ds2a.GetData()

 

[jmcilhinney]

I would suggest that you examine the exception carefully to see if the password is actually the problem.

 

[cjard]

If this is a problem, is there any way to set the password in code?

Post the connection string youre using - it's in the Settings for the project

Someone will tell you how to add the password into it