SQL is a programming language designed for managing data in relational database management systems (RDBMS).

learn more… | top users | synonyms

0
votes
1answer
27 views

What path shall I find schema.sql?

I am looking for file named "schema.sql", can someone let me know where can I find it? when I googled a little about it I go one path i.e. /etc/raddb/sql/mysql/schema.sql however it does not exists ...
0
votes
0answers
16 views

Problem installing sqlplus

i was refering this answer but i couldn't proceed from the line of creating oracle configuration Create Oracle configuration file: sudo sensible-editor /etc/ld.so.conf.d/oracle.conf //this command ...
0
votes
1answer
71 views

SQLSTATE[HY000] Unknown host machine name (severity 2)

I have a problem in which I can not find a solution and I was hoping that you could help me out. I rolled back my server and now none of the php scripts can now connect to other servers. The scripts ...
0
votes
0answers
57 views

Installing sql*plus on Ubuntu 14.04

I tried installing sql*plus on Ubuntu 14.04 by following 1, 2 and 3. But after downloading Instant Client I still facing following error; sqlplus: command not found I am new to Ubuntu, guide me to ...
1
vote
0answers
173 views

Error message odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]

I'm trying to get my Ubuntu server to connect to my SQL server, without a lot of luck. I keep getting the error: Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect ...
1
vote
1answer
97 views

PostgreSQL importing from folder

I lost my ubuntu partition (12.04) and I've installed the ubuntu 14.04, I could save my database files from postgreSQL v9.1, but now I'm with a problem how can I import this data base and my settings ...
0
votes
0answers
16 views

Require the link for. jar file used by SQL Anywhere 16

I wish to download UltraliteJNI16.jar so that I can sync by SQL Anywhere 16 on an Android device. I am unable to find the jar, and SQL Anywhere 16 is available only on Linux for which the jar is in ...
0
votes
0answers
59 views

How to export Observium data?

Trying to figure out how to export the data from Observium to see the throughput of a network, and save it to a file. Any help would be great.
2
votes
1answer
48 views

Charset with driver for Microsoft-SQL

I have got a form on a PHP website on an Apache on an Ubuntu-Server, to write data in a Table of a Microsoft SQL-Server. The Charset of the Website is UTF-8 and the Charset of the SQL-Server is ...
4
votes
2answers
12k views

How to install sql developer on ubuntu 14.04

I am trying to install SQL developer on Ubuntu 14.04. I have fallowed some tutorials but none of them worked. So I am asking you if you know how to install Sql developer.
1
vote
1answer
140 views

How to connect to SQL SERVER using php?

I have Microsoft SQL Server 2008 on Windows PC but my PHP is on Ubuntu, hosted by webfusion. I haven't configured anything at all but I want PHP to connect to SQL Server. What drivers do I need and ...
0
votes
0answers
91 views

unixodbc Driver manager error

While trying to connect with MSSQL am getting the the below error "DBAPIError: (Error) ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/lib/odbc/libtdsodbc.so' : file not found ...
1
vote
1answer
19 views

Users in MySQL have too many rights

I finally found out how to install phpmyadmin and get a working internet connection in virtual box after a lot of research. Now, I addes users and gave them specific rights for testing purposes. The ...
0
votes
1answer
129 views

SQL Anywhere , Ubuntu 12.04 x86

I need to make a server in my company. IMG of my MNC has refused to provide any help on Linux systems, hence I need to do it without any help. I tried: ⠀Ubuntu 13.10 x86, SQL Anywhere(12-16) both ...
0
votes
0answers
113 views

Oracle configuration in libreoffice base

I am new to Ubuntu; kindly answer to my query even though it is simple... I want to work SQL PLSQL in Ubuntu. So I have downloaded Libre Office base but I am not able to connect to the Oracle ...
0
votes
0answers
58 views

Can I run Windows Based ERP with sql server connectivity in ubuntu 12.04?

I want to install and run my Windows based ERP in Ubuntu, It is SQL based database ERP. And I want to login with my Active Directory credentials. I have Windows 2008 R2 Server as Active Directory ...
0
votes
1answer
163 views

sudo useradd wont make home directory

I have an automatic script which works, only it just never makes a home directory. The data is extracted from a database. Heres the script: $SQL -s -e "SELECT uid, password FROM registrations WHERE ...
0
votes
1answer
97 views

Retrieve data from sql into specified place in text

I'm very new to sql and bash-scripting, but even so I've manage to make a sql-table with coming events. And I manage to make a Script deleting old events and export everything in the table to a ...
0
votes
0answers
167 views

Connecting android app to SQL server on Ubuntu server

Maybe I should ask this question in the Ubuntu section instead, but don't really know where the problem is so I'm trying here first. I'm trying to learn how to use SQL database through a webserver, ...
5
votes
2answers
11k views

How to use SQL in terminal?

I want to create simple tables, insert values in it, and do queries. How to perform them in the terminal?
1
vote
0answers
32 views

SQLPLUS on Ubuntu 12.04 [duplicate]

I'm tryin to install sqplplus on my ubuntu machine, but it didn't really work well till now.. I've did everything in this article.. and tried "sqlplus" and gave me this error.. sqlplus: error while ...
1
vote
1answer
520 views

How to update sqlmap in Ubuntu 12.04

How to update sqlmap in Ubuntu 12.04. It's giving me problem. How do I do this?
2
votes
1answer
4k views

How to connect Ubuntu to a MS SQL server 2005?

I am using Ubuntu 13.04 and I installed Wine 1.6. I am running a dotnet application through Wine, but I am getting the following error message: An error occurred while establishing connection to ...
1
vote
0answers
779 views

How to connect to Oracle 11g with SQL Developer: Vevndor code 17410?

Yesterday I have installed Oracle 11g on Ubuntu 12.04 LTS according to post. I can connect to database using SQL*Plus. However when I try to connect using Oracle SQL Developer i get error(with this ...
0
votes
1answer
68 views

Unable to run PostgreSQL 9.2 [duplicate]

I followed an instruction on how to setup Ubuntu 10.04 with PostgresSQL $ psql Or this: lucid@ubuntu:~$ sudo -u postgres psql postgres [sudo] password for lucid: psql: could not connect to ...
2
votes
2answers
166 views

How to open VDB files under Ubuntu ?

I'm working with a software that uses VDB (VistaDB) to archive log files, while everyone else uses windows and can use the Vistadb software, I'm unable to do so using my Ubuntu OS, does anyone knows ...
1
vote
1answer
1k views

Oracle in Ubuntu [duplicate]

Can I install Oracle SQL Developer or Oracle Express Edition in Ubuntu 12.10 (32 bits) using Java 7? If not, what's the "best" SQL Integrated development environment in this platform?
1
vote
2answers
408 views

Mysql Server shuts down periodically on ubuntu

Mysql Server shuts down periodically on Ubuntu. I looked through the system log file and found the following lines in the log files i checked : Out of memory: Kill process 719 (mysqld) score 114 or ...
1
vote
1answer
2k views

Call to undefined function sqlite_open() in CLI mode

12.04 AMD 64 apt-get install sqlite php5-cli php5-sqlite php -r '$x = sqlite_open();' PHP Fatal error: Call to undefined function sqlite_open() in Command line code on line 1
0
votes
4answers
248 views

Is there a server app in Ubuntu Software Center for PHP?

I'm a beginner learning PHP. I need a server and MySQL. Is there an app in Ubuntu that I can download? I think I have installed something with PHP5 Server-side something. But when I clicked to use ...
13
votes
3answers
31k views

Connecting MS SQL using freetds and unixodbc: isql - no default driver specified

I am trying to connect to the MS SQL database using freetds and unixodbc. I have read various guides how to do it, but no one works fine for me. When I try to connect to the database using isql tool, ...
5
votes
1answer
10k views

Can I run SQL Server on Ubuntu?

My company develops software with two sides: client and server. I've installed Microsoft SQL Server on Windows and am running the client side on Ubuntu with some configuration. But I'm wondering: is ...
5
votes
4answers
3k views

SQL modeling and design tools?

I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu. It would be good if that tool generate SQL scripts, and a plus with those ...
1
vote
1answer
1k views

Are there any tools for working with PL/SQL?

I am currently using Oracle SQL Developer, and it is driving me nuts. I keep getting the message Connection is busy when trying to anything after being inactive in some minutes. Sometimes pressing ...
1
vote
2answers
3k views

pgAdmin III: ERROR: function postgis_full_version() does not exist

I'm running Natty: Attempting to get pgAdmin III running. So I went to the pgAdmin download section for Ubuntu... but did not see Natty instructions. So I downloaded the Natty pgAdmin III .deb from ...
3
votes
2answers
205 views

How do I log in to a database without username and password? [closed]

I want to log in to a database by running a SQL file from a UNIX script without supplying username and password (as root). Any command to do so?