A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

learn more… | top users | synonyms (2)

3
votes
1answer
44 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
1
vote
1answer
225 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
2
votes
1answer
1k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
0
votes
2answers
76 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
3
votes
5answers
7k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
1
vote
1answer
126 views

Which is better for multi-use auth, MySQL, PostgreSQL, or LDAP? [closed]

I want to set up an Oracle Linux 6 server that gives users secure IMAP email (with dovecot), Jabber IM, FTP (with vsftpd), and calDav. However, I want each user logon to be able to authenticate all ...
1
vote
0answers
47 views

Database for Quotes needed: Tags, multi-language support?

Dear superuser userbase! Almost every website now supports tags. I want to harness the power of tags for a private database, can you help? Ideal: A database of quotes (columns: English | German | ...
4
votes
3answers
667 views

How are sites like Pinterest able to hold all those pictures?

Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
-2
votes
1answer
216 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
1
vote
1answer
405 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
2
votes
1answer
242 views

What's a good database-backed X.509 certificate authority on Linux

I've been using OpenSSL as an X.509 certificate authority. Because multiple machines will need to create certificates, I've exported the certificate authority folder on a distributed filesystem. When ...
1
vote
0answers
46 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
2
votes
1answer
2k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1
vote
1answer
103 views

Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column, the matching name should appear in the second column automatically. The list of numbers and names is on a ...
1
vote
0answers
34 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
2
votes
1answer
1k views

How to add new customized columns to windows 7 explorer (or find a similar application that is more customizable)

I like the way windows 7 explorer allows me to organize all my files by sorting columns - except there is little room for customization: I can't add my own types of columnns that can then be directly ...
1
vote
0answers
273 views

CDX currupt index file & Windows 2003 Server

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings. We are running an old application ...
1
vote
1answer
67 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
2
votes
4answers
10k views

Where to store\update tnsnames.ora file when installed oracle client only?

I installed the oracle client only but was told to update my tnsnames.ora file with the info my dba sent me. But I don't have a tnsnames.ora file. On another machine with a full oracle admin install ...
1
vote
1answer
195 views
0
votes
3answers
316 views

Method to convert Zipcodes to Addresses

At my mother's workplace, she often accesses the database and pulls out numbers in order to form reports. From selecting data Oracle to outputting reports in Excel format, she has come across this ...
2
votes
0answers
52 views

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle. ...
0
votes
0answers
120 views

How to restore mysql databases from file disk

I used to have a few mysql databases on my system, but my operating system crashed and I cannot access the installed mysql service anymore. The only thing that I have is access to the database files ...
3
votes
4answers
678 views

QnA Knowledge base software [closed]

I'm looking for a small software to build a knowledge base of QnA's on my local PC, like the KBs large software vendors maintain for how-to's regarding their products. Something where I can: Q: ...
0
votes
1answer
3k views

SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) - What does this error mean?

I get following error when i try to connect via "HeidiSQL" to my database server (local network) SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) SSH Connection via Putty works ...
1
vote
1answer
125 views

Is there an off-the-shelf database solution similar to asihollywooddatabase.com or imdb? [closed]

What off-the-shelf database solutions would allow me to do the same thing as asihollywooddatabase or something similar to IMDB without having to write the software from scratch. I have little ...
0
votes
3answers
218 views

Does Google Chrome have some primary key in its cookies database?

I am writing some scanner for Google Chrome cookies, as stored in a SQLite database. It also has an option to delete cookies, however I didn't find any ID field. The most similar is creation_utc, I ...
2
votes
3answers
104 views

Charity membership drive – using a laptop as a signup form

The situation: I work for a charity, and we frequently go to events where people want to sign up and learn more about the problem we work on and our work. The problem: This requires a) printing ...
0
votes
1answer
611 views

How do I open a Rails Mysql database in Mysql Workbench?

I having trouble finding my mysql database files in Ruby on Rails project and opening it in MysqlWorkbench This is my folder structure for a app This is my database.yml development: ...
1
vote
1answer
196 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
0
votes
1answer
2k views

I'm trying to add a VPN through the network setting on OSX

I'm trying to add a VPN through the network setting on OSX. I have added the credentials through iOS on my iPhone, they check out and I'm then connected. I'm connecting to a PPTP. Example: Server ...
1
vote
1answer
2k views

Difficulty connecting to a database with Primavera P6

I'm having trouble connecting to Primavera P6 (project). When I enter my username and password, I receive an error: This user is already logged in... The password was never changed.
2
votes
0answers
125 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
0
votes
1answer
204 views

Where is the 'Query Options' command in Word 2010?

I want to attempt a mail merge by category. Was it removed from the app?
-1
votes
1answer
291 views

database structure “customers” table having several orders per customer and several items per order [closed]

I want to create a database that has several customers and many orders per each customer and each order has several items in it. I was thinking of creating a table for each order and populate each ...
0
votes
1answer
91 views

Move multiple SQL Server 2008 databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...
2
votes
1answer
774 views

How to export and import an user profile from one Quassel core to another?

I have been using Quassel as my bouncer for IRC for quite a long time now. We (a group of administrators of a small network) have set up a shared Quassel core with many users on the same core. But ...
0
votes
1answer
272 views

Amazon Cloud as a Server with alot of RAM [closed]

I need a server with very big size of RAM, so around a ~1TB, for a GIS DB, that would be not written to hard disk, because the data is irrelevant after a seconds. So i do not need a lot of disk space, ...
0
votes
2answers
210 views

Where is the Riak CentOS installation directory?

Used "yum install riak" on CentOS 5.8, and easily found the config files in /etc/riak. However, I can't find where the data files and installation files are located. Anyone know where they are? ...
1
vote
2answers
451 views

this database is not compatible with this application - Application compatibility toolkit

I installed the Windows Application Compatibility Toolkit and installed SQL server 2012 express to use as the database server. When I run ACT and try to create or select a database, it puts a little ...
0
votes
1answer
316 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
0
votes
1answer
405 views

Excel SUM or COUNT based on related fields from two Tables

I have two tables in Excel The small table with 50 rows...tblGroups[#Headers]= Employee ID; Name; Group. The second table with 3000+ rows...tblData[#Headers]= EventID; Date; Employee ID; ...
1
vote
1answer
1k views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
-1
votes
1answer
573 views

How to update a Powerpoint slide with an external database?

I have a database of 1000 users with their name, number, photos, addresses, and other fields, etc. (in RDBMS-like say mysql, PostgreSQL). But I want to implement this mostly in Excel. So what I want ...
0
votes
0answers
320 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
0
votes
1answer
67 views

Sort by selection..spreadsheet software

I am so frustrated... I use ArcMap a lot and therefore I use the 'show selected features' a lot when I am in the attribute table. Now I need to manipulate a csv file in excel with 150,000+ records ...
1
vote
3answers
11k views

.pdb file viewer or reader tools?

I have a lot of files in .pdb (as in a Palm Pilot Database) format, major of them downloaded, but until now I can't using or read what the inside, so I looking for how to read, view the .pdb file ...
0
votes
1answer
2k views

How to access my database stored in PHPMyAdmin from different computers?

I am working on my Java application in Eclipse that connects to the database and makes some queries with the data. This database has been created and managed in PHPMyAdmin. The database is stored ...
2
votes
2answers
9k views

Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
1
vote
0answers
107 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...