Friday, March 30, 2012
I get "Error 2245 while trying to do NetUserAdd operation"
I tried installing MSDE 1 and 2 on my system but whenever I try to install it, it come up with the error:
"Error 2245 while trying to perform operation NetUserAdd"
I don't understand why this happens. Can anyone help? I've used msde successfully before but this is a new problem recently. I have an AMD 2600+, with Windows XP Pro, 512 MB RAM.
Any help would be greatly appreciated
Thanks
hi,
"Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> Hi all,
> I tried installing MSDE 1 and 2 on my system but whenever I try to install
it, it come up with the error:
> "Error 2245 while trying to perform operation NetUserAdd"
> I don't understand why this happens. Can anyone help? I've used msde
successfully before but this is a new problem recently. I have an AMD
2600+, with Windows XP Pro, 512 MB RAM.
> Any help would be greatly appreciated
> Thanks
>
perhaps it's an AD relate problem... please have a look at
http://tinyurl.com/5ewol
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for that suggestion.
I have read the link and tried using a longer password but it does not help and I still get the same error. Any other advice please?
Thanks
"Andrea Montanari" wrote:
> hi,
> "Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
> news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> it, it come up with the error:
> successfully before but this is a new problem recently. I have an AMD
> 2600+, with Windows XP Pro, 512 MB RAM.
> perhaps it's an AD relate problem... please have a look at
> http://tinyurl.com/5ewol
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Monday, March 26, 2012
i cant understand how to perform file attachment to SQL2000
Hi!
i can't understand how to perform file attachment to SQL2000:
<connectionStrings>
<add name="SimpleListsConnectionString" connectionString="Data Source=local;AttachDbFilename=SimpleLists.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Server return error:
error 602: could not find row in sysindexes for database
run dbcc checktable on sysindexes
Can any body help?
Sorry its my mistake.
Remove question.
i cant start page to perform
this is my code:
1myconnection =new SqlConnection(kiemtraloi,chuoiketnoi);2mycommand.Parameters.Add(new SqlParameter("@.mancc",SqlDbType.VarChar,10));3mycommand.Parameters["@.mancc"].Value = TextBox1.Text;4myconnection.Open();5myreader = mycommand.ExecuteReader();6if(myreader.HasRows)
And when I click to start button, a error appear:
NO overload for method 'sqlconnection' takes '2' arguments
I don't know what i must do :(, please help me
thx
Is that all you have or do you have more code? Where is the SQL statement? and the command object?|||string chuoiketnoi = System.Configuration.ConfigurationSettings.AppSettings["myconn"];
System.Data.SqlClient.SqlConnection myconnection;
System.Data.SqlClient.SqlCommand mycommand;
System.Data.SqlClient.SqlDataAdapter myadapter;
System.Data.SqlClient.SqlDataReader myreader;
System.Data.DataSet mydataset;
// khai bao chuoi cho maytinh
string selectquery = "Select * from maytinh";
string insertquery="Insert into maytinh(mamay) values(@.mamay)";
string updatequery="Update maytinh set mamay=@.mamoi where mamay=@.mamay";
string deletequery = "Delete from maytinh where(mamay=@.mamay)";
// khai bao chuoi cho nhacungcap
string selectnhacungcap="Select * from nhacungcap";
string insertnhacungcap="Insert into nhacungcap(mancc,tenncc,diachi,dienthoai) values(@.mancc,@.tenncc,@.diachi,@.dienthoai)";
string updatenhacungcap="Update nhacungcap set mancc=@.manccmoi,tenncc=@.tennccmoi,diachi=@.diachimoi,dienthoai=@.dienthoaimoi where mancc=@.mancc";
string deletenhacungcap="Delete from nhacungcap where(mancc=@.mancc)";
string kiemtraloi = "Select * from nhacungcap where mancc=@.mancc";
|||That's because the constructor of SqlConnection class only takes 0 or 1 argument, but you pass 2 arguments to it:
myconnection =new SqlConnection(kiemtraloi,chuoiketnoi);
Why did you pass 2 strings to the constructor?
|||I think he wants:
myconnection=new SqlConnection(chuoiketnoi);
mycommand=new SqlCommand(kiemtraloi,myconnection);
sql