VB6 Vista Issue

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.



Vinith

Have you ensured that the instance of SQL Server running on the Vista machine has mixed-mode authentication enabled?

Yes the database is having both SQL Server and Windows authentication enabled.

Sounds like there could be permissions issues on the login or is it a common database shared between the two instals?

hai

have you tried xp64 yet?

kthxbye