Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

From Solaris UNIX to MS SQL Server

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting From Solaris UNIX to MS SQL Server
# 1  
Old 03-11-2008
From Solaris UNIX to MS SQL Server
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,
Misha
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Invoking sql server from UNIX

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)
Discussion started by: madhu.sushmitha
1 Replies

2. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies

3. Windows & DOS: Issues & Discussions

SQL Server import csv or txt on a Solaris box

New to using sql server and unix, but say I have here /home/foo/file.txt Can I use some kind of process to push that .txt into a sql server? Or Is there a sql server utility that can be configured to find a unix box and go into /home/foo/file.txt and slurp it up:) Or is there any PC and... (5 Replies)
Discussion started by: sas
5 Replies

4. Shell Programming and Scripting

Unix and SQL server

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)
Discussion started by: preetpalkapoor
2 Replies

5. Shell Programming and Scripting

Unix with sql Server 2005

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)
Discussion started by: parthmittal2007
5 Replies

6. Solaris

bcp and isql for MS SQL Server on Solaris?

After dumping data from an Oracle database running on Solaris into a flat file, we need to run bcp and isql for MS SQL Server on the same Solaris box. Does Microsoft provide some tools that run on Unix? Thanks for your assistance. (2 Replies)
Discussion started by: tomstone_98
2 Replies

7. Shell Programming and Scripting

Unix to Sql Server via JDBC

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: Exception in thread "main" java.sql.SQLException: Unable to connect. Invalid URL I... (1 Reply)
Discussion started by: cqldba
1 Replies

8. Shell Programming and Scripting

Can SQL Server call be made from unix sh

Hi, I need to make SQL Server procedure call (exec <proc name>)from unix shell script. First of all I would like to know if it is possible. I know we can do it from Oracle but not sure about SQL Server. Version: SunOS 5.8 SQL 8.0 I have made the below entry in the interface file. NSXNA267 ... (0 Replies)
Discussion started by: sspreethi
0 Replies

9. UNIX for Dummies Questions & Answers

MS SQL Server on UNIX

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)
Discussion started by: patras
6 Replies

10. Shell Programming and Scripting

(perl) Microsoft SQL Server client for solaris. cant find it...

let me save everyone the pain that it caused me. This is all free. And make sure it is in this order 1) make sure you have the latest version of perl installed 2) make sure you have NET:aemon installed 3) make sure you have RPC::PlServer & PlClient (the bundle has both) 4) make sure... (3 Replies)
Discussion started by: Optimus_P
3 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

pdo_sqlsrv-dsn

PDO_SQLSRV-DSN(3)							 1							 PDO_SQLSRV-DSN(3)

PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases

	The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		- The DSN prefix is sqlsrv:.

	      o APP - The application name used in tracing.

	      o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).

	      o Database - The name of the database.

	      o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).

	      o Failover_Partner  - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
		server is unavailable.

	      o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.

	      o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).

	      o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use  legacy  Transact-SQL  rules  (0	or
		false).

	      o Server - The name of the database server.

	      o TraceFile - Specifies the path for the file used for trace data.

	      o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.

	      o TransactionIsolation   -  Specifies  the  transaction  isolation  level.  The  accepted  values  for  this  option  are  PDO::SQL-
		SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
		SRV_TXN_SERIALIZABLE.

	      o TrustServerCertificate	-  Specifies  whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
		tificate.

	      o WSID - Specifies the name of the computer for tracing.

       Example #1

	      PDO_SQLSRV DSN examples

	       The following example shows how to connecto to a specified MS SQL Server database:

	      $c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

	       The following example shows how to connect to a MS SQL Server database on a specified port:

	      $c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");

	       The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you  connect  to  SQL
	      Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).

	      $c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");

PHP Documentation Group 													 PDO_SQLSRV-DSN(3)