Help for this

Question

I use windows server 2008 R2 and sql server 2008. this code no problem can run on windows server 2008 and sql server 2008. But this code can't run on server 2008 R2. I thing protect on power shell 2.0. Maybe. Help for this.

String cs;
System.Data.SqlClient.SqlConnection con;
String querystring;
System.Data.SqlClient.SqlCommand cmd;

cs = "Data Source=*****\\;Initial Catalog=worktemp;User ID=sa;Password=*******";
con = new SqlConnection(cs);

querystring = "SELECT User_name, Password, User_type,Name FROM [users] WHERE User_name=@uss AND Password=@pww";

cmd = new SqlCommand(querystring, con);
cmd.Parameters.Add("@uss", System.Data.SqlDbType.NVarChar).Value = unn;
cmd.Parameters.Add("@pww", System.Data.SqlDbType.NVarChar).Value = pww;

Answer 1

Hi,
  This forum is exclusive for SQL Azure customers. I believe you need help with SQL Server 2008 R2 and hence please post this under http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/

If you can also include detailed error message, it would help us to assist further.

Thanks,
Abi

Answer 2

Also we need detailed error messages on the behaviour your'e seeing.

Answer 3

Sorry, i dont no create new post...

In SQL Server Management Studio 2008 generate bad script in DROP AND CREATE TABLE ->
-----------------------------------
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Firmy_Uzytkownicy]') AND parent_object_id = OBJECT_ID(N'[dbo].[Firmy]'))
ALTER TABLE [dbo].[Firmy] DROP CONSTRAINT [FK_Firmy_Uzytkownicy];

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Firmy_c_date]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Firmy] DROP CONSTRAINT [DF_Firmy_c_date]
END;

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Firmy_m_date]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Firmy] DROP CONSTRAINT [DF_Firmy_m_date]
END

;

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Firmy_id_user]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Firmy] DROP CONSTRAINT [DF_Firmy_id_user]
END;

/****** Object:  Table [dbo].[Firmy]    Script Date: 12/15/2009 10:04:49 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Firmy]') AND type in (N'U'))
DROP TABLE [dbo].[Firmy];

/****** Object:  Table [dbo].[Firmy]    Script Date: 12/15/2009 10:04:49 ******/
SET ANSI_NULLS ON
;

SET QUOTED_IDENTIFIER ON
;

SET ANSI_PADDING ON
;

CREATE TABLE [dbo].[Firmy](
 [IdFirmy] [int] IDENTITY(1,1) NOT NULL,
 [KrotkaNazwaFirmy] [varchar](250) NOT NULL,
 [NazwaFirmy] [varchar](max) NOT NULL,
 [NIP] [varchar](50) NULL,
 [Regon] [varchar](50) NULL,
 [Panstwo] [varchar](50) NULL,
 [Wojewodstwo] [varchar](50) NULL,
 [Miasto] [varchar](50) NULL,
 [KodPocztowy] [varchar](10) NULL,
 [Poczta] [varchar](50) NULL,
 [Adres] [varchar](250) NULL,
 [Telefon] [varchar](250) NULL,
 [Fax] [varchar](250) NULL,
 [Email] [varchar](250) NULL,
 [InternetowyAdres] [varchar](250) NULL,
 [Inne] [varchar](max) NULL,
 [c_date] [datetime] NOT NULL,
 [m_date] [datetime] NOT NULL,
 [id_user] [int] NOT NULL,
 CONSTRAINT [PK_Firmy] PRIMARY KEY CLUSTERED
(
 [IdFirmy] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

;

SET ANSI_PADDING OFF
;

ALTER TABLE [dbo].[Firmy]  WITH CHECK ADD  CONSTRAINT [FK_Firmy_Uzytkownicy] FOREIGN KEY([id_user])
REFERENCES [dbo].[Uzytkownicy] ([IdUser])
ON DELETE SET DEFAULT
;

ALTER TABLE [dbo].[Firmy] CHECK CONSTRAINT [FK_Firmy_Uzytkownicy]
;

ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_c_date]  DEFAULT (getdate()) FOR [c_date]
;

ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_m_date]  DEFAULT (getdate()) FOR [m_date]
;

ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_id_user]  DEFAULT ((0)) FOR [id_user]
;
---------------------------------------------------------------------

its a correct code -->>
----------------------------------
ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_c_date]  DEFAULT (getdate()) FOR [c_date]
;

ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_m_date]  DEFAULT (getdate()) FOR [m_date]
;

ALTER TABLE [dbo].[Firmy] ADD  CONSTRAINT [DF_Firmy_id_user]  DEFAULT ((0)) FOR [id_user]
;

ALTER TABLE [dbo].[Firmy]  WITH CHECK ADD  CONSTRAINT [FK_Firmy_Uzytkownicy] FOREIGN KEY([id_user])
REFERENCES [dbo].[Uzytkownicy] ([IdUser])
ON DELETE SET DEFAULT
;

ALTER TABLE [dbo].[Firmy] CHECK CONSTRAINT [FK_Firmy_Uzytkownicy]
;
------------------------------

Answer 4

hi Battulga, can you please clarify "can't run on server 2008 R2". Are you referring to "Windows" server 2008 R2 or to "SQL" server 2008 R2

Answer 5

I use windows server 2008 R2 and sql server 2008. this code no problem can run on windows server 2008 and sql server 2008. But this codec can't run on server 2008 R2. I thing protet on power shell 2.0. Maybe. Help for this.

String cs;
System.Data.SqlClient.SqlConnection con;
String querystring;
System.Data.SqlClient.SqlCommand cmd;

cs = "Data Source=*****\\;Initial Catalog=worktemp;User ID=sa;Password=*******";
con = new SqlConnection(cs);

querystring = "SELECT User_name, Password, User_type,Name FROM [users] WHERE User_name=@uss AND Password=@pww";

cmd = new SqlCommand(querystring, con);
cmd.Parameters.Add("@uss", System.Data.SqlDbType.NVarChar).Value = unn;
cmd.Parameters.Add("@pww", System.Data.SqlDbType.NVarChar).Value = pww;

Who can give an answer? I encountered the same problem, Thank you!

Answer 6

Please provide us a full code sample so that we can reproduce this issue. you can also report this issue at https://connect.microsoft.com/sqlServer/feedback

Thanks

Sethu  Srinivasan  [MSFT]

SQL Server