Hi there,
We have recently upgraded to SQL 2005 standard from SQL 2000.
I have begun a new web project in Visual Studio 2005.
I have added a SQL data source to my project which contains a VIEW.
I am passing a single parameter to the DS to populate a gridview.
I get the following error when I try to:
A. Test the Datasource.
B. Load the page that contains a gridview that uses the DS.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I also get this error when creating stored procedures with an equal
operation.
Any steer in the right direction to resolve this issue would be greatly
appreciated.
Thanks in advance!
Hi
Have you checked the system collation and the column collations? At a guess
you upgraded/restored a backup with the SQL collation and installed SQL 2005
with the windows collation?
This may be the point where you decided to get rid of the SQL collation? In
which case I think the procedure is that same as SQL 2000, you will need to
alter the collation for the database alter the collation for each column that
uses it. These links should help http://tinyurl.com/429qa
http://tinyurl.com/91sg
John
"Codey" wrote:
> Hi there,
> We have recently upgraded to SQL 2005 standard from SQL 2000.
> I have begun a new web project in Visual Studio 2005.
> I have added a SQL data source to my project which contains a VIEW.
> I am passing a single parameter to the DS to populate a gridview.
> I get the following error when I try to:
> A. Test the Datasource.
> B. Load the page that contains a gridview that uses the DS.
> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>
> I also get this error when creating stored procedures with an equal
> operation.
> Any steer in the right direction to resolve this issue would be greatly
> appreciated.
> Thanks in advance!
>
>
|||Hi John,
Worked an absolute treat! - Thanks a million!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:C315F5A7-2EFF-4C59-B5A9-1A8721534E19@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked the system collation and the column collations? At a
> guess
> you upgraded/restored a backup with the SQL collation and installed SQL
> 2005
> with the windows collation?
> This may be the point where you decided to get rid of the SQL collation?
> In
> which case I think the procedure is that same as SQL 2000, you will need
> to
> alter the collation for the database alter the collation for each column
> that
> uses it. These links should help http://tinyurl.com/429qa
> http://tinyurl.com/91sg
> John
> "Codey" wrote:
Showing posts with label upgraded. Show all posts
Showing posts with label upgraded. Show all posts
Thursday, March 22, 2012
Collation Conflicts SQL 2005
Hi there,
We have recently upgraded to SQL 2005 standard from SQL 2000.
I have begun a new web project in Visual Studio 2005.
I have added a SQL data source to my project which contains a VIEW.
I am passing a single parameter to the DS to populate a gridview.
I get the following error when I try to:
A. Test the Datasource.
B. Load the page that contains a gridview that uses the DS.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I also get this error when creating stored procedures with an equal
operation.
Any steer in the right direction to resolve this issue would be greatly
appreciated.
Thanks in advance!Hi
Have you checked the system collation and the column collations? At a guess
you upgraded/restored a backup with the SQL collation and installed SQL 2005
with the windows collation?
This may be the point where you decided to get rid of the SQL collation? In
which case I think the procedure is that same as SQL 2000, you will need to
alter the collation for the database alter the collation for each column tha
t
uses it. These links should help http://tinyurl.com/429qa
http://tinyurl.com/91sg
John
"Codey" wrote:
> Hi there,
> We have recently upgraded to SQL 2005 standard from SQL 2000.
> I have begun a new web project in Visual Studio 2005.
> I have added a SQL data source to my project which contains a VIEW.
> I am passing a single parameter to the DS to populate a gridview.
> I get the following error when I try to:
> A. Test the Datasource.
> B. Load the page that contains a gridview that uses the DS.
> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>
> I also get this error when creating stored procedures with an equal
> operation.
> Any steer in the right direction to resolve this issue would be greatly
> appreciated.
> Thanks in advance!
>
>|||Hi John,
Worked an absolute treat! - Thanks a million!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:C315F5A7-2EFF-4C59-B5A9-1A8721534E19@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked the system collation and the column collations? At a
> guess
> you upgraded/restored a backup with the SQL collation and installed SQL
> 2005
> with the windows collation?
> This may be the point where you decided to get rid of the SQL collation?
> In
> which case I think the procedure is that same as SQL 2000, you will need
> to
> alter the collation for the database alter the collation for each column
> that
> uses it. These links should help http://tinyurl.com/429qa
> http://tinyurl.com/91sg
> John
> "Codey" wrote:
>
We have recently upgraded to SQL 2005 standard from SQL 2000.
I have begun a new web project in Visual Studio 2005.
I have added a SQL data source to my project which contains a VIEW.
I am passing a single parameter to the DS to populate a gridview.
I get the following error when I try to:
A. Test the Datasource.
B. Load the page that contains a gridview that uses the DS.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I also get this error when creating stored procedures with an equal
operation.
Any steer in the right direction to resolve this issue would be greatly
appreciated.
Thanks in advance!Hi
Have you checked the system collation and the column collations? At a guess
you upgraded/restored a backup with the SQL collation and installed SQL 2005
with the windows collation?
This may be the point where you decided to get rid of the SQL collation? In
which case I think the procedure is that same as SQL 2000, you will need to
alter the collation for the database alter the collation for each column tha
t
uses it. These links should help http://tinyurl.com/429qa
http://tinyurl.com/91sg
John
"Codey" wrote:
> Hi there,
> We have recently upgraded to SQL 2005 standard from SQL 2000.
> I have begun a new web project in Visual Studio 2005.
> I have added a SQL data source to my project which contains a VIEW.
> I am passing a single parameter to the DS to populate a gridview.
> I get the following error when I try to:
> A. Test the Datasource.
> B. Load the page that contains a gridview that uses the DS.
> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>
> I also get this error when creating stored procedures with an equal
> operation.
> Any steer in the right direction to resolve this issue would be greatly
> appreciated.
> Thanks in advance!
>
>|||Hi John,
Worked an absolute treat! - Thanks a million!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:C315F5A7-2EFF-4C59-B5A9-1A8721534E19@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked the system collation and the column collations? At a
> guess
> you upgraded/restored a backup with the SQL collation and installed SQL
> 2005
> with the windows collation?
> This may be the point where you decided to get rid of the SQL collation?
> In
> which case I think the procedure is that same as SQL 2000, you will need
> to
> alter the collation for the database alter the collation for each column
> that
> uses it. These links should help http://tinyurl.com/429qa
> http://tinyurl.com/91sg
> John
> "Codey" wrote:
>
Collation Conflicts SQL 2005
Hi there,
We have recently upgraded to SQL 2005 standard from SQL 2000.
I have begun a new web project in Visual Studio 2005.
I have added a SQL data source to my project which contains a VIEW.
I am passing a single parameter to the DS to populate a gridview.
I get the following error when I try to:
A. Test the Datasource.
B. Load the page that contains a gridview that uses the DS.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I also get this error when creating stored procedures with an equal
operation.
Any steer in the right direction to resolve this issue would be greatly
appreciated.
Thanks in advance!Hi
Have you checked the system collation and the column collations? At a guess
you upgraded/restored a backup with the SQL collation and installed SQL 2005
with the windows collation?
This may be the point where you decided to get rid of the SQL collation? In
which case I think the procedure is that same as SQL 2000, you will need to
alter the collation for the database alter the collation for each column that
uses it. These links should help http://tinyurl.com/429qa
http://tinyurl.com/91sg
John
"Codey" wrote:
> Hi there,
> We have recently upgraded to SQL 2005 standard from SQL 2000.
> I have begun a new web project in Visual Studio 2005.
> I have added a SQL data source to my project which contains a VIEW.
> I am passing a single parameter to the DS to populate a gridview.
> I get the following error when I try to:
> A. Test the Datasource.
> B. Load the page that contains a gridview that uses the DS.
> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>
> I also get this error when creating stored procedures with an equal
> operation.
> Any steer in the right direction to resolve this issue would be greatly
> appreciated.
> Thanks in advance!
>
>|||Hi John,
Worked an absolute treat! - Thanks a million!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:C315F5A7-2EFF-4C59-B5A9-1A8721534E19@.microsoft.com...
> Hi
> Have you checked the system collation and the column collations? At a
> guess
> you upgraded/restored a backup with the SQL collation and installed SQL
> 2005
> with the windows collation?
> This may be the point where you decided to get rid of the SQL collation?
> In
> which case I think the procedure is that same as SQL 2000, you will need
> to
> alter the collation for the database alter the collation for each column
> that
> uses it. These links should help http://tinyurl.com/429qa
> http://tinyurl.com/91sg
> John
> "Codey" wrote:
>> Hi there,
>> We have recently upgraded to SQL 2005 standard from SQL 2000.
>> I have begun a new web project in Visual Studio 2005.
>> I have added a SQL data source to my project which contains a VIEW.
>> I am passing a single parameter to the DS to populate a gridview.
>> I get the following error when I try to:
>> A. Test the Datasource.
>> B. Load the page that contains a gridview that uses the DS.
>> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
>> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>>
>> I also get this error when creating stored procedures with an equal
>> operation.
>> Any steer in the right direction to resolve this issue would be greatly
>> appreciated.
>> Thanks in advance!
>>sqlsql
We have recently upgraded to SQL 2005 standard from SQL 2000.
I have begun a new web project in Visual Studio 2005.
I have added a SQL data source to my project which contains a VIEW.
I am passing a single parameter to the DS to populate a gridview.
I get the following error when I try to:
A. Test the Datasource.
B. Load the page that contains a gridview that uses the DS.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I also get this error when creating stored procedures with an equal
operation.
Any steer in the right direction to resolve this issue would be greatly
appreciated.
Thanks in advance!Hi
Have you checked the system collation and the column collations? At a guess
you upgraded/restored a backup with the SQL collation and installed SQL 2005
with the windows collation?
This may be the point where you decided to get rid of the SQL collation? In
which case I think the procedure is that same as SQL 2000, you will need to
alter the collation for the database alter the collation for each column that
uses it. These links should help http://tinyurl.com/429qa
http://tinyurl.com/91sg
John
"Codey" wrote:
> Hi there,
> We have recently upgraded to SQL 2005 standard from SQL 2000.
> I have begun a new web project in Visual Studio 2005.
> I have added a SQL data source to my project which contains a VIEW.
> I am passing a single parameter to the DS to populate a gridview.
> I get the following error when I try to:
> A. Test the Datasource.
> B. Load the page that contains a gridview that uses the DS.
> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>
> I also get this error when creating stored procedures with an equal
> operation.
> Any steer in the right direction to resolve this issue would be greatly
> appreciated.
> Thanks in advance!
>
>|||Hi John,
Worked an absolute treat! - Thanks a million!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:C315F5A7-2EFF-4C59-B5A9-1A8721534E19@.microsoft.com...
> Hi
> Have you checked the system collation and the column collations? At a
> guess
> you upgraded/restored a backup with the SQL collation and installed SQL
> 2005
> with the windows collation?
> This may be the point where you decided to get rid of the SQL collation?
> In
> which case I think the procedure is that same as SQL 2000, you will need
> to
> alter the collation for the database alter the collation for each column
> that
> uses it. These links should help http://tinyurl.com/429qa
> http://tinyurl.com/91sg
> John
> "Codey" wrote:
>> Hi there,
>> We have recently upgraded to SQL 2005 standard from SQL 2000.
>> I have begun a new web project in Visual Studio 2005.
>> I have added a SQL data source to my project which contains a VIEW.
>> I am passing a single parameter to the DS to populate a gridview.
>> I get the following error when I try to:
>> A. Test the Datasource.
>> B. Load the page that contains a gridview that uses the DS.
>> Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
>> "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
>>
>> I also get this error when creating stored procedures with an equal
>> operation.
>> Any steer in the right direction to resolve this issue would be greatly
>> appreciated.
>> Thanks in advance!
>>sqlsql
Collation Conflict Error 368 (I think)
We just upgraded an instance of SQL Server 2000 to SQL Server 2005. When using our application to login, we are receiving an error 368, which refers to a collation conflict. Has anyone seen this?
I'm moving your thread to the database engine forum, where it may get more attention.
Paul
|||Run the profiler to see which statement your application is issuing against the database. Are you sure you are using the same collation on the new server than on the old one ? Normally this happens if you are comparing two different collation with each other (like in joins or equal expressions).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Unfortunately, only this message got moved for those of us using NNTP. Any chance that when you move a thread, you can mention where the thread was moved *from*, so we can see it? That will certainly increase the chance that it gets more attention after being moved. Steve Kass Drew University Paul Nicholson - MSFT@.discussions.microsoft.com wrote:
> I'm moving your thread to the database engine forum, where it may get
> more attention.
>
> Paul
>
>
Subscribe to:
Comments (Atom)