Error when using 'LIKE'

I am running the following query using Query Analyzer against an MSDE version. The query seems like a textbook use of 'LIKE', so the error makes to sense to me. Thanks for any help.

SELECT _FAX

FROM _IRISH_BNB_DETAILS

WHERE _FAX LIKE "[A-Z]%"

Error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name '[A-Z]%'.

Try executing:

SET QUOTED_IDENTIFIER OFF

Dave

|||

In SQL, use the single quote character to delimit strings, so:

LIKE '[A-Z]%'

instead of

LIKE "[A-Z]%"

Double quotes are used to allow for quoted identifiers, so it is thinking that "[A-Z]%" is a column name

|||

Thank you!

I was following an example in "SQL Server 2000 Administrator Companion" on page 309 that uses double quotes.

|||

Sorry, my answer is too short. Try this:

SET QUOTED_IDENTIFIER OFF

SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE "[A-Z]%"

SET QUOTED_IDENTIFIER ON

and then try this:

SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE '[A-Z]%'

You are really better changing your literal, that is "[A-Z]%" into a single quote delimited literal for the sake of ANSI compliance; however, an alternative is to set QUOTED_IDENTIFIER on so that the original code can work as is.

Dave

|||Yeah, Louis answered before I could correct myself. Sorry about that.|||Yeah, and you answered while I was answering :)|||

Hey, it was a typing war! You won!

:-)

Error when replicating with driver mismatch

Hi,
I get the following error when replicating...
ODBCBCP/Driver version mismatch
(Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
what could be the cause... and what can I do?
Thanks,
Alex
your versions of odbcbcp.dll or related components on the
publisher/distributor/subscriber are not consistent. Try to apply the latest
MDAC and SP/Hot fix to get them all consistent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Alexandre" <nospam@.nospam.net> wrote in message
news:OSYSfruAFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I get the following error when replicating...
> ODBCBCP/Driver version mismatch
> (Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
> ----
--
> --
>
> what could be the cause... and what can I do?
> Thanks,
> Alex
>
|||I knew it was something like that... just couldn't remember..
Thanks a lot! Have a good day!
Alex.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23fxpNvuAFHA.2392@.TK2MSFTNGP14.phx.gbl...
> your versions of odbcbcp.dll or related components on the
> publisher/distributor/subscriber are not consistent. Try to apply the
latest
> MDAC and SP/Hot fix to get them all consistent.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Alexandre" <nospam@.nospam.net> wrote in message
> news:OSYSfruAFHA.2180@.TK2MSFTNGP12.phx.gbl...
> ----
> --
>

Error when logging on to sql server proper

I am getting the following error.

"The user instance login flag is not supported on this version of SQL Server. The connection will be closed."

Background i created a site on my development machine, and every thing worked, this computer is running sql EX. I uploaded the site to the production server (running sql 2005 standard) and changed the connection string (i have used this connection string with other dB's to display data only, and it works) but i tried it with the ASPNETDB.mdf in the AppData folder and i get the above message.

Do i have to set some special permissions in the db for it to work. I need to be able to insert, update, and delete in this app.

The definition for the 'User Instance' attribute in connection string is as following:

User Instance

A value that indicates whether to redirect the connection from the default SQL Server Express instance to a runtime-initiated instance running under the account of the caller.

So I guess this attribute only make sense todefault SQL Server Express intance? I've tried to set 'User Instance' to true and connect to SQL of other versions(2000 and 2005), all failed with the smae error as you got.|||

I have been able to setup a db that will allow me to do the updates and inserts but with the ASPNETDB.MDF no go. This is the string i'm using:

<connectionStrings>

<addname="ConnectionString"connectionString="server=serversName\XPRESS;uid=aspuser;pwd=aspuserPassworkd;database=DATABName" />

</connectionStrings>

|||

It was a problem with permissions and use. Needed to set user to odb

Thanks for the help though

Error when hiding subtotals in Report Builder

I consequently get an error message in Report Builder (version 9.0.2047.0) when I make a report without subtotals when I have the Key attribute of a dimension in combination with a measure.

The following Report is OK, but when I unselect Show Subtotals, I get an error message.
Date | Count Result
-
10-10-2003 | 200000
-
Total | 200000

The error message is:
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

I have tried experimenting with the GroupingBehaviour on EncourageGrouping or DiscourageGrouping, but without success. I seem to be the only one with this problem.

I am using Reporting Services 2005 in combination with Analysis Services 2005 (9.00.2153.00)Is this a bug in Reporting Services / Analysis Services 2005?

Does anybody have the same problem?

Error when attempting to render HTML report from report server.

When I attempt to render a deployed report as HTML (any version) I get the
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Item has already been added. Key in dictionary: "32" Key being added: "32"
This error does not occur when rendering the report in any other format
(PDF, Excel, XML etc.). The report also works fine in all preview modes
with VS.Net 2003.
Variants of this problem have been reported 4 times previously in this news
group (3 times with reference to the Excel Rendering and once with reference
to HTML rendering) but there's been no response as to how (or if) it can be
resolved.
The only KB article I can find with potentially any relevance is:
http://support.microsoft.com/default.aspx?scid=kb;en-us;870722
It contains details of a hotfix but as my circumstances are different, I
have no idea if it's really relevant.
TIA
Danny
If it helps, my stack trace is:
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()If you have a detailed repro, I can take a look at it. Send mail directly
to me bradsy@.microsoft.com
--
| From: "Danny Shisler" <dannyshisler@.techhelpplease.com>
| Subject: Error when attempting to render HTML report from report server.
| Date: Mon, 25 Oct 2004 15:59:23 +0100
| Lines: 60
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OCzXJNquEHA.960@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 213.228.233.162
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error Uninstalling CTP

I am trying to uninstall SQL Server 2005 CTP version before installing Beta version and keep getting an ARP Wrapper Error message that states "Registry Enumeration Failed". I ran Registry Mechanic, etc, but there are no indications of a problem.

Any ideas?

Thanks in advance,

dinzana

I'm getting this error too. Totally annoying.

Error Uninstalling CTP

I am trying to uninstall SQL Server 2005 CTP version before installing Beta version and keep getting an ARP Wrapper Error message that states "Registry Enumeration Failed". I ran Registry Mechanic, etc, but there are no indications of a problem.

Any ideas?

Thanks in advance,

dinzana

I'm getting this error too. Totally annoying.

Error trying to create Maintenance plan

We have a SQL server installation on a managed hosting environment and last night they upgraded our version from standard to enterprise. It looks as if they uninstalled, and then reinstalled. So now I need to re-configure our maintenance plans but when I try right-click on Maintenance Plans and select New Maintenance Plan in Management Studio I get the following error: An OLE DB error 0x800004005 occured while enumerating packages. A SQL statement was issued and failed.

I thought it had something to do with the new installation not running as a particular user/system account and the account it wass running under didnt have the proper permissions. As a smoke test I made the user it's running as (sqlservice) an admin in SQL Server, but that didnt fix the problem

Any help would be appreciated.Have you installed SSIS too in this case if that was also available previouslY?

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an error
indicating that the Debugger Interface is not installed. I've went ahead and
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
RonMake sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:
>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
>Query Analyzer (ver 8.00.760) I click the execute button and receive an error
>indicating that the Debugger Interface is not installed. I've went ahead and
>uninstalled the debugger component and reinstalled but still get same error.
>Any idea as to what may be wrong?
>Ron