You searched for the word(s): userid:526220

More Search Options

RSS Available

• Re: Central European specific characters in SQLExpress

  [quote user="ksridharbabuus"] insert into Test_DiffChars2( Col1) values( N 'š, ž, Š, Ž č, ć, đ, Č, Ć, Đ') [/quote] This works! Thank you!!! I wasn't aware of this "N"-syntax at all, thanks for letting me know!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 11/3/2008

• Re: Central European specific characters in SQLExpress

  [quote user="TATWORTH"] First of all as you are using SQL 2005 Express, I suggest that you NVARCHAR(MAX) instead of NTEXT. [/quote] I wasn't aware of that option, I thought max is 255. I'll try that, thanks. [quote user="TATWORTH"] I am surprised that the use of NTEXT did not fix the problem. Please try displaying nav(rs("tekst").ToString) and see of the special characters are there. [/quote] It didn't fix the problem. Displaying shows text without special

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 11/3/2008

• Re: Central European specific characters in SQLExpress

  Thanks for the reply, Ksridharbabuus! Unfortunatelly, it didn't help. So when creating table in SQLExpress, I tried these 4 solutions, it all failed: cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE trivia (ID SMALLINT IDENTITY(1,1) PRIMARY KEY NOT NULL, tekst TEXT )", cn2) cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE trivia (ID SMALLINT IDENTITY(1,1) PRIMARY KEY NOT NULL, tekst NTEXT )", cn2) cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 11/2/2008

• Re: Central European specific characters in SQLExpress

  I found out that I should change the Collation in SQL Express. How do I do that? By the way, I just realized: this forum's data is probably stored in MSSQL. I can see clearly those characters that I entered in my previous post, therefore I guess this database is configured the way I need, to receive those characters properly. Admin, could you help me out how to achieve that?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 11/1/2008

• Central European specific characters in SQLExpress

  Hi! This is region specific issue, it's about Central European. You see, there are some specific characters in Central Europe (I'll write them here, don't know how you'll see them though: čćšđž ) I have the data in MS Access database. Now, I try to copy the data into SQL Express 2005 database, using the script ("select * from..." MS Access table and "insert into..." MS SQL table) The data is copied correctly except for some of those special characters (plus their

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 10/31/2008

• Re: error: 26 - Error Locating Server/Instance Specified

  I changed remote connection to true in sql server surface and it works. I just remembered the reason why it stopped working: I made a 'clean boot' on both computers, therefore SQL was stopped at boot!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 10/31/2008

• error: 26 - Error Locating Server/Instance Specified

  Hi, I wasn't working with MS SQL for a while. When I installed VWD 2008 Express & SQL Express, I tested some simple apps with database and it was working fine before. Months later, I tried clicking on the database in VWD and got this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by imbrod on 10/31/2008
  Filed under: ms sql server sqlexpress connection failed

• Re: BulletedList shows encoded HTML?

  ... or maybe I'll try with HTML control <ul runat="server"> instead of BulletedList control...

  Posted to Data Presentation Controls (Forum) by imbrod on 10/8/2008

• Re: BulletedList shows encoded HTML?

  Geeee... Regex, rendering... all that for the simple formatting that should be default? No, thanks, I'll stick to classic ASP

  Posted to Data Presentation Controls (Forum) by imbrod on 10/8/2008

• Re: BulletedList shows encoded HTML?

  You misunderstood. I don't have just <b>boldedtext</b>, I have a complete concatenated HTML string: ...New ListItem("<b>" & rs("author_name").ToString & " " & rs("author_surname") & "</b> - " & rs("author_date").ToString & "<br />" & rs("author_description").ToString) Anyway, thanks for the link, I'll check it out.

  Posted to Data Presentation Controls (Forum) by imbrod on 10/8/2008