Reserved Symbols / Punctuation Marks In Passwords
Dec 9, 2003
Please can anyone help me - I am trying to establish whether there are any reserved symbols in SQL passwords
eg % £ " $ ( / < * etc
The SQL BOL has a list of reserved words but I cannot find a list of reserved symbols.
We have a problem where by for example if the main part of the password is "test" and my user wants to add a punctuation mark into this we get "You are attempting to use an invalid character message"
Specifically
"test$" is accepted "$test" is not accepted
None of "te+st" "+test" "test+" are accepted.
Has anyone else come across this and found a list of the logic that produces these results so I can point my users in the right direction?
Cheers
View 3 Replies
ADVERTISEMENT
Jul 7, 2006
Users were able tolog on to our SQL 2000 servers with their passwords being case-insensitive.
Now with SQL 2005 some users can't logon because SQL 2005 passwords are case-sensitive.
Can SQL 2005 be configured so that passwords are NOT case sensitive???
Thanks!
View 6 Replies
View Related
Mar 12, 2004
Hi
I have this simple and working well SQL-row:
MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Type = '" & TestType.tostring & "' ", MyConnection)
-----------
Then I have this one which I am very proud of because I can retrieve any word or part of word from the Item-field:
Test_Text=(Session("session-Text").tostring)
Dim val1, val2, val3 as string
val1 = Test_Text
val2 = "%"
val3= val1 + val2
MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Item Like '%" & val1 & " %' OR Item Like '%" & val3 & " %' ", MyConnection)
------------
The problem is:
When I try to merge these two in one big "AND" row as shown below, It only cares of picking up the Test_Text string and ignores totaly the TestType one!
I guess it is a matter of punctuation, can any one help me? Thanks.
MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Type = '" & TestType.tostring & "' AND Item Like '%" & val1 & " %' OR Item Like '%" & val3 & " %'", MyConnection)
View 3 Replies
View Related
Oct 24, 2005
Has anyone had to deal with removing punctuation (commas, apostrophes,etc.) from a column? What is the most efficient way to have thesecharacters automatically removed from the column?
View 3 Replies
View Related
Jul 20, 2005
Hi,I have a table of text. I need to search for whole words within this text...For example, I need to be able to search for records that contain 'dog' butnot return 'hotdog' or 'dogma' for example.I am doing this by throwing a space around both the records in the table andthe search word like this:WHERE (' ' + Text + ' ') Like ('% ' + Search + ' %')The problem is that punctuation needs to be stripped out of the text so thatit will still find "...walking the dog."Is there a way to update, converting a certain set of characters intoanother character (i.e. a space) and/or to do the same thing during the wordsearch query itself?Thanks!
View 5 Replies
View Related
Nov 25, 2007
I have a block of xml that I wish to update in my sql database. The problem I have is the the data has double and single quotation marks in it and all my attempts to send this to my sql database gives me errors reguarding the quotation marks. Is there a way I can send the xml to the database without these problems. I am using the xml in the sql database to make it easy to read and right the xml as xmldatasource does not allow reading and writing easily.
this section shows the problem, i am loading xml from a file and trying to insert this into the sql database
XmlTextReader reader = new XmlTextReader(Server.MapPath("xml/wt.xml"));reader.WhitespaceHandling = WhitespaceHandling.None;XmlDocument xmlDocF = new XmlDocument();xmlDocF.Load(reader);this.SqlDataSource1.UpdateCommand = "update [data] set [linkXML] '" + xmlDocF.InnerXml+ "' where [index] = 1" ;this.SqlDataSource1.Update();reader.Close();
pls help
View 6 Replies
View Related
Jul 25, 2000
I'd like some ideas on how to help out my VB staff when it comes to the tick ( ' ) mark being used in front end applications. When users enter data into the front end, and they include tick marks (eg: Sam's Auto Store), this causes trouble in how the app uses that data in a WHERE clause and other places. Does anyone have any slick ideas or experience in handling this. We have experimented with search & replace, double tick marks ( '' ), etc...
View 1 Replies
View Related
Jul 29, 2007
Hi All,I am trying to insert symbols in a field of a table. I am using the datatype nvarchar for the field.However when i tried to insert a statement with the symbol pi, it comes out as following:(A) 100? cm2 (B) 140? cm2 (C) 200? cm2All the pi symbol are converted to ?.Can ne 1 tell me how i can store such strings in the field.Thanks
View 1 Replies
View Related
Dec 14, 2005
I am creating a Project schedule using a stored procedure. The character is currently set to '>'. I would like to replace this with the 'black square', character code '25A0'. Is this possible?
Here's part of my code:
QBar = CASE WHEN EstStartDate >= @ZFromDate AND EstDeliveryDate <= @ZToDate
THEN Replicate(' ',Datediff(day,@ZFromDate,EstStartDate)) + Replicate('>',Datediff(day,EstStartDate,EstDeliveryDate) + 1)
(Running Access 2002 frontend)
View 2 Replies
View Related
Nov 20, 2007
Hi all,
I was told recently that doing the following:
SELECT ProductName ||' , '|| Category FROM PRODUCTS
would add parentheses around the ProductName field data. However, after trying it out for myself I found it did no such thing.
Does this look familiar to anyone? Is it syntax I have wrong or something?
Butterfly82
View 13 Replies
View Related
Jul 30, 2007
Hi All,
I am trying to insert symbols in a field of a table.
I am using the datatype nvarchar for the field.
However when i tried to insert a statement with the symbol pi, it comes out as following:
(A) 100? cm2 (B) 140? cm2 (C) 200? cm2
All the pi symbol are converted to ?.
Can ne 1 tell me how i can store such strings in the field.
Thanks
View 3 Replies
View Related
Mar 7, 2007
Here's the output when I type .reload in windbg (minus warning messages):
20:266> .reload
DBGHELP: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500armv4isqlceqp30.dll - OK
DBGENG: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500armv4isqlceqp30.dll - Mapped image memory
SYMSRV: C:SDKsMS_SymbolFilessqlceqp30.pdb79F8C010CB11435E99474335288548601sqlceqp30.pdb not found
SYMSRV: C:SDKsMS_SymbolFilessqlceqp30.pdb79F8C010CB11435E99474335288548601sqlceqp30.pdb not found
SYMSRV: http://msdl.microsoft.com/download/symbols/sqlceqp30.pdb/79F8C010CB11435E99474335288548601/sqlceqp30.pdb not found
DBGHELP: sqlceqp30.pdb - file not found
*** ERROR: Symbol file could not be found. Defaulted to export symbols for sqlceqp30.dll -
DBGHELP: sqlceqp30 - export symbols
Why can't it find the .pdb file on the symbol server and where else should I look?
View 1 Replies
View Related
Jul 25, 2015
I started to working on a project. I dont have a lot experiences except basic information. I just want to ask can I use symbols in primary key column like 2015/1234 etc. for file numbers. These are file numbers and must be unique so i decided to make them primary keys but im not sure that i can use symbols.
View 2 Replies
View Related
Jan 18, 2007
I am attempting to insert a trademark symbol„¢ into a database field but it is not working. Does anyone have any ideas on how to do this properly?
Any help would be very appreciated.
View 4 Replies
View Related
May 3, 2006
I have an ASP.Net page that allows people to type in strings and store them into a SQL Server DB; which in turn gets displayed on a website. The project has an admin side that can add/delete/edit announcements, which get displayed on an intranet site. These announcements can be clicked on to display further detail. When announcements are clicked on a javascript popup window is generated that displays the strings. All data is stored in a SQL Server DB.What I need to know is: how do I check to see if a string has a quotation mark or apostrophe in it so that I can replace it with the appropriate HTML code? (Though it seems I can't display an apostrophe, even when using the HTML code ''')If I store the string as was entered by the administrator (with quotation marks instead of '"'), the popup window will not display.
View 7 Replies
View Related
Feb 5, 2008
I am working on a project to import information from one database table to another. This info includes names, addresses, etc. I am running into a challenge whenever one of the names, such as O'Brien, causes problems in the sql statement. Is there a way for me to tell it to ignore the ' in O'Brien?
Thanks,
Brian
View 8 Replies
View Related
Jun 5, 2015
I am new to SSC . I have a table that has NO.OF WORKING HOURS for 30 days. I am trying to convert all the values into INT as MINS to generate a SSRS report.
Note: There are some records with negative value (-4h15m)
Sample
NAME D1 D2 D3 ....D31
X1 9H 30M NULL 10M
X2 0M 1H 30M -4H45M
X3 20M -1H NULL
View 6 Replies
View Related
Dec 11, 2007
I am importing csv files into sql 2000 using odbcbcp and am getting the '' symbols when there are null values. Has anyone ever seen this? Or know how I can prevent this from happening? I am required to use odbcbcp to import this data.
View 5 Replies
View Related
May 18, 2007
Hi,
Is there a way i can add a symbol like a bullet a (wingding font) to my report in addition to other text in a text box.
any help will be appreciated.
Regards,
Karen
View 4 Replies
View Related
Mar 21, 2006
Hello...
I am going crazy trying to figure out how to do this. I have a flat file which I am massaging the data and loading into a table here is an example of a line out of the flat file:
"ABC NUTRITIONAL PRODUCTS","550","","","N","FAIR OAKS","","","COLORADO SPRINGS","C0","","","","","","","","A","","",""
My problem is that I have one field which is this address in a concatinated form. The fields that do not apply to this entry are suite#, floor# and other columns which are designated by the "" characters. The final concatinated addres field looks like this:
"550""""N""FAIR OAKS"""
I would like to remove the "" characters in the concatinated string. I just don't know the best way to do this? I was told DTS had a way of removing the "" from the flat file source. Since I have not used DTS extensively I am not sure if this is true. I was wondering how in SSIS I could go about removing the "" marks without removing the "" say if someone is quoted eg. John said "This is only a test". Removing the quotation marks in this instance would be changing the data. I am not sure how to do this and any help or advice is greatly appreciated!
Thank you...
View 1 Replies
View Related
Dec 7, 2007
Hi I have an asp.net 2.0, web app with a sql 2000 db. I am having a problem when users cut and past content from Word and Excel and past it into a textbox apostrophes are replaced as question marks when saved to db. I have set the following line in my web.config which did not resolve the problem<globalization requestEncoding="iso-8859-1" responseEncoding="iso-8859-1" fileEncoding="iso-8859-1" culture="en-GB" uiCulture="en-GB"/> I have also read many posts, but have not found a resolutionhttp://www.codingforums.com/showthread.php?t=124609I cant do a find and replace of the character before insertion into DB, as this would involve visiting over 90 pages and changing every insert statement. Is there a way I a can force my sql server to only allow characters in a certain format, eg iso-8859-1 to resolve this problem Please help somebody must have a resolutionMany thanks in advance
View 2 Replies
View Related
Jan 8, 2008
Hi all,I have an old ASP .NET 1.1 application that I haven't had time to rebuild with .NET 2.0. No changes have been made to the application or the SQL Server the application uses. I have a web form where users can type multiple lines of text, and it is entered into an SQL database (SQL 2000 Enterprise) into a column with a datatype of "text". Recently (it seems out of nowhere), If my users enter a carriage return into the webform, it becomes a question mark in the sql database. It's really a bit funny, but also annoying, lol. Does anyone have any idea why this might be happening? Thanks so much!
View 3 Replies
View Related
Jul 6, 2007
Hi,
My first post. I am trying to run a select query to a linked server (Cache database on VMS OS) from Microsoft SQL 2000 Query Analyzer.
Here is my problem query:
SELECT *
FROM OPENROWSET('MSDASQL',
'DSN=SHADOW',
'SELECT * FROM Member_Acct WHERE close_dt > {d'2007-07-01'}'
I am getting this error:
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '2007'.
I have tried using double quotes and everythingelse I could. Database expect me to send date in this format {d'YYYY-MM-DD'}.
Please help me.
View 12 Replies
View Related
Oct 31, 2007
Hi There,
I'm having a little trouble with a large query I have written to be sent as an email.
I want to send it as a csv so I've added commas in between each value in the query.
This is causing an error though, I think the ' that surround the commas are closing the query early. Is there any way around this? like encapsulating the query?
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'ggsgn'
,@recipients = 'sgsdm'
,@subject = 'Nsgdday'
,@attach_query_result_as_file = 1
,@body_format = 'text'
,@query ='
use sdgsgdgs
select
a1.c#,',', client,',', fr,',', tpe,',', dateReq as DateRequested,',', ... '
View 1 Replies
View Related
Oct 26, 2006
How Can I Ignore Accsents and diacritical marks in WHERE statement?
i use sql statment for searching and i wont to search in text filds where some accent and diacritical marks have been enterd.
like: i want to search for 'e' or 'o' ... letters in this text: "éüöä"
if i used: "Select * from table where fild like 'e' " the result will be 0 items.
Also, same proplem in Arabic accents for eg: if i want to search for 'موت' in this text 'مَوتÙ?' , using select where statement. what can i do?
View 9 Replies
View Related
Nov 24, 2013
I have this table of Marks as shown below. All I need is to find the average Marks at various intervals of S.no. That is I need averages at every 3rd S.No. as shown.
S.No. Marks
1 ------ 5
2 ------ 5
3 ------ 6 1st Average Value here (16/3)
4 ------ 5
5 ------ 6
6 ------ 7 2nd Average Value here (18/3)
7 ------ 7
8 ------ 7
9 ------ 8 3rd Average Value here (22/3)
10 ----- 8
11 ----- 9
12 ----- 8 4th Average Value here (26/3)
So basically I need a new table which will have 4 average values for the table above. Of-course the table can be much bigger and the average values can be at any nth value of S.No.
View 12 Replies
View Related
Oct 9, 2007
Hi Everybody
I've one table named Student. Here is data
Name
Subject
Mraks
Prasad
English
80
Tushar
English
79
Sunil
English
78
Prasad
Geometry
80
Tushar
Geometry
81
Sunil
Geometry
79
Prasad
History
82
Tushar
History
81
Sunil
History
80
Now I want to write a query that displays student with subjects and marks who secured highest marks in each subject.
I want to output like this
Name
Subject
Mraks
Prasad
English
80
Tushar
Geometry
81
Prasad
History
82
So will anybody help me to write a sql query that acheive the same output
View 5 Replies
View Related
Feb 8, 2014
Is there a way to make full text search which supports search terms for words with symbols, like C#, C++ etc.?
I see that even this forum, if I try search for C++, it returns everything where letter c exists. So, it's not possible I guess?
View 5 Replies
View Related
Jun 26, 2007
Hi,
I am developing a native C++ application using SQLCE (.NET is not a current option). Am having a problem while using multiple accessors for multiple blobs in a table. After I read the data for the first blob & try to read the data for the second one, I get an error in one of the dlls (something about using heap data that was freed). Where can I get symbol data so that I can use something like Windbg to resolve my problem.
View 1 Replies
View Related
Jan 12, 2001
Hi,
We have a table with a column called 'text' Yes, text is a reserved keyword for data type. I can select it 'SELECT text FROM thistable' but when I try to use it in the order clause, 'SELECT text FROM thistable ORDER BY text', I get this error:
'The text, ntext, and image data types cannot be used in an ORDER BY clause'
I know, you're not supposed to used reserved keywords but the person who initially created this didn't know. We would prefer not to change the column name as this would require tons of changes in the code & COM object.
Is there a way to order this column?
Thanks.
View 2 Replies
View Related
Mar 2, 2001
The Query:
INSERT INTO Table1
VALUE('this doesn't work')
How can I Insert strings like the one above, into my database?
View 3 Replies
View Related
Sep 24, 1998
Does anyone know where I can get a 7.0 reserved word list?
View 1 Replies
View Related
Apr 29, 2002
I migrated a SQL7 database to a SQL2000 server by restoring from a backup file. Everything worked fine until we restarted the SQL Service a few days later and suddenly a table named Function caused me much grief
It seems Function is a reserved word in 2000 - but not in SQL 7.
I am guessing the restore fooled the system into thinking it was a SQL7 database until the restart? Anyone have any ideas why else it would have worked just fine for 5 days, then die on a restart of SQL service (not even a reboot!)
Sandie
View 1 Replies
View Related
