Tag with column collation Explanation

Printable View

Apr 13th, 2011, 03:24 AM
firoz.raj

Tag with column collation Explanation

When i see ?AlKohairDatabaseCon in the immdiate window . why i am getting the following message ???? Tag with column collation when possible=False

Code:

?AlKohairDatabaseCon Provider=SQLOLEDB.1;Password=test123;Persist Security Info=True;User ID=feroz;Initial Catalog=AlHokairCo2010;Data Source=infinity-db;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=FIROZ-PC;Use Encryption for Data=False;select INF_Code as StoreID, MON_CODE, RSG_CODE , LASTSALEDATE, LASTSALEENDTIME from dbo.CNK_Stores WHERE Closed=0 and InfFlag=1 Tag with column collation when possible=False
Apr 13th, 2011, 12:46 PM
MartinLiss

Re: Tag with column collation Explanation

It's not a message, it's part of your initialization string.
Apr 13th, 2011, 01:39 PM
firoz.raj

Re: Tag with column collation Explanation

Quote:

It's not a message, it's part of your initialization string

NoOOOOOOOOOOOO .What does the meaning of that message ???.
Apr 13th, 2011, 02:36 PM
MartinLiss

Re: Tag with column collation Explanation

Again it's not a message. If you Google the 'message' you'll find lots of examples like this one where it shows up in people's connection strings.
Apr 16th, 2011, 09:37 AM
firoz.raj

Re: Tag with column collation Explanation

can anyone tell me ???.why sometime i got the following error ???? . at this line rssales.Open StrSql, AlKohairDatabaseCon, adOpenStatic, adLockOptimisticwhen i go to the following line .

Code:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.