Database

problem with sql server 2008 - cant change field type

13-Sep-09 6:09

check the following link http://msdn.microsoft.com/en-us/library/ms345292.aspx[^]

or

SQL Server 2000 Reporting Services: Creating a report from scratch[^]

or

Creating Reports with SQL Reporting Service and Visual Studio .NET[^]

and can also use/try schema.db.dbo.tbl name

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

E_Gold12-Sep-09 22:19

E_Gold

12-Sep-09 22:19

hi
i have table that i want to change any field type (from int - to - varchar)

i get this error:

saving changes is not permitted........

Re: problem with sql server 2008 - cant change field type

Md. Marufuzzaman13-Sep-09 4:38

Md. Marufuzzaman

13-Sep-09 4:38

Probably you get this error while you alter your table in design mode.. If so then you need to change setting form option... set allow auto generate sql script true.. If this issue still not resolve then please let me know... Smile | :)

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

Thanks
Md. Marufuzzaman

Re: problem with sql server 2008 - cant change field type

E_Gold13-Sep-09 9:21

E_Gold

13-Sep-09 9:21

thank's for the help
yes, i work in design mode.
but, where i can find this ...option... set allow auto generate sql script true ?

Re: problem with sql server 2008 - cant change field type

εїзεїзεїз13-Sep-09 5:59

Regaring Establishing Connection with sqlserver.

13-Sep-09 5:59

what are the data field sizes you are using to convert the field type you can use script as

GO
BEGIN
ALTER TABLE tbl ALTER COLUMN [fld] [varchar](18, 8) NOT NULL
END
GO

or create another field as varchar and update your data of numeric fld to it and then drop old column
you can also use casting

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

dayakar_dn12-Sep-09 8:35

dayakar_dn

12-Sep-09 8:35

Hi All,

I am getting a strange error while establishing connection with sqlserver.

i written the following code to establish the connection
string sqlStatement = "select * from Student_Table";
String dataBaseConnection = "Data Source=DREDDY9/SQLEXPRESS;Initial Catalog=SampleDataBase;Integrated Security=SSPI";
SqlConnection myConnection = new SqlConnection(dataBaseConnection);

SqlCommand myCommand = new SqlCommand(sqlStatement, myConnection);
SqlDataReader dr;

myConnection.Open();
dr = myCommand.ExecuteReader();
if(dr!=null)
{
Response.Write("Successfully Executed");
}
myConnection.Close();

To resolve this i tried with enabling local and remote connections and i enabled sql server browser.

but no use
any body is having any solution. please shere it.

Re: Regaring Establishing Connection with sqlserver.

dan!sh 12-Sep-09 8:56

Re: Regaring Establishing Connection with sqlserver.

12-Sep-09 8:56

What is the error?

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

εїзεїзεїз12-Sep-09 10:20

Re: Regaring Establishing Connection with sqlserver.

12-Sep-09 10:20

what kind of error you are facing are you enable to connect if so then try

Data Source=./SQLEXPRESS  instead off Data Source=DREDDY9/SQLEXPRESS

also check your protocols you are connecting with tcp/ip or named pipes and the user from which you are going to connect should have rights to connect to the db.

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

εїзεїзεїз12-Sep-09 12:00

Whats wrong with this query

12-Sep-09 12:00

look out for slash it should be \ not /

Data Source=DREDDY9/SQLEXPRESS;

Data Source=DREDDY9\SQLEXPRESS; D'Oh! | :doh:

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

AndreFratelli12-Sep-09 7:47

AndreFratelli

12-Sep-09 7:47

I have the following table (ccpoc)

poc_cod varchar(10)
poc_cod_asc varchar(10)
poc_desc varchar(40)

With the following data

poc_cod poc_cod_asc poc_desc
1           12         Coiso
1           13         Coisa
1           14         Coisinhas

And I'm trying the following query

UPDATE ccpoc SET poc_cod='133', poc_cod_asc='13', poc_desc='Coiso 133' WHERE poc_cod='13' AND poc_desc='Coiso 13' AND poc_cod_asc='1'

I'm querying the server with an ExecuteNonQuery in C#, and everything seems to go fine. No errors, no exceptions, everything runs well. The problem is that data in the table does not change!

Anybody has any idea what might be happening?

Best regards

Fratelli

dan!sh 12-Sep-09 7:58

12-Sep-09 7:58

I guess you should give a try to these:

1. Run SQL profiler to see what query is actually run on your table.
2. Run a select statement with same where clause to check if there are any rows matching the criteria.
3. If you are using transactions, check if you have committed it or not.
4. Does the same query when run through Management studio works?

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Luc Pattyn12-Sep-09 8:14

Luc Pattyn

12-Sep-09 8:14

AndreFratelli wrote:
WHERE poc_cod='13' AND poc_desc='Coiso 13' AND poc_cod_asc='1'

none of the records shown match this.

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Local announcement (Antwerp region): Lange Wapper? Neen!

AndreFratelli12-Sep-09 14:49

AndreFratelli

12-Sep-09 14:49

Yes, I noticed already. Lame mistake Sigh | :sigh:

Fratelli

εїзεїзεїз12-Sep-09 10:28

Auto reconnect to MySql when connection is lost after period of inactivity

12-Sep-09 10:28

With the following data

poc_cod poc_cod_asc poc_desc
1 12 Coiso
1 13 Coisa
1 14 Coisinhas

And I'm trying the following query

WHERE poc_cod='13' AND poc_desc='Coiso 13' AND poc_cod_asc='1'

in your abv given data their is no row having poc_desc='Coiso 13' , so how come will it update, no doubt the results would be zero.

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Bil@l12-Sep-09 5:13

Bil@l

12-Sep-09 5:13

Hi,

I have a c# application that uses a MySql database, the problem that after a period of inactivity (8 hours) or when connection to the server where database is host is lost, the connection to the database is closed and database queries cannot be executed. how can i enable the auto reconnect to the database.

Best regards.

Keep it simple, stupid!

Re: Auto reconnect to MySql when connection is lost after period of inactivity

dan!sh 12-Sep-09 8:00

Re: Auto reconnect to MySql when connection is lost after period of inactivity

12-Sep-09 8:00

Through a Timer in your C# code. Unsure | :~

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

εїзεїзεїз12-Sep-09 10:40

Re: Auto reconnect to MySql when connection is lost after period of inactivity

12-Sep-09 10:40

Shouldnot disconnected architecture will resolve it D'Oh! | :doh:

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

dan!sh 12-Sep-09 19:07

Re: Auto reconnect to MySql when connection is lost after period of inactivity

12-Sep-09 19:07

I was also thinking why would you need an active connection "forever". Then thought there might be something in his application that desperately needs it and hence the reply.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

εїзεїзεїз12-Sep-09 19:39

Re: Auto reconnect to MySql when connection is lost after period of inactivity

12-Sep-09 19:39

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

εїзεїзεїз12-Sep-09 10:37