FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL Connection





Jurado
Hello,

Im trying to learn some Oracle SQL at school, they have an Unix system, but i want to test scripts at home etc. on a windows XP. So i have downloaded Oracle SQL Development. I make a script :
Create table spelers ( snr smallint not null,
naam char(20) not null,
vl char(5),
primary key (snr)
);

And then i want to run it, however, then this message appears:
The target Untitled.sql cannot be started because it is not a runnable target

Someone stated that i should set up a connection, So i choose new connection, but then i dont know what i have to do.

Can someone tell me how to setup the connection?

Thanks in advance,
kvvardhan
Even I have same problem working with SQL, If you know the solution please put it here...
AftershockVibe
I've never used Oracle, but I have used plenty of other DBMSs. Before you can run that query to create a table you'll need to create a database, then select it for use. If you haven't got a GUI program to help you, then you'll need to look up the database creation syntax.

However, once that's sorted or if there is already a default set up, selecting the database is as simple as the command:
Code:
use <database name>;
jmlworld
Connection to the database is required so you can run queries and scripts. Your problem seems that you are not connected to the database.
albuferque
­Oracle Database supports connections between SQL Command Line (SQL*Plus) and the database either locally, or remotely over a TCP/IP network. The method depends on whether you are initiating a local connection or a remote connection. You can connect to your oracle database using:

CONNECT username/password@[//]host[:port][/service_name]
Related topics
Help: SQL error after uploading new files(thread updated)
script backup database
[man] phpBB 2.0.19 (Style Changer/Demo Mod) SQL Injection
Mysql question!
MySQL HELP!!
How can I create a User account and password for my website?
PHP and SQL Server
Problems with SQL
SQL error
Problem with my SQL Server (not Frihost)
Database connection class!
Move database to different SQL server
SQL: 1 connection or several
MySql -Connecting problems
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.