The database tag has no wiki summary.
-2
votes
1answer
35 views
Is it possible Connect landphones to mysql? [closed]
I have a land phone that displays the caller ID.
I want to use a some interface or cable to connect the phone to a pc and then connect it to mysql, check if the user is available in the database, and ...
0
votes
0answers
63 views
Compile IMDB search programs and database on OS X, possible stack size increase
I am trying to compile the IMDB search programs with the corresponding databases, but somehow I am unable to do so. Here are the infos, here is the direct link to the files (Warning: it links to an ...
0
votes
1answer
29 views
How can I create an ERD for my phpmyadmin database?
Is there a way I can create an ERD for my PHPMyAdmin database?
0
votes
0answers
12 views
Query 1 field using 2 field for where clause [migrated]
i have table like this :
Column | Type | Modifiers
---------------+-----------------------------+-----------
id | smallint | not null
...
1
vote
1answer
37 views
Database structure for handling multiple accounts (Multi-Tenant Data Architecture)?
It's always easy to write software that handles a single entity. However, designing software to handle multiple accounts/companies requires due diligence.
I'm currently doing initial research into ...
2
votes
0answers
35 views
Join multiple consecutive SQLite database dump files into 1 common database? Purpose: Search through ENTIRE Chrome Browsing History
Google Chrome 's default web browsing history search engine only lets you access the records of the recent 100 days.
Nevertheless in your application data, Chrome keeps your entire browsing history in ...
1
vote
0answers
30 views
How to export and import an user profile from one Quassel core to another?
I'm using for quite a long time Quassel as my bouncer for IRC.
We (a group of administrators of a small network) have set up a shared Quassel core with many users on the same core.
But now I would ...
1
vote
1answer
30 views
Why would a DB connection over LAN be slower than a WAN connection?
I'd noticed for ages that a MySQL database connection over my LAN was significantly slower than a database connection over the Internet.
I'm running Windows 7 32bit and I'm connected to a switch ...
0
votes
1answer
32 views
Merging Database Modifications - CVS
I'm working on a project using git for version handling. What is the best approach to include the database in the cvs?
For example, if I checkout the database and install it at home, make some ...
0
votes
2answers
58 views
How to setup anonymous FTP for file upload
I want to have a FTP server setup that allows clients to upload large files (2GB+ database dumps) by SFTP. The important point is that I want clients to log into the server with a single username and ...
-1
votes
0answers
30 views
Reading a text file using utl_file package [closed]
I have this text file :
#
#
#
DATE=20120105
QVN Index,aaa,0.75757
Q1W Index,sss,0.832899
M Index,aaa,0.3232
M Index,sss,0.34232423
I wrote a code to read file to database using utl_file package, ...
2
votes
2answers
73 views
In need of a movie library application
I'm looking for a (hopefully) open-source movie library/database application to be able to navigate my 2000+ movie collection (all in digital files, ripped from owned DVDs). My platform is Linux (so ...
0
votes
0answers
8 views
sending data in a file.txt by oracle store procedure using utl_file package [migrated]
I want to send data in a file.txt to a table in databse by oracle store procedure using utl_file package,
the file.txt contain:
QRIFR6M Index,BID,0.7875, aaa
QRIFR9M Index,BID,0.8625, bbb
QRIFR1Y ...
0
votes
0answers
7 views
Access 2010. Create list of checkboxes (automatically) for seperate values, not multivalue
I'm trying to create a form whereby I can add multiple values to a table, I want to select the values using a list of check boxes, but there are a lot of values- is there anyway to automatically ...
2
votes
1answer
53 views
Possibe data corruption in x-ray room
I built a small fingerprint ID system for a lab. Registration is done at a reception and identification at 2 other points. One point is the x-ray room
The problem: Identification often seems to fail ...
0
votes
1answer
17 views
How to convert access database to firebird format?
Is there a way to directly convert an access database to fdb(firebird) format using microsoft access? If not what's the best way?
0
votes
0answers
18 views
is there a better fulltext db than mysql &how to get help to go on line? [closed]
three issues.
i developed a nice classified ads website in php using mysql/myisam. now i find that people say myisam crashes and corrupts db after 100+ users online. so i want an easy replacement ...
0
votes
0answers
63 views
Importing a CSV table into Libreoffice Base
I'm trying to import a large CSV table into a Libreoffice Base database. From a google search it sounds like the way to do this involves opening the CSV in calc, select all + copy, paste into Base. Is ...
1
vote
1answer
54 views
Evernote Note filesize
I wonder if there is an option (inside of Evernote or outside of it, manually with the help of 3rd party tools) to locate the biggest notes inside of Evernote? I want to remove those or put them into ...
1
vote
0answers
29 views
How can I move the database location of Evernote successfully?
I am currently on Evernote 4.5.x and lost quite some data because I didn't notice that the crashing Evernote deleted recently created notes due to space limitations in my TC container.
I am not happy.
...
1
vote
2answers
45 views
Free Database Browser for PostgreSQL?
Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...
1
vote
3answers
96 views
Free software to replace SQL Developer?
As for a developer, the use of SQL Developer is almost daily. However, given that my laptop have only 1 gb ram, it is hard to open SQL Developer and Eclipse together. Do you have any lighter ...
1
vote
1answer
37 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
2answers
128 views
Linux Mint (Ubuntu) Microsoft Access Replacement?
I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access.
I'm aware of LibreOffice (which comes installed), are there any others I ...
3
votes
1answer
104 views
SQL Server Management Studio ignores default DB
When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
0
votes
1answer
28 views
Disabling a root password for a PHP website
I have transferred a PHP/mySQL site to a different ISP. The clients want to protect access. I don't really want to change the Admin login - that is programmed using salt.
I was thinking of creating a ...
0
votes
0answers
46 views
getting complement of two text files on unix command line
Can someone recommend a fast unix-based utility (ideally written in C) for getting efficient, streaming intersection/union of tab-delimited text files? For example, allow queries such as "give me the ...
0
votes
1answer
25 views
ADODB Connection - Webserver doesn't resolve the hostname of the mssql server
I have a mssql connection resource file as belows:
<% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data ...
0
votes
1answer
38 views
Take all fields in a database table and put them straight into a text file
I have an database file (mdb) file that contains a dictionary of words. A couple thousand of them. I just need the words (in the order they are already in) put into a text file. Currently they have ...
1
vote
1answer
27 views
How do I connect to a database without seeing all the other databases on the host?
I'm using Microsoft SQL Server Management Studio 2008 R2, I followed the instructions from my host and I'm successfully able to connect to my database, but I also happen to see all of the databases on ...
2
votes
1answer
32 views
Trouble installing OpenCOBOL
When I ./configure, I get this error:
configure: error: libdb is required
I signed up for an Oracle account (yak shaving), downloaded Berkeley DB, untarred and unzipped, wrestled with the unhelpful ...
0
votes
2answers
52 views
Which components are essential for a computer? [closed]
I am writing a web application prototype for computer assembly and was wondering which components are essential. I do not have the time to include every component, as I would need to get database data ...
0
votes
0answers
46 views
Access 2010 forms: direct entry of foreign key into text box
In a form I am creating for an MS Access 2010 database, one of the fields represents a foreign key. I would like this field to be displayed as a text box, rather than as a combo or list box as is ...
1
vote
0answers
21 views
Converting an SVN repository to SQL database
I have downloaded the svn repository of Atunes using TortoiseSVN. I would like to transfer the logs of activity of the developers to a SQL database, preferably an Oracle one. Is there any software ...
2
votes
1answer
74 views
0
votes
1answer
18 views
Opening a database made in SQL Server 2008 Developer Edition in SQL Server 2008 Standard Edition
I have a database built in SQL Server 2008 Developer Edition but am unable to open it in SQL Server 2008 Standard Edition. It says the version of my SQL Server is too old.
How can I solve this ...
0
votes
2answers
25 views
How do I relate these access tables without losing data?
I have an excel flat file with about ~6k records I want to put into a MS Access database. The original Excel fields are:
Name
Address
City
State
Zip
DOB
CaseNumber
DateSentenced
AmountDue
I saved ...
2
votes
0answers
89 views
Free Tool to Generate Diagram of SQLite Database
I tried using openoffice via ODBC, and it connected properly, but when I tried to use tools->Relationships... , it gave me the error message "The database does not support relations."
I'm using OOo ...
1
vote
0answers
94 views
Sybase 12.5: how to bcp in/out a table with a 'text' field
I have a table of this structure
create table test {
id_data int identity,
data text
// id_data is the primary key
}
I used the following commands:
bcp DB..test out prod.bcp.out -U me-P pwd ...
2
votes
1answer
77 views
How do I give a single user permissions over a schema in MySql Workbench?
I have a MySql server installed on a server along with MySql Workbench.
About a year ago, I managed to do this and I felt like slapping myself as it was something so simple, but, I just can't ...
0
votes
0answers
18 views
Exclude error message for a single file from Backup Exec logs?
The file (a Lotus Notes database) can be restored and is readable without any errors. Error Message in the log: "This file cannot verify". This error only happens on weekly full backup. I know, I can ...
0
votes
1answer
182 views
How do I make a dump of a MS SQL database using SQuirreL SQL?
Unfortunately I cannot use Microsoft's database tool to access my MS SQL server, so I need to use another tool like SQuirreL SQL.
How can I make a backup (i.e. dump) of the database?
0
votes
0answers
36 views
Tool for deleting all tables in a database
Is anyone able to point me in the direction of a tool/script that will drop all tables from a specified database connection? Ideally Java/JDBC.
I have a development database and don't have much ...
2
votes
1answer
54 views
Add data to a database, without physical access to the server machine
I have two computers in a client / server architecture. The server runs SQL Server. The client has to provide an interface to insert data to this database.
I know that this can be achieved with ...
0
votes
0answers
39 views
Getting into proprietary software's Firebird database file?
An application uses a firebird database (.FDB) that I would like to access programatically. Is there a way to find out how the database is laid out and if there is a way to access the data (or my ...
1
vote
0answers
48 views
Searching a CSV or Excel file for terms from one column of another Excel file [closed]
I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open ...
0
votes
0answers
96 views
How to configure automatic backup for MySQL from Workbench?
I want to configure scheduled backup of my db's, regularly export to 1 file all db's. Is it possible with the help of Workbench? If it's possible how to do it? Please explain step by step. My os is ...
2
votes
4answers
152 views
How to port an Access database to the Mac?
I am 100% Mac now, but have an important Microsoft Access database on an old PC. Every few months I have to break it out to get into the database. What are my cheapest options for liberating myself ...
0
votes
1answer
30 views
Comparing Access Tables
I have two Access database tables containing place names.
Table A contains 30,000 places and Table B contains 25,000 places.
How can I end up with Table C that only contains the 5,000 places that ...
2
votes
3answers
88 views
Is there a GUI interface for sqlite?
Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
