In my website I am accessing my sqlserver database using "windows authencation mode".
Everything works fine when I run my website using visual studio.
but when I hosted my website on IIS, everytime an error message comes that "database login failed".
Login failed for user 'HAL\IUSR_HAL'.(HAL is the name of my webserver)
Should I do som...
How would one write a sql server DDL script that can:
For each table in database:
add column CreatedBy
add column CreateDate
add column UpdatedBy
add column UpdatedDate
Also, if the particular column already exists on the table, just skip that column.
Also, the reverse of it, for each table, drop those 4 columns.
...
I work on a C# client application (SlimTune Profiler) that uses relational (and potentially embedded) database engines as its backing store. The current version already has to deal with SQLite and SQL Server Compact, and I'd like to experiment with support for other systems like MySQL, Firebird, and so on. Worse still, I'd like it to sup...
DELETE FROM mytable WHERE column1.find("has_this_word_somewhere") ?
...
Can you recommend any good video resources for learning to use ASP.NET with a database? I come from a PHP/MySQL background and it seems that Visual Studio does too much magic for me to wrap my head around using written material.
...
Hello,
I am developing a Python web app using sqlalchemy to communicate with mysql database. So far I have mostly been using sqlalchemy's ORM layer to speak with the database. The greatest benefit to me of ORM has been the speed of development, not having to write all these sql queries and then map them to models.
Recently, however, I'...
I'm trying to learn how to map the entities/actors/objects/things in my application for storage in Cassandra. There was a great tutorial for Redis on modeling Twitter data and typical access patterns called Retwis [1]. I've found a couple of examples for Cassandra.
How did you start to gain an intuition for Cassandra's data model?
[...
I'm embarking on an adventure in JPA and want to, inasmuch as possible, stay database agnostic. What orm.xml features should I avoid to stay database agnostic?
For example, if I use strategy="AUTO" in orm.xml as follows:
<id name="id">
<generated-value strategy="AUTO" />
</id>
...then MySQL shows it as an AUTO_INCREMENT column w...
What is the easiest way to apply to database changes to the structure (not the data) made to DataSet? Do I need stuff like DataAdaptors? Is it possible to use in this way the DataSet that I configured via Visual Studio wizards? How to access such a DataSet?
...
For some reason, this MySQL fails:
CREATE SCHEMA IF NOT EXISTS `partB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `partB`;
CREATE TABLE Employees ( ssn CHAR(11),
Name CHAR(30),
mlot INTEGER,
PRIMARY KEY(ssn))
ENGINE = InnoDB;
CREATE TABLE Dept_Mgr ( did INTEGER,
dname CHAR(20),
ssn CHAR(11) NOT NULL,
PRIMARY KEY (did...
I am unable to save nonprintable characters (e.g. "\x83") to the database using Rails (v2.2).
Simplified example (from the console):
>> f = FileSpace.create( { :name => "/tmp/\x83" } )
=> #<FileSpace id: 7, name: "/tmp/\203">
>> f.name
=> "/tmp/\203"
>> FileSpace.last
=> #<FileSpace id: 7, name: "/tmp/">
So you can see, Rails is sile...
I sort of understand the concept of database normalization but always have a hard time explaining it in plain English especially for a job interview. I have read the wikipedia post, but still find it hard to explain the concept to none developers. "Design a database in a way not to get duplicated data" is the first thing that comes to ...
Hi everyone
I have a form where users can submit sites and say if they work in different browsers. Currently, it looks like this:
<input type=checkbox name="browsers[]" value="IE6"/>Internet Explorer 6<br/>
<input type=checkbox name="browsers[]" value="IE7"/>Internet Explorer 7<br/>
<input type=checkbox name="browsers[]" value="I...
Im not a developer (not a proper one) but always up for an excuse for self-development.
I work in a support team for a reputable software vendor, and we currently use a helpdesk piece of software called iSupport.
- Its not a bad piece of kit, and im not sure if it has been set up badly (trying to find out) but the biggest problem I fa...
Is it more performant to use a Prepared Statement with one question mark in it fifty times, or to use a Prepared Statement with fifty question marks in it once?
Essentially is Where Person = ? or Where Person IN (?, ?, ?, ...) better?
Example
Say you have a table with a column, country, and then a few relational tables away you have t...
I need to write a program to evaluate the performance of a small database.
I don't know where to start. Can anyone help?
aspect of performance i want to measure is
1)transactions/sec
2)if there lock happened
the programming language will be C language
...
I'm bulk loading data into a django model, and have noticed that the number of objects loaded into memory before doing a commit affects the average time to save each object. I realise this can be due to many different factors, so would rather focus on optimizing this STEPSIZE variable.
What would be a simple algorithm for optimizing th...
MySQL doesn't currently support updating rows in the same table the trigger is assigned to since the call could become recursive. Does anyone have suggestions on a good workaround/alternative? Right now my plan is to call a stored procedure that performs the logic I really wanted in a trigger, but I'd love to hear how others have gotten ...
I have six tables: t1, t2, t3, t4, t5, t6. And I also have one main table: main_table. TOTAL 7 TABLES!
Now, I am using SOLR for the searching of classifieds, and the results from solr are put into an array. The array results are ID:nrs which I use to match agains the same ID:s in MySql.
The first column of ALL tables in MySql is called...
If I double click a TSQLConnection at design time I get a dbExpress connections dialog allowing me to select connections or create new ones.
Is there anyway to use that connections dialog at run time ? I would love to present it to my users so they can select a connection.
That particular dialog looks more useful to me than PromptDataS...