Getting User Input From Queries
How do I get user input in MSSQLServer 7.0 so that it asks me to input some value and then searches accordingly
THis method is avaiable in Oracle Server using the & operator
Thankx in advance
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
User Input
Is it possible to allow user input via a Reporting Services Report? What I mean is could a report be created that would allow someone using the report to enter a number that would be written to the SQL database?
View Replies !
View Related
User Input
I have created a query that has a "When" and an "And" function. I know need to make the query run on user input, i want it to ask for the date, then name to run the query
View Replies !
View Related
User Input With Sql...
Afternoon... I have a database for a pretend dvd hire company and need to create a query that uses user input as part of the query. Ie, select * from dvd where actor = 'Tom Cruise'; The 'Tom Cruise' part of the query needs to be user input every time the query is ran... Can you help? Many thanks in advance!?
View Replies !
View Related
User Input - SQL Paramaters
Hi, Just wondering if I could make sure that "hackers" don't tamper with my querystring - which is a parameter for a SQL query. i.e... Dim ListOfValues as string = request.querystring("listOfValues") 'Output would be this: 324234,5445,554654,45632,SQL command : Delete From table where product_id IN (@ListOfValues) cmd.paramaters.addwithvalue("@ListOfValues", ListOfValues ) How can I validate it so that hackers can't add any characters other than 'numbers' and ' , ' to the sql parameter? I have tried to tryparse the 'ListOfValues ' as an integer - by replacing "," with "" but an integer overflow occured. Any questions or ideas? Thanks
View Replies !
View Related
User Input Conversion
To: All, well here's a problem that I encountered, i got a textbox that is used to store the Date of Birth of a user. So when user keys in something, it is store as a string. However i wish to convert it into a datetime so that i can store it into my database. Anybody know of a way to help? i've tried countless methods but doesn't seem to work. Please give me a hand guys.... Thanks From: iaciz
View Replies !
View Related
User Input In SQL Query
Hi, I am new to ASP.NET so pordon me if my questions seems to be stupid. I was given an assign to develop a ASP that would return results from a SQL server. The problem is that part of my query to the SQL server comes from the webform select a.invnum, a.invdate, a.duedate, a.invamt,a.payamt from vpshead a inner join vendors b on (a.vendnum = b.vendnum) where (a.vendnum = " & user.text & " ) and (b.vendpass = " & Pass.text & " ) and (a.payflag <> 'V') and ( (a.invamt <> 0) or (a.payamt <> 0) )and (a.chkno = '') order by a.invdate" As your can tell I am using the user.text and Pass.text in my query which will come from the web form. I know this is wrong but how else can I do it? Thanks
View Replies !
View Related
User Input In SQL2000
Hello. I'm using SQL query analyzer to run some queries against anSQL2000 DB. Unfortunately, my previous SQL experience is some OralceSQL I took in school.To put it simply, I'm trying to write a query to pull records thatmatch a variable input. In Oracle, I'd use a substitution variablelike this...SELECT * FROM jobs WHERE jobid = &job_id_to_query;Is this possible under SQL2000? Is this only a feature of SQL*Plus?TIARich
View Replies !
View Related
How To Get User Input In Query
I m new to SQL Server. Before this I was using access. In access one can have user inputs easily .. for example where receivedate=[enter date] how I can get userinputs in SQL server Query.... Forgive me if it is a dumb question
View Replies !
View Related
Need To Get Input In Parameter From End User
Hi, I am trying to make a simple stored procedure which I want to take input on every run from end user: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO declare @sku varchar(20) insert into skua (sku,SumOfQtyNum) (select sku,sumofqtynum from sku where @sku = sku.sku) it is working but not asking parameter values (I want to use passthrough query after that in Access) thanks AA
View Replies !
View Related
User Input Data In T-sql
Hi there I want to give dynamic input to the t-sql code in sql analyzer.how do i do that.... Like adding 2 numbers declare @a integer,@b integer,@c integer --I dont want to give like this --set @a = 5 --set @b = 10 set @c = @a + @b can anyone help me with this regards Vic Vicky
View Replies !
View Related
Search Based On User Input
I have a search page that allows users to type/select values contined within the entry they're looking for. My SELECT statement returns columns in a table that get compared to the user input. So if someone selected Status (Open) then all of the 'Open' Request entries should populate the search page. How do I phrase the SELECT statement to compare values if the user gives them, but ignore the fields where no data was input when it's searching? So a search where no values were entered would return every Request Entry instead of an error; no entry. Thanks!
View Replies !
View Related
Pull Between 2 Dates From User Input
I want to pull dates from my database that are between to set dates i have written a query that does this which looks like this: "SELECT OCH_ID, empno, Selected_OCD, Start_Time, End_Time, Selected_OCDay, Selected_DOM, Selected_Month, Selected_Year FROM dbo.ICT_On_Call_Hours WHERE (CONVERT (datetime, LEFT (Selected_OCD, 2) + '/' + SUBSTRING(Selected_OCD, 4, 2) + '/' + RIGHT (Selected_OCD, 4)) >= CONVERT (datetime, LEFT ('12/02/2007', 2) + '/' + SUBSTRING('12/02/2007', 4, 2) + '/' + RIGHT ('12/02/2007', 4))) AND (CONVERT (datetime, LEFT (Selected_OCD, 2) + '/' + SUBSTRING(Selected_OCD, 4, 2) + '/' + RIGHT (Selected_OCD, 4)) < CONVERT (datetime, LEFT ('14/02/2007', 2) + '/' + SUBSTRING('14/02/2007', 4, 2) + '/' + RIGHT ('14/02/2007', 4)))" This works when the dates are included in the statement but when i try and use parameters to pull them in like this: "SELECT OCH_ID, empno, Selected_OCD, Start_Time, End_Time, Selected_OCDay, Selected_DOM, Selected_Month, Selected_Year FROM dbo.ICT_On_Call_Hours WHERE (CONVERT (datetime, LEFT (Selected_OCD, 2) + '/' + SUBSTRING(Selected_OCD, 4, 2) + '/' + RIGHT (Selected_OCD, 4)) >= CONVERT (datetime, LEFT ('@Choice1', 2) + '/' + SUBSTRING('@Choice1', 4, 2) + '/' + RIGHT ('@Choice1', 4))) AND (CONVERT (datetime, LEFT (Selected_OCD, 2) + '/' + SUBSTRING(Selected_OCD, 4, 2) + '/' + RIGHT (Selected_OCD, 4)) < CONVERT (datetime, LEFT ('@Choice2', 2) + '/' + SUBSTRING('@Choice2', 4, 2) + '/' + RIGHT ('@Choice2', 4)))" I then recieve the following error message why is this? ERROR -------------------> Syntax error converting datetime from character string. Any Help would be greatly appreciated thanks
View Replies !
View Related
User Input In Query Analyzer
Hi folks, i am lookin for an option in the QA to take user input while executing a query. just like we do in SQLPLUS: SELECT * FROM dept WHERE deptno=$abc here it would ask me for the deptno. I guess it's a very handy feature and we could test our variables and calculations withing the procedures etc. Is there a way, or any substitute? Howdy!
View Replies !
View Related
Need To Pass User Input Through To SQL Query
Hello Everybody, I am sure this has been asked a thousand times before in a thousand different ways, but here goes... I am in need of the ability to prompt users for a From Date and To Date to insert into a WHERE clause in SQL queries. What is the easiest least painful way of accomplishing this? A great many of our customers utilized SQL Server Express or MSDE, so they do not have the full gambit of SQL tools handy. Believe me when I say that I have searched high and low across the internet for this solution. I was hoping I might be able to accomplish this through VB Script or J Script. Or, anything reasonable. Thanks in advance for your time and patience, Rocky Mountain Tech
View Replies !
View Related
How To Save User'input In Datagrid In C#
hi in my windows application.there is a data grid ,2 textboxes and 2 buttons.. if i m giving a sql query lik "insert into information values('ab',67)"; it is taking manual data from user,and saving that to datagrid.bt if i try to put sum data from user via textbox aft pressing save button its giving an additional msg at run time i.e .Additional information: Object reference not set to an instance of an object. plz help me hw to resolve.dis
View Replies !
View Related
User Input During Report Generation.
Hello, I'm trying to do something simple that has turned out to be a frustrating problem. I have a field in my report that needs to be populated by user input. Based on this user input, I will use the field in a calculation. The simple solution to me, was to create a custom assembly that has a function that uses Console.Write("Input Data") and Console.readline() to assign the input to a string, and then return that string to the report. This works fine in a test console application, but when I copy and paste the code to my custom assembly, it returns #Error to the report. I've debugged, and found that when I hit F10 on Console.Write("test"); it skips right over it, and nothing happens. It also skips over Console.readline(); with nothing happening. This makes me unable to take the user input and set the textbox equal to that value. Am I doing this completely wrong? Is there something I'm missing, or just not understanding correcly? It seems like reporting services has to have this option. I'd really appreciate some advice. Thanks! -Paul
View Replies !
View Related
How To Update Values From The User Input?
Hi I have a table(tblA) as follows Col1--------------col2---------col3-----col4 London------------1131---------299------Barking Didicot-----------3451---------429------Dansdon Barking/ASton-----1131---------345------Singleton Vander/ADon/cam---3907---------299------derby Null or Blank ---1131---------423------Addington Expecting the Data should display look like below London------------1131---------299------Barking Didicot-----------3451---------429------Dansdon Barking/ASton-----1131---------345------Singleton Vander/ADon/cam---3907---------299------derby But when user change the col2 value (1131) to 113999, this should be changed to all values where col2 is 1131. Please Help
View Replies !
View Related
Running Query From User Input
I would like to setup a query where the user is firstly prompted to input the information e.g. if they are trying to locate a particular person from a telephone database they would be prompted to enter the surname for that person.
View Replies !
View Related
Dynamic WHERE Operator Based On User Input
Let's say I have a table with 3 fields: an ID field (primary key, set as an id field, etc.), a Name field (nvarchar50), and an Age field (int). I have a form that has three elements: DropDownList1: This drop down list contains 3 choices- "=", ">", and "<". Age: This text box is where someone would enter a number. Button1: This is the form's submit button. I want someone to be able to search the database for entries where the Age is either equal to ("="), greater than (">"), or less than ("<") whatever number they enter into TextBox1. The code-behind is shown below. The part I'm confused about is that if I load this page, the query works the -first- time. Then, if I try to change the parameters in the form and submit it, I get the following error: "The variable name '@Age' has already been declared. Variable names must be unique within a query batch or stored procedure." Any help would be appreciated. Here is what I'm using in my code behind: protected void Button1_Click(object sender, EventArgs e) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("SELECT * FROM People WHERE Age "); switch (DropDownList1.SelectedValue) { case "=": sb.Append("= "); break; case ">": sb.Append("> "); break; case "<": sb.Append("< "); break; } sb.Append("@Age"); SqlDataSource1.SelectCommand = sb.ToString(); SqlDataSource1.SelectParameters.Add("Age", TypeCode.Int32, Age.Text); }
View Replies !
View Related
Query Database User Input From ListBox
I have a problem selecting fields from a table where fields are equal to user input from a listbox. example listbox of zip codes: 33023[red]22300[/red]39844[red]29339[/red]23883[red]38228[/red] user wants to retreive highlight zip codes from database.connection working perfect.Thank you for your help.
View Replies !
View Related
How Can I Enter A User Input Into 2 Tables Simultanously?
I'm running asp.net on an XP machine with MSDE 2000 as the database. I want to create a user table with a userid and password. I have a second table that contains details about the user such as home address and phone number etc. When the user first signs up, I want their userid to go into the user table and the user detail table. In my SQL insert command, I can't get @userId to go into both tables. So my question is how do I get the userID to go into both tables or is there a better way of doing this altogether? Thanks, Tom
View Replies !
View Related
Using User Input As Part Of A SELECT Statement
I know this is an easy one and I know I've read it somewhere, but I can't seem to write the correct format to run correctly. I am trying to build a SELECT statement base on the selected values of a dropdown list on a webform. The selected values will be part of the Table name.. ("client_info" & location_option.selecteditem.value) Can someone show me the correct syntax for adding a form variable into a SELECT statement? Thanks
View Replies !
View Related
Displaying Multivalue User Input In Textbox!?
Is it possible to display multivalue user input parameters within the report, so the user can see what he just entered in the parameters? I only can get the first or the second value within a textbox: (parameters!year.value(0) / parameters!year.value(1)) The desired output i want to achive is that the multiple selections are displayed within one text box: Example: Parameter Year: 2006,2007,2008 Any suggestions?
View Replies !
View Related
Error Message For Wrong User Input
how can i make a customized error message for a wrong input of parameters? let's say i have a parameter which requires user input of companyID and it should compose of all numbers only. if not followed an error message will be prompted to the user... "please enter numbers only..." or something like that... please... just wondering if its possible...
View Replies !
View Related
Update Records From User Input - Any Good Samples?
Edited by SomeNewKid. Please post code between <code> and </code> tags. Right now i'm just trying to get the page to update SQL, but its not working no errors or anything but still not updating?!?! Any ideas? Thanks in advance Ben <% Dim cnnSimple ' ADO connection Dim rstSimple ' ADO recordset Set cnnSimple = Server.CreateObject("ADODB.Connection") cnnSimple.Open Blah Blah Blah Set rstSimple = cnnSimple.Execute("SELECT * FROM WK_DATA WHERE WEEK_NUM = 2") %> <input name="Submit" type="button" value="Add"> <% If Request.Form("Submit") = "Add" Then cnnSimple.Execute("UPDATE WK_DATA SET PRICE = (PRICE + 1) WHERE WEEK_NUM = 2") rstSimple.update End If cnnSimple.Close Set cnnSimple = Nothing %>
View Replies !
View Related
Comparing And Rounding User Input Variables To Table Values?
HiThe scenario:The price of products are determined by size.I have a Prices table that contains 3 columnsWidth Length and Price.User inputs their own width and length values as inWidth and inLength.It is unlikely that these values will exactly match existing lengths and widths in the price table.I need to take these User Input values and round them up to the nearest values found in the Prices table to pull the correct price.What is the most efficient way of achieving this?Thanks for your time.C# novice!
View Replies !
View Related
Database Level Setting : Allow User Input Chinese Character~
Dear all, To allow users enter chinese character into table, I did try to change the field type to nchar and this is workable. But I have few hundred tables.. Is there anyway to change the setting in easier way? by instead change the field type one by one for each table? I tried change the collation to Chinese_PRC_90_BIN for the database, but it is not support chinese input.. Any Idea? Thanks.
View Replies !
View Related
Top 10 Most Costly Queries By User?
The websites I write use ad-hoc queries instead of stored procedures. So when I run the following query:SELECT TOP 10 [Average CPU used] = total_worker_time / qs.execution_count ,[Total CPU used] = total_worker_time ,[Execution count] = qs.execution_count ,[Individual Query] = SUBSTRING (qt.text,qs.statement_start_offset/2, (CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) ,[Parent Query] = qt.text ,DatabaseName = DB_NAME(qt.dbid)FROM sys.dm_exec_query_stats qsCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qtORDER BY [Average CPU used] DESC;I am getting null for dbid, thus not allowing me to truly see which location my high cpu usage queries are running on. Is it possible to output the database user that executed the query? If I can see which user was connected when running the ad-hoc query I can tell which database it was run on.Thanks guys.
View Replies !
View Related
User Created Sql Queries
Hi Folks, I am trying to make it that a user can just click on my form and generate a custom sql query. for example: If I had three list boxes,I would like my user to be able to click on any of the items in the three boxes and come up with a datagrid displaying the query results.(in effect creating an individual query i.e ListBox1 robert redford dustin hoffman steve mc queen ListBox2 butch Cassidy and the Sundance Kid the Sting straw dogs pappilon List 3 1965 1966(through to) 2008) So then I want my user to come along click on Dustin Hoffman then click on a film(the sting perhaps) then the year,to find out if Dustin was actually in that film in that particular year...and if he was produce the details. This will create a "custom" sql statement like select * from lst 1 ...ect. What I would like to know is can this actually be done. This is only a small example of the datbase.I have thousands of films and name ect so it can get quite big. any help fully appreciated Gracie
View Replies !
View Related
SQL Queries That Have Parameters Passed By User
I have an sql query that has specific criteria (like state='PA' orstate = 'NJ'...) and would like to be able to have the user specifythe criteria dynamically either through the web or from MSAccess oranother tool.The query also does a GROUP BY the state and other variables that arepart of the criteria.I know how to get MSAccess and asp pages to do the sorting andselecting against an SQL tbl or view, but when access queries the sameinfo as the original sql view, the process takes much longer than whenthe sql view does all of the sorting, selecting and grouping..The table we are currently using is 5 million records and will begrowing to 250 million records shortly, so speed is of the essence.The sql views and MSAccess are both running from the same server sothere is no issue at this point of a network impacting the MSAccessquery.Any suggestions...
View Replies !
View Related
User Define Roles And Cross Database Queries
We maintain a few applications that query multiple databases on our server. We also have groups of users that multitask using different applications. I've always created a Role in each database for every application. Wondering if someone is in two Roles at once will we have security conflicts?
View Replies !
View Related
Change Connected User To Avoid Owner Prefix In Queries
Hi everybody,I've five instances of SQL Server 2000 with the SAME database with aDIFFERENT owner in each server. I, as the administrator, have a lot ofqueries that I have to execute in some or all servers. The problem isthat I have to connect to all servers with MY user, not each of the dbowners...So I have queries this way:select * from mike.table1 t1 join mike.table2 t2 on...And when I connect to another server I have to change mike for jeremyin all the SQLs...And when I connect to another server I have to change jeremy for ninain all the SQLs...I know that there was an old, v7, deprecated way to change the"schema", something likechange current user to kimberlygoselect * from table1 t1 join table2 t2 on...This way, I'll change ONLY once the connected user. I could even do atthe beginning of the script an IF, to change the connected userdepending on @@SERVERNAME !!!Can someone remember this instruction???Thanks in advance for your help !!!
View Replies !
View Related
Handling Large Queries In A Table Valued User Defined Function
Hello, We have created several Table Valued User Defined Functions in a Production SQL Server 2005 DB that are returning large (tens of thousands of) rows obtained through a web service. Our code is based on the MSDN article Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions . What we have found in our implementations of variations of this code on three seperate servers is that as the rowset grows, the length of time required to return the rows grows exponentially. With 10 columns, we have maxed out at approximately 2 500 rows. Once our rowset hit that size, no rows were being returned and the queries were timing out. Here is a chart comparing the time elapsed to the rows returned at that time for a sample trial i ran: Sec / Actual Rows Returned 0 0 10 237 20 447 30 481 40 585 50 655 60 725 70 793 80 860 90 940 100 1013 110 1081 120 1115 130 1151 140 1217 150 1250 160 1325 170 1325 180 1430 190 1467 200 1502 210 1539 220 1574 230 1610 240 1645 250 1679 260 1715 270 1750 280 1787 290 1822 300 1857 310 1892 320 1923 330 1956 340 1988 350 1988 360 2022 370 2060 380 2094 390 2094 400 2130 410 2160 420 2209 430 2237 440 2237 450 2274 460 2274 470 2308 480 2342 490 2380 500 2380 510 2418 520 2418 530 2451 540 2480 550 2493 560 2531 570 2566 It took 570 seconds (just over 9 1/2 minutes to return 2566 rows). The minute breakdown during my trial is as follows: 1 = 655 (+ 655) 2 = 1081 (+ 426) 3 = 1325 (+244) 4 = 1610 (+285) 5 = 1822 (+212) 6 = 1988 (+166) 7 = 2160 (+172) 8 = 2308 (+148) 9 = 2451 (+143) As you can tell, except for a few discrepancies to the resulting row count at minutes 4 and 7 (I will attribute these to timing as the results grid in SQL Management Studio was being updated once every 5 seconds or so), as time went on, fewer and fewer rows were being returned in a given time period. This was a "successful" run as the entire rowset was returned but on more than several occasions, we have reached the limit and have had 0 new rows per minute towards the end of execution. Allow me to explain the code in further detail: [SqlFunction(FillRowMethodName = "FillListItem")] public static IEnumerable DiscoverListItems(...) { ArrayList listItems = new ArrayList(); SPToSQLService service = new SPToSQLService(); [...] DataSet itemQueryResult = service.DoItemQuery(...); // This is a synchronous call returning a DataSet from the Web Service //Load the DS to the ArrayList return listItems; } public static void FillListItem(object obj, out string col1, out string col2, out string col3, ...) { ArrayList item = (ArrayList) obj; col1 = item.Count > 0 ? (string) item[0] : ""; col2 = item.Count > 0 ? (string) item[1] : ""; col3 = item.Count > 0 ? (string) item[2] : ""; [...] } As you will notice, the web service is called, and the DataSet is loaded to an ArrayList object (containing ArrayList objects), before the main ArrayList is returned by the UDF method. There are 237 rows returned within 10 seconds, which leads me to believe that all of this has occured within 10 seconds. The method GetListItems has executed completely and the ArrayList is now being iterated through by the code calling the FillListItem method. I believe that this code is causing the result set to be returned at a decreasing rate. I know that the GetListItems code is only being executed once and that the WebService is only being called once. Now alot of my larger queries ( > 20 000 rows) have timed out because of this behaviour, and my workaround was to customize my web service to page the data in reasonable chunks and call my UDF's in a loop using T-SQL. This means calling the Web Service up to 50 times per query in order to return the result set. Surely someone else who has used Table Valued UDFs has come accross this problem. I would appreciate some feedback from someone in the know, as to whether I'm doing something wrong in my code, or how to optimize an SQL Server properly to allow for better performance with CLR functions. Thanks, Dragan Radovic
View Replies !
View Related
Login Failed For User '[USER]'. The User Is Not Associated With A Trusted SQL Server Connection.
Server Error in '/Forums' Application. can u help me how to find a solution to this:Server Error in '/Forums' Application.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user '"[user]"'. The user is not associated with a trusted SQL Server connection. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
View Replies !
View Related
Parameterized Queries Running Slower Than Non-parameterized Queries
HelloWhen I use a PreparedStatement (in jdbc) with the following query:SELECT store_groups_idFROM store_groupsWHERE store_groups_id IS NOT NULLAND type = ?ORDER BY group_nameIt takes a significantly longer time to run (the time it takes forexecuteQuery() to return ) than if I useSELECT store_groups_idFROM store_groupsWHERE store_groups_id IS NOT NULLAND type = 'M'ORDER BY group_nameAfter tracing the problem down, it appears that this is not preciselya java issue, but rather has to do with the underlying cost of runningparameterized queries.When I open up MS Enterprise Manager and type the same query in - italso takes far longer for the parameterized query to run when I usethe version of the query with bind (?) parameters.This only happens when the table in question is large - I am seeingthis behaviour for a table with > 1,000,000 records. It doesn't makesense to me why a parameterized query would run SLOWER than acompletely ad-hoc query when it is supposed to be more efficient.Furthermore, if one were to say that the reason for this behaviour isthat the query is first getting compliled and then the parameters aregetting sent over - thus resulting in a longer percieved executiontime - I would respond that if this were the case then A) it shouldn'tbe any different if it were run against a large or small table B) thisperformance hit should only be experienced the first time that thequery is run C) the performance hit should only be 2x the time for thenon-parameterized query takes to run - the difference in response timeis more like 4-10 times the time it takes for the non parameterizedversion to run!!!Is this a sql-server specific problem or something that would pertainto other databases as well? I there something about the coorect use ofbind parameters that I overall don't understand?If I can provide some hints in Java then this would be great..otherwise, do I need to turn/off certain settings on the databaseitself?If nothing else works, I will have to either find or write a wrapperaround the Statement object that acts like a prepared statement but inreality sends regular Statement objects to the JDBC driver. I wouldthen put some inteligence in the database layer for deciding whetherto use this special -hack- object or a regular prepared statementdepending on the expected overhead. (Obviously this logic would onlybe written in once place.. etc.. IoC.. ) HOWEVER, I would desperatelywant to avoid doing this.Please help :)
View Replies !
View Related
Error : &&"cannot Open User Default Database. Login Failed. Login Failed For User 'server/user'
i'm using the Enterpirse library logger to write logs into a database. When choosing connection string i choose the database i want in the "connection properties" dialog box and push 'Test connection' button. everything goes well. then i open the SQL Server Management studio express and connect to the databse to check some things, from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error: "cannot open user default database. Login failed. login failed for user My'server/MyuserName'" even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore.... it only work when i restart the computer. why ?
View Replies !
View Related
BCP Input
Using MSDE and OSQL I begin with: C:OSQL -D VID -i C:accepted.sql -o C:Resultsaccepted.txt -n -w500 -Usa That gives me data such as this: 363 Cynthia KY 36 542 Charlene NC 3 594 Amanda NJ 9 592 Robert NJ 54 Then this command to create a table CREATE TABLE accepted ( Customer_idnvarchar(50)NULL, Cust_Namenvarchar(50)NULL, Cust_Statenvarchar(50)NULL, Cust_Countnvarchar(50)NULL ) GO I've created this BCP format file: 8.0 4 1 SQLCHAR 0 50 "/t" 1 Customer_id SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 50 "/t" 2 Cust_Name SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 50 "/t" 3 Cust_State SQL_Latin1_General_CP1_CI_AS 4 SQLCHAR 0 50 "/r/n"4 Cust_Count SQL_Latin1_General_CP1_CI_AS Table is created. I can SELECT * FROM accepted and see my column names. Then I try to BCP into the table using: C:>BCP sales..east in C:Resultsaccepted.txt -t -f C:cpformataccepted.fmt -Usa -Ppwd I get this error: Starting copy... SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation and so on...... In the .fmt file I've tried "", " ", " " and everthing I could think of as a delimiter. Still no luck. I've tried almost every switch available to both OSQL and BCP. The data I am trying to BCP is a SQL result so I don't think any special delimiters are placed. I've tried not using the .fmt file and using the prompts but still no luck. Data is CAST in the query and doesn't excede 45 characters. Hope I've explained my problem well enough. -Deana
View Replies !
View Related
Input Box Not Updating
I have two textboxes on the page...shipdate and duedate. When the page loads, shipdate has today's date loaded and duedate has a date that's 28 days later than today. When I change the dates and submit it's not updating in the database instead I'm getting the two dates in pageload. What am I doing wrong?Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load ShipDateTxt.Text = Today() DueDateTxt.Text = DateAdd(DateInterval.Day, 28, Today()) End SubProtected Sub LoanRequest_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LoanRequest.Click Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("TrainUserConnectionString").ConnectionString)Dim cmd As New Data.SqlClient.SqlCommandWith cmd .Connection = conn .CommandType = Data.CommandType.StoredProcedure .CommandText = "UpdateloanerInfo".Parameters.AddWithValue("@requestorid", Integer.Parse(Request.QueryString("requestorid"))) .Parameters.AddWithValue("@shipdate", ShipDateTxt.Text).Parameters.AddWithValue("@duedate", DueDateTxt.Text) End With Here's updateloanerinfo stored procedure: @requestorid int,@shipdate datetime,@duedate datetime AS update LibraryRequest set [shipdate] = @shipdate,[duedate] = @duedate Where requestorid=@requestorid
View Replies !
View Related
Input Chinese
Hi,I need to input Chinese character into the table of the database. I did try to install/run both Chinese/English version of Visual Studio into Chinese/English version of Server 2003 but it still didn't work.Please help !stephen
View Replies !
View Related
|
TRACKER
