Hi,
I'm using username & password in my connectionString to connect my program (C#.net) with Sql Server 2005..
I put in defualt value in one feild: user_name()
it replace the user: dbo, not the user which I used in my connectionString.
so.. how to get this user?
I tried to put: currnet_user
but I get the same result, "dbo" not the user in my connectionString..
I tried SESSION_USER, it gave the same result :(|||
This is my connectionString:
connectionString="Provider=SQLOLEDB;Data Source=LEWEHSBF\LEWEENG;Persist Security Info=True;Password=HsBfL4w4;User ID=Lewe;Initial Catalog=MyDatabase"
|||I think the resone is the user I which I used in myConnectionString, is Admin user, I tried with "dataread, datawrite" user and its worked..
Thank you myself
No comments:
Post a Comment