okay so pretty much I am using the asp.net 2.0 membership/roles.
i wanna make a search box that users can type in a name and it will search the database. most likely in the table "aspnet_Users"
so when users search i want it to be like this:
cmd = select * from [table] WHERE username = textbox1.text (ofcourse with parameters instead of concatenation).
but i want it to have a "like" in there
so if the users type in "fenix" they should get results matching CLOSE to fenix. so
masfenix, fenix, fenxi, and you know related names. that are similar.
should I use LIKE? and if so HOW do i use that?
is it just gonna be
cmd = select * from [table] where Username LIKE @username
@username = textbox1.text
Is it possible to change the EXECUTE AS principal on a module (such as a stored procedure or function) without having to redefine the entire module in an ALTER statement? I didn't find anything in BOL about it in the ALTER PROCEDURE or ALTER FUNCTION articles. If there is a system sproc that does it, I couldn't find it. Changing system tables is not an option (assuming that is an option) for me.
Hello everyone! This is my first post so please bear with me. We haverecently re-vamped an Access application such that in each of our 5locationsa local SQL server receives published updates from our main office server.Remote servers also send their local updates to the master and they are inturn propogated to all of the other remote servers. The new design worksgreat except for one annoying bug we have been chasing for two weeks:"Faulting application msaccess.exe, version 9.0.0.2719, faulting modulemso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user getstheerror, they hit close and it terminates Access. If they move the error offthe screen and continue working the application continues. They havediscovered this and have been doing so but the fact that the error appearsmust be fixed. If anyone can point me in the right direction it would bemuchly appreciated. Thanks in advance!- Markmweber_at_warrenlumber_dot_com
when I click on the lookups tab with SQL Server 2005 Legacy DTS I get the following error.
The specified module could not be found. (ERROR_MOD_NOT_FOUND) Some modules the query builder depends on could not be found. The query builder designer will not be functional.
I am facing one problem on my SQL server 2000. While accessing some records from the database I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.
I am using ODBC connection with sql authentication How to solve this issue.
I tried to change / add password in SQL Server Compact Edition 2005 (in Mobile 5.0) via SQL Server Management Studio. As a result I got an error: "The specified module could not be found." I wonder why and how can I change the (blank) password to a new one?
when i trying to make run the sql server in the sql server configuration I recieve this message the specific module could not be found [08007007e]. I wnat to know how to solve it
Hi, Am migrating my SQL 2000 legacy app to SQL2005 and am dealing with restrictions on the underlying system tables. Have taken advice that Granting VIEW state to all users is heavy handed (especially meta data access at SERVER level). Now looking at Module signing which is great. I can supply SP's which target the few System table/ information schema fields that I require. Now I Sign the Sp's cool, now I grant exec rights to the application role (doesn't work). Create a db role and put my users in it, okay grant role exec on Sp's (fine they work).
However my application runs under an application role always, so my users rights are ignored and it appears that its only the users not the approles who can benefit from the module signing ? I know I can switch too and from approle using cookies but I seem to be going round in cirlces here.
Essentially is there any 'EASY' and 'CONTROLLED' way that my application user who has no rights, who immediately switches to the application role can see the dbName (All rows ) from master.sysdatabases ?
Help please. I have a custom assembly that was written in vb.net 2003 which is working great on RS2000 and also on RS2005 on my development machine. To get it to work on RS2005 all I had to do was copy it into the ...MSSQL.3Reporting ServicesReportServer folder. The assembly is named prjCheckDate and is simply a function to calculate dates where the user types in a "T-x" string, the x is number of days backwards from today, and returns that actual date.
On the customer's production machine, when I try to upload the report RDL, via Report Manager, I get the following: "Error while loading code module: €˜prjCheckDate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null€™. Details: Could not load file or assembly 'prjCheckDate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied. (rsErrorLoadingCodeModule) Get Online HelpError in class instance declaration for class prjCheckDate.classSymDate: [BC30002] Type 'prjCheckDate.classSymDate' is not defined. (rsCompilerErrorInClassInstanceDeclaration) Get Online Help There is an error on line 11 of custom code: [BC30451] Name 'prjCheckDate' is not declared. (rsCompilerErrorInCode) Get Online Help "
I have gone to the rssrvpolicy.config file and added a code group as follows: "
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="prjCheckDAte.dll" Description="This is custom assembly for T-x date format processing"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinprjCheckDate.dll" /> </CodeGroup>"
This was added immediately after the existing entry for the URL membership "$CodeGen$/*" area per MSDN (ms152828).
I'm still getting the same error. I did not get to reboot the server this is on as it is a production machine and the client is hesitant to allow a reboot since this machine is used to log time and attendance and needs to be available 24x7.
With this query i get only the records i need, but i would like to output in this way
1 - 20 21 - 30 31 - 40
of course in the real environment the ID are not consecutive, this is just one example of data.
declare @temp table (ID int) declare @i int = 1 while(@i<1000) begin insert into @temp values (@i) set @i=@i+1 end select ID from ( select ID, row_number() over (order by ID) as rn from @temp ) q where (rn % 20=0) OR (rn % 20=1)
when i create a new database in microsoft sql server management studio,following error message is occurred;
===================================
Cannot show requested dialog.
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.SqlServer.ConnectionInfo)
------------------------------ Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand) at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseGeneral.Microsoft.SqlServer.Management.Sql Mgmt.IPanelForm.OnSelection(TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.DynamicallyEmbedUserControl(ViewI nfo vi, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(ISe rviceProvider sp, XmlDocument doc) at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartTh read()
----------end of error message-------------------------- Microsoft.SqlServer.Management.Common package is situated in Microsoft.VisualStudio.vspConnectionInfo.dll. This dll also exist in the same folder path(D:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE ) with SqlWb.exe(SQL Server Management Studio). i assume that dll can't be known by exe. how can i make exe know dll. or, is my assumption wrong? if so, how can i make it work?
Can i share a function module to all the reports in a report project, that i can use the functions in the formating or expressions. Is there any way to add a assembly reference to the project and can include all the functions in an assembly file?
i am getting this error when i execute the package in production environment
Source: Select Tickets DTS.Pipeline Description: The module containing "component "Conditional Split" (142)" cannot be located, even though it is registered. End Error Error: 2006-09-01 14:03:40.36 Code: 0xC004706E Source: Select Tickets DTS.Pipeline Description: The module containing "component "Data Conversion" (5863)" cannot be located, even though it is registered. End Error Error: 2006-09-01 14:03:40.36 Code: 0xC004706E Source: Select Tickets DTS.Pipeline Description: The module containing "component "OLE DB Source" (1)" cannot be located, even though it is registered. End Error Error: 2006-09-01 14:03:40.36 Code: 0xC004706E Source: Select Tickets DTS.Pipeline Description: The module containing "component "Excel Destination" (4516)" cannot be located, even though it is registered. End Error Error: 2006-09-01 14:03:40.36 Code: 0xC004706E Source: Select Tickets DTS.Pipeline Description: The module containing "component "Flat File Destination" (6486)" cannot be located, even though it is registered. End Error Progress: 2006-09-01 14:03:40.36 Source: Select Tickets Validating: 0% complete End Progress Error: 2006-09-01 14:03:40.37 Code: 0xC0048021 Source: Select Tickets Conditional Split [142] Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Conditional Split;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All R ights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2006-09-01 14:03:40.37 Code: 0xC0047017 Source: Select Tickets DTS.Pipeline Description: component "Conditional Split" (142) failed validation and returned error code 0xC0048021. End Error Progress: 2006-09-01 14:03:40.37 Source: Select Tickets Validating: 20% complete End Progress Error: 2006-09-01 14:03:40.37 Code: 0xC004700C Source: Select Tickets DTS.Pipeline Description: One or more component failed validation. End Error Error: 2006-09-01 14:03:40.37 Code: 0xC0024107 Source: Select Tickets Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:03:39 PM
I have a custom assembly that I wrote. I placed it in the GAC and the report runs fine locally. I placed it on the server in the GAC and it kicks out the following error when deploying:
Error while loading code module: €˜SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8€™. Details: Could not load file or assembly 'SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8' or one of its dependencies. The system cannot find the file specified. ....
If I put the file in the /bin directory on the server there is no issues and it works fine. I need to to deploy to the GAC though. I restarted IIS and the RS services. I still have the same issue.
I have come to know from the SQL Server documentation that the Hardware Security Modules (HSM) can be used for Cryptographic Key storage within SQL Server to increase the level of protection of data at rest. We provide a HSM Solution which protects cryptographic keys and performs cryptographic operations onboard. The aforesaid fact about SQL Server and HSMs motivates us to test our HSM product with the SQL Server. Our HSM solution provides SDK for applications/servers to communicate with the HSM hardware. The SDK basically consists of two libraries:
-MS CAPI Interface (CSP Library)
-PKCS#11 Interface (cryptoki Library)
I have found this forum best for such kind of discussion. So could you guys on the list let me know:
- How the CSP or PKCS#11 library can be integrated with the SQL Server for HSM box to protect the cryptographic keys?
- Would I need to write a new Interface/Wrapper for this integration, If yes please help?
Currently running Vista Home Premium 64 and Visual Studio 2008 Trial.
1. Create Win form app. 2. Add new data source... 3. New connection - SQL Server Compact 3.5 - Northwind.sdf 4. Highlight Products and Suppliers. 5. Drag both onto Win form 6. Run with debug 7. Error message "Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
some blogs advice change dir in SQL Server Compact 3.5 in regedit but regedit doesn't even have SQL Server Compact 3.5; only SQL ServerSQLExpress.
reinstall SQL Server Compact 3.5 and problem still exists.
I have problem when installing SQL 2005 Enterprise to my Windows 2003 R2 cluster. I install the SQL instance on the first node in my cluster, it analyses the cluster and comes up with no errors or warnings, i answer all the installation questions and proceed with the installation. When installing the SQL engine I see the status changing as the instance is started and then stopped again etc, finally the status changes to "removing backup files" when it get an error that reports:
"The setup has encountered an unexpected error while Completing Commit. The error is: The specified module could not be found."
Unfortunately there isnt any more information to go on. Any help would be appreciated.
Hi - I'm short of SQL experience and hacking my way through creating a simple search feature for a personal project. I would be very grateful if anyone could help me out with writing a stored procedure. Problem: I have two tables with three columns indexed for full-text search. So far I have been able to successfully execute the following query returning matching row ids: dbo.Search_Articles @searchText varchar(150) AS SELECT ArticleID FROM articles WHERE CONTAINS(Description, @searchText) OR CONTAINS(Title, @searchText) UNION SELECT ArticleID FROM article_pages WHERE CONTAINS(Text, @searchText); RETURN This returns the ArticleID for any articles or article_pages records where there is a text match. I ultimately need the stored procedure to return all columns from the articles table for matches and not just the StoryID. Seems like maybe I should try using some kind of JOIN on the result of the UNION above and the articles table? But I have so far been unable to figure out how to do this as I can't seem to declare a name for the result table of the UNION above. Perhaps there is another more eloquent solution? Thanks! Peter
Our clients want to be able to do full text search with a single letter. (Is the name Newton, Nathan, Nick?, Is the ID N1, N2...). Doing a single character full text search on a table work 25 out of 26 times. The letter that doesn't work is 'n'. the WHERE clause CONTAINS(full_text_field, ' "n*" ') returns all rows, even rows that have no 'n' in them anywhere. Adding a second letter after the "n" works as expected.
Here is an example
create table TestFullTextSearch ( Id int not null, AllText nvarchar(400) ) create unique index test_tfts on TestFullTextSearch(Id); create fulltext catalog ftcat_tfts;
I have a scenario of where the standard Full-Text search identifies keywords but Semantic Search does not recognize them as keywords. I'm hoping to understand why Semantic Search might not recognize them. The context this is being used in medical terminology and the specific key words I noticed missing right off the bat were medications.
For instance, if I put the following string into a FT indexed table
'J9355 - Trastuzumab (Herceptin)' AND 'J9355 - Trastuzumab emtansine'
The Semantic Search recognized 'Herceptin' and 'Emtansine' but not 'Trastuzumab'
Nor in
'J8999 - Everolimus (Afinitor)'
It did not recognize 'Afinitor' as a keyword.
In all cases the Base of Full-Text did find those keywords and were identifiable using the dmvsys.dm_fts_index_keywords_by_document.It does show the index as having completed.
why certain words might not be picked up while others would be? Could it be a language/dictionary issue? I am using English and accent insensitive settings?
would you use sql server "full text search" feature as your site index? from some reason i can't make index server my site search catalog, and i wonder if the full text is the solution. i think that i wll have to you create new table called some thing like "site text" and i will need to write every text twice- one the the table (let's say "articles table") and one to the text. other wise- there is problems finding the right urlof the text, searching different tables with different columns name and so on... so i thought create site search table, with the columns: id, text, url and to write every thing to this table. but some how ot look the wrong way, that every forum post, every article, album picture or joke will insert twice to the sqr server... what do you think?
I have installed the Adobe iFilter 11 64 bit and set the path to the bin folder. I still cannot find any text from the pdf files. I suspect I am missing something trivial because I don't find much when I Bing for this so it must not be a common problem.Here is the code.
--Adobe iFilter 11 64 bit is installed --The Path variable is set to the bin folder for the Adobe iFilter. --SQL Developer version 64 bit on both Windows 7 and Windows 8. USE master; GO DROP DATABASE FileTableStudy; GO CREATE DATABASE FileTableStudy ON PRIMARY
I have a table that contains words that will be used to search another table where FullText index has been created on searchable columns. I'm basically trying to run something like this:
SELECT t1.col1, t2.col3 FROM tbl1 t1, tbl2 t2 WHERE CONTAINS (t1.col1, t2.col1)
I know this won't work but is there a way to join these two tables so the words (t2.col1) can be passed as search conditions? There is no common key on both tables so normal join won't work. I'm trying to find a way to pass the search words from one table to another.
I have Sql server 2005 SP2. I enabled it for Full Text search. Substring search where i enter *word* doesn't return any row. I have a table testtable where description has word Extinguisher.
If i run a query with *ting* it doesn't return any row. select * from testtable where contains(description,'"*xting*"') ;
But it works if i do select * from testtable where contains(description,'"Exting*"') ;
The Full text search document says it supports substring search. Is it an issue with sql server 2005?Please help.
I am using Sql Server 2014 Express edition.I have a table with a varchar(max) column. I have created a full text search that use the stoplist "system". column has this struct: xxx.yyy.zzz.... where xxx, yyy, zzz... are numbers, like 123.345.123123.366456...I can have rows like that:
select * from Mytable where contains(MyColumn, '123.345.')
I gues the contains would return all the rows with column contains 123.345, but this does not return all the expected rows, only one row.I have tried to replace "." with "-" but the result is the same.I have also tried with '123.345.*. In this case I have got more results, but no all the exptected rows.If I use this query:
select * from MyTable where MyCOlumn like '123.345.%';
Can anyone tell me how to search an SQL database for a given key word in a textbox? I basically have a database that has a qualifications column and this column needs to be searched for the data given in the textbox. Which is the best method to search for the data? Is it a simple SQL query or an XML based search engine type? Can anyone give any suggestions regarding this? If XML is efficient then how do I use it to query my database, as I'm pretty new in XML based searching.Thanks
hi there, i am doing a school project and i need to have this search engine that will search the data that i have stored inside the database and display the results out can anyone help? thanks
My site uses a text box to allow visitors to search products. I'm trying to design the SQL Statement to allow search's on full words, part words, and words/phrases regardless of the order the words are in.
E.g. megger meg mft megger (proper order in the database is megger mft) mft1710 (using 1710 should find the product)
This is my select statement (classic ASP)
Code: <% Dim RSResults__param5 RSResults__param5 = "xxx" If (Request("searchme") <> "") Then RSResults__param5 = Request("searchme") End If
