I am trying to connect SQL SERVER VIA JDCB. Following is something I tried and will appreciate any help what I am doing wrong
Here's what I did, I tried several variations, but I keep getting this error:
I tried:
I have never tried this on a sqlserver before, only in oracle.
will appreciate any response at
thanks
sam
Hello
As per requirements, can i Install a MSSQL SERVER on UNIX ,
is it possible., can i install or not.., could u plz give me reply with
some installation details..........
Regards&Thanking You
sreedhar G (1 Reply)
Hi GURUs,
I have following queries:
1) If its possible to configure Microsoft SQL Server database on a UNIX machine, if yes, can any body pls point me to the guide to acheive the same.
2) I know Oracle runs perfectly on UNIX based machines, can any body point me to the guide to achieve the... (6 Replies)
Hello,
my problem is, that I want to send an SQL-Statement via ksh-Shell to an MS-SQL-Database based on SQL Server 2005. I want to receive a file, which can be used for further actions on UNIX (Sun OS 5.9). ODBCUnix and JDBC and FreeTDS are not allowed. Does anybody have a suggestion?
Br,... (0 Replies)
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
Hello All
I am getting a problem.What i want to do is to connect unix(korn shell) and sql server 2005. But it is not happening.
The task is to schedule a job using crown or something else that connect with sql server 2005 and run the query and save the result in a text file. (5 Replies)
Hi All,
I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer.
Now i want to access sql server via. unix.
Could some one please help me in this!!!
Thanks (2 Replies)
I would like to invoke a procedure in SQL server which will return some results of a select query from UNIX script. I would like to invoke this procedure and load the data into a flat file in UNIX.
Can you please help? I am not able to find any sample programs in Internet. (1 Reply)
We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases.
But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this... (0 Replies)
Discussion started by: udara
0 Replies
LEARN ABOUT SUSE
create_server
CREATE SERVER(7) SQL Commands CREATE SERVER(7)NAME
CREATE SERVER - define a new foreign server
SYNOPSIS
CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ]
FOREIGN DATA WRAPPER fdwname
[ OPTIONS ( option 'value' [, ... ] ) ]
DESCRIPTION
CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner.
A foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Addi-
tional user-specific connection information may be specified by means of user mappings.
The server name must be unique within the database.
Creating a server requires USAGE privilege on the foreign-data wrapper being used.
PARAMETERS
servername
The name of the foreign server to be created.
servertype
Optional server type.
serverversion
Optional server version.
fdwname
The name of the foreign-data wrapper that manages the server.
OPTIONS ( option 'value' [, ... ] )
This clause specifies the options for the server. The options typically define the connection details of the server, but the actual
names and values are dependent on the server's foreign-data wrapper.
NOTES
When using the dblink module (see in the documentation), the foreign server name can be used as an argument of the dblink_connect(l) func-
tion to indicate the connection parameters. See also there for more examples. It is necessary to have the USAGE privilege on the foreign
server to be able to use it in this way.
EXAMPLES
Create a server foo that uses the built-in foreign-data wrapper default:
CREATE SERVER foo FOREIGN DATA WRAPPER "default";
Create a server myserver that uses the foreign-data wrapper pgsql:
CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'foodb', port '5432');
COMPATIBILITY
CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
ALTER SERVER [alter_server(7)], DROP SERVER [drop_server(7)], CREATE FOREIGN DATA WRAPPER [create_foreign_data_wrapper(7)], CREATE USER
MAPPING [create_user_mapping(7)]
SQL - Language Statements 2010-05-14 CREATE SERVER(7)