Issue with VB6 ADO on vista

Hi,

I am having a vb6 application with sql server 2005 database. It works fine on windows xp. But when i install the application on windows vista I am getting Adodc error "login failed for user sa". Still the forms are populated with data from the database. But the event handlers dosent seem to work after i get this error. Does someone know what caused that adodc error. I have disabled User account control for the vista installation.

Vinith

Hi Vinith.

I'm not sure what Adodc but could you please report the complete error message and the associated error message logged to the server's error log. Please take a look at this webpage for more info: http://msdn2.microsoft.com/en-us/library/ms366351.aspx

Thanks,

Il-Sung.

|||

There was a change in Vista to be more secure in terms of credental propagation. Without more details it is hard to say if this is the case for you.

Try adding

Persist Security Info=True

to your connection string and see if your application is affected by that change.|||

Hi Il Sung and Anton,

I have given persist security info=true and it seems to have solved my problem.

I have kept my connection in an ADOCD connection object. I was using that object when ever i needed database connection. The password was not getting persisted in the connection object. ie before executing if i checked ADODC.connectionstring it didnt contain password information. And that caused the message login failed for user sa.

However this problem occured only when the application runs on vista. With XP it worked fine. Anyway by giving Persist Security Info = true in vista connection string the problem is solved and the password is persisted.

Thanks a lot

Vinith