Login failed for user

Hi All

I am using MSDE2K and an application written in VB6

After installing MSDE and my program on to a new computer I am having
strange problems when saving data which I didn't get on the old computer

My connection string is...

cn.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=False;User
ID=Tramcars;Password=ga711bm;Initial Catalog=Tramcars;Data Source=(local)"

(User ID Tramcars exists in MSDE and is included in the db_owner role)

This connects me OK and allows me to enter new data and save

On creating a new entry and attempting to save again I get the message
'Login failed for user Tramcars'

If I set 'Persist Security Info=True' in the connection string, all works
fine

I am completely lost

Any ideas??


Regards
Steve



.