'Login failed for user' on subsequent saves

26 Aug 2005 8:56 PM

steve

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)
Security mode in MSDE is set to Mixed Mode

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

On 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

27 Aug 2005 7:32 PM

John Bell

Hi

This sounds like you may be re-connecting the connection, rather than
keeping it open?

At a guess the machines are on different MDAC versions and this accounts for
the different behaviour, but I could be wrong!!!!

John

Show quote

"steve" <sfran***@bigpond.net.au> wrote in message
news:%23cIiqCoqFHA.248@TK2MSFTNGP14.phx.gbl...
> 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)
> Security mode in MSDE is set to Mixed Mode
>
> This connects me OK and allows me to save new data once
>
> On 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
>
>
>