Search Results

Search found 31483 results on 1260 pages for 'database migration'.

Page 842/1260 | < Previous Page | 838 839 840 841 842 843 844 845 846 847 848 849  | Next Page >

• Long time to load first sql connection in .NET

  - by Shrage Smilowitz

  For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second. any idea what could be the reason? I'm using C# and asp.net Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.

  Read the article

• Stored Queries?

  - by phpeffedup

  Is it considered crazy to store common SQL queries for my web app in a database for use in execution? Or is that common practice? Or is it impossible? My thinking is, this way, I avoid hard-coding SQL into my application files, and add another level of abstraction. Is this crazy? Is this what a stored procedure is? Or is that something else?

  Read the article

• auto reload: how it works?

  - by Syom

  i need to change something in my site, if some fields changed in database, but without reloading the page! but i have no idea how i can do it. could you give me an idea? thanks

  Read the article

• accessing Excelfile from Resources

  - by Sathish

  i am trying to access a Excel file stored in my Resources and build-embed by OLEDB but when i run the program i get database is read only.. i am using the below code. Please help conMap.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + CTARepository.Properties.Resources.mapping + ";Extended Properties=Excel 8.0;"; conMap.Open(); mapping is my mapping.xls file

  Read the article

• mySQL and membership

  - by ognjenb

  How can I install aspnet 2.0 tables over MySQL database to use it with logins control and profiles and roles simply like using file aspnet_regsql?

  Read the article

• Using ASP.Net GridView Update Command for specific fields

  - by kenom

  How do I use the Update command in GrideView? I would like to use update command for specific fields in the dataset, but not all fields from database ( or maybe in GridView? )

  Read the article

• Blackberry Contacts Photo

  - by Farhan

  Hi, I am currently working on the Application named (Blackberry Contacts Sync) and i am stuck at this point that how i sync Contact's Image. Please tell me how to store images in Database(MySQL) and how to retrieve it.

  Read the article

• php error message "Notice: Undefined index: aid"

  - by iaagty

  I'm looking for a complete list of security guidelines for programming and deploying PHP web sites and applications on an Apache (Linux) server. Basically, a "security check list" to run through before finishing a project. I.e., Cross Site Scripting Cross Site Request Forgery Sanitize form data that goes into database Disable register globals and error reporting in custom php.ini Upload files below web root ...(the list goes on) I did some searching on the internet and in this forum, but couldn't find a comprehensive, succinct, and complete list of guidelines. Thanks in advance.

  Read the article

• MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my

  - by asksuperuser

  I am currently adding hundred of thousands of rows of data to a table first on a MS Access Table then on a MySQL Table. I first tried with MS Access, it tooks less than 40 seconds. Then I tried exactly with the same source and with the same table structure to MySQL and it took 6 min and 40 seconds that is 1000% slower !!! So is there a myth that a database server is more performant ?

  Read the article

• which color has the most RAM? [closed]

  - by Faisal Abid

  My boss asked me today to build him a SQL Database and I asked him what color it should be and he said Mauve has the most Ram. However I disagree, I think Orange has the most Ram. Can anyone help??

  Read the article

• here is my code for spinner with dropdownlist:

  - by user555910

  I have spinner in my application .The spinner have drop down list.I want to take the value of the dropdown list from the database .how can i do this ? here is my code for spinner with dropdownlist: ArrayAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_spinner_item, selectdefault); adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); spinner.setAdapter(adapter);

  Read the article

• How we can dyanamically bind data with diffrerent dropdownlist in a grid view?

  - by Lock up

  i am wking on an assignment in which i have a gridview that contain deptno in a dropdownlist.by selecting a particular deptno from that dropdownlist,the number of employee of that department displayed in second dropdownlist that is for displaying employyee of a department.And after selecting the employee its salary detail and date of joining displayed in textboxes?we have two database table one is for employee(fields are deptno,empname,salary,joining date,status(true/false))and second department(fields are deptno,deptname,location);;;

  Read the article

• MySQL Problems......

  - by Kovu

  With the tool "mysql administrator" i get a complete connection to my database, I can change userthings and so on. But not PHPMyAdmin nor Joomly Installation will get a connection, they timed out. Any Ideas?

  Read the article

• want to fill a textbox dynamically in jsp page

  - by Atul

  want to create a application using jsp pages such that it takes a value from user in a textbox and on the basis of that value it retrives other values from database and fill other textboxes with that retrived values

  Read the article

• Programmatically determine whether to describe an object with "a" or "an"?

  - by MarathonStudios

  I have a database of nouns (ex "house", "exclamation point", "apple") that I need to output and describe in my application. It's hard to put together a natural-sounding sentence to describe an item without using "a" or "an" - "a house is BIG", "an exclamation point is SMALL", etc. Is there any function, library, or hack i can use in PHP to determine whether it is more appropriate to describe any given noun with A or AN?

  Read the article

• Is there a true all-in-one solution for PHP Development?

  - by Alex R

  I'm looking for a "SINGLE INSTALLER" solution for PHP Development. Is there anything out there which will give me a nice IDE, Web Server, Debugger, Database, etc, on a single install image (*.msi or *.exe)? This of course would be completely opposite of Eclipse PDT, which requires you to search and locate a bunch of additional components which never quite work together.

  Read the article

• Store LAST_INSERT_ID() in a transaction

  - by Oden

  Hi, I use codeigniter's database abstarction, and im doing a transaction with it. My problem is, that i have several inserts into several tables, but i need the insert id from the first insert query. Is there any way to store the last insert id for more than one following insert?

  Read the article

• how to overload the += operator with the operands of different types (if possible)

  - by Veer

  Hi, Instead of having an add() method in the repository, I would like to overload the += operator so that the expression _repository += myModel; will insert myModel into the database(after i submit changes) I know that the objects of different type cannot be used in operator overloading. Still want to know if there is some alternate ways to accomplish this Any help?

  Read the article

• mysql on xp performance issues

  - by dave

  Please could you let me know if there are any performance issues with using mysql on windows xp. The mysql serves over 10 client server apps, which query the database simultaneously

  Read the article

• Different databases using WCF dataservice

  - by espenk

  I have multiple SQL Server databases with the same schema. I would like to use one WCF data service (Rest service) to access the different databases. How can I accomplish this so the client can pass in the correct database name or connection string?

  Read the article

• SQL query to remove text within parentheses?

  - by Josh Fraser

  What is the best SQL query to remove any text within parenthesis in a mySQL database? I'd like something that works regardless of the position of the parenthesis in the text (beginning, middle, end, whatever). I don't care about keeping the text inside the parenthesis, just removing it. Thanks!

  Read the article

• Subsonic SELECT FROM msdb

  - by Lukasz Lysik

  Hi, I want to execute the following query using Subsonic: SELECT MAX([restore_date]) FROM [msdb].[dbo].[restorehistory] While the aggregate part is easy for me, the problem is with the name of the table. How should I force Subsonic to select from different database than default one.

  Read the article

• Find the closest locations to a given address

  - by xtine

  I have built an application in CakePHP that lists businesses. There are about 2000 entries, and the latitude and longitude coordinates for each business is in the DB. I now am trying to tackle the search function. There will be an input box where the user can put a street address, city, or zipcode, and then I would like it to return the 11 closest businesses as found from the database. How would I go about doing this?

  Read the article

• SQL Alter Table to Add a Column, does it do anything "scary"?

  - by Pselus

  I need to add a column to an existing table in my live sql database. I know how to use the ALTER command, but what I want to know is the effect this has on the table. For example,, if using SQL Management Studio, it claims that adding a column will "drop and recreate" the table. Will the ALTER table command do that as well? This table is CONSTANTLY accessed and VERY important so I want to make VERY sure of this before going forward.

  Read the article

• Does table (string, string) require index?

  - by abatishchev

  In my database running on SQL Server 2008 R2 I have a special table for global variables: CREATE TABLE global_variables ( name NVARCHAR(50), value NVARCHAR(50) NOT NULL CONSTRAINT PK_global_variables PRIMARY KEY CLUSTERED ( name ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO Does such table require indexing on value or not?

  Read the article

< Previous Page | 838 839 840 841 842 843 844 845 846 847 848 849  | Next Page >