|
Posted by DanWeaver on 02/14/07 17:15
> Do you have any particular reason you want to use SQL authentication?
> Else, change "uid=sa;pwd=" to "Integrated Security=SSPI".
Thanks, Erland. That helped move me on- in fact the first time I tried
it it seemed to work (though my record was not added- posibly as there
already existed a record with same id) Anyway- I cant experiment with
that cos shorlty after I could no longer connect- seems strange- I
checked the table after first successful run to see if it had updated
and ran the code again- got a message "another process is locking the
db"- great I thought- all is working- and closed the connection in
VS-
now though the connection gets stuck at login and says:
Cannot open database "pubs" requested by the login. The login failed.
Login failed for user 'KRISLAPTOP\Kris'.
Navigation:
[Reply to this message]
|