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

learn more… | top users | synonyms

1
vote
1answer
22 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
27 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
17 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
45 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
56 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
32 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
46 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
51 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
152 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, ...
4
votes
2answers
4k 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?
0
votes
0answers
96 views

Running MongoVUE using Wine

I am getting error dialog INVALID PARAMETER after clicking okay button THERE IS NO WINDOWS PROGRAM CONFIGURED TO OPEN THIS TYPE OF FILE Please someone link me portable link for mongoVUE and ...
1
vote
0answers
28 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
276 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
2k 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 ...
0
votes
0answers
512 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
0answers
416 views

How to connect to remote named SQL Server instance via ODBC from Ubuntu running on VirtualBox?

I have Ubuntu 12.04 installed on VirtualBox. It is connected to the local network via bridge adapter. How can I access named SQL Server instance, which is running on a different Windows machine in the ...
0
votes
1answer
62 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
121 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?
0
votes
0answers
449 views

Got some error after Sqlplus installation . . Need help?

I install sqlplus using these steps https://help.ubuntu.com/community/Oracle%20Instant%20Client but I am getting error while type "sqlplus" **sqlplus: error while loading shared libraries: ...
1
vote
2answers
277 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
1k 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
209 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 ...
8
votes
2answers
22k 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, ...
3
votes
1answer
8k 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
2k 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
901 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
2k 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
199 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?