AIX to access MSSQL server

10 More Discussions You Might Find Interesting

1. AIX

Samba 3.6 on AIX 7.1 - Windows 10 Access to AIX file shares using Active Directory authentication

I am running AIX 7.1 and currently we have samba 3.6.25 installed on the server. As it stands some AIX folders are shared that can be accessed by certain Windows users. The problem is that since Windows 10 the guest feature no longer works so users have to manually type in their Windows login/pwd...

2. Shell Programming and Scripting

Do I require remote login access to a windows server to transfer files from a UNIX server

Hi All I need to transfer a file from a UNIX server to a windows server. I saw that it is possible to do this using scp command by looking at the forum listed below: ...

3. Proxy Server

How to use Squid on Linux to control certain IP to access Web Server and certain IP cannot access?

Dear all experts here, :) I would like to install a proxy server on Linux server to perform solely to control the access of Web server. In this case, some of my vendor asked me to try Squid and I have installed it onto my Linux server. I would like know how can I set the configuration to...

4. Shell Programming and Scripting

MSSQL or SQL SERVER or SQLSERVER?

hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders. for example: MSSQL SQL SERVER SQLSERVER case $q in a) echo -ne "Work database: " echo "" echo " 1) ORACLE" echo...

5. UNIX for Dummies Questions & Answers

Access of Microsoft Team Foundation Server (TFS) repository from Unix Server

Hello, Some of our application team uses Microsoft Team Foundation server (TFS) reposity tool for their .NET projects , I would like to access it form Unix/Linux machine. Please let me know how can access the TFS from unix. Thanks

6. UNIX for Advanced & Expert Users

IBM directory server - how to restrict AIX client access to read-only

Hello all, I am using IBM Directory Server (as a part of AIX7 extension pack) in an AIX environment. To set up the server I use command: mksecldap -s -a cn=admin -p PWD -S RFC2307AIX -d o=COMPANY -u NONE Then, to set up IDS clients I use the following (I have 2 mutually replicating servers...

7. AIX

Access AIX NFS Share from Windows Server 2008

Hi all, Hopefully this question hasn't been asked a thousand times. I am trying to connect a Windows Server to an exported NFS share which resides on an AIX box. I think the directory is exported correctly from the AIX side but I can't verify that because I didn't do it myself. On the...

8. AIX

Transferring files from one AIX server to another AIX server in binary mode

Hi, I am a newbie to AIX. We have 2 AIX5.3 servers in our environment, I need to transfer some files in Binary mode from one server to another and some files in ASCII mode from one server to another server. Could you please help me as to how I need to do that? Thanks, Rakesh

9. Shell Programming and Scripting

Can a script runned in local server access remote server?

Hi, Im creating a script that is supposed to run commands on remote server using sftp. My script is as below: #!/bin/ksh sftp remote_server mypassword cd /u08/mydir/allfiles mget * .. But this is what I got when I runned the script: Connecting to remote server......

10. Shell Programming and Scripting

connect to mssql

Hi - can any one tell me is it possible to connect to mssql and fetch the data from unix shell scripts

LEARN ABOUT PHP

mssql_connect

MSSQL_CONNECT(3)														  MSSQL_CONNECT(3)

mssql_connect - Open MS SQL server connection

SYNOPSIS

       resource mssql_connect ([string	$servername], [string  $username], [string  $password], [bool  $new_link = false])

DESCRIPTION

       mssql_connect(3) establishes a connection to a MS SQL server.

	The  link  to  the  server  will  be  closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
       mssql_close(3).

PARAMETERS

	      o $servername
		- The MS SQL server. It can also include a port number, e.g.  hostname:port (Linux), or hostname,port (Windows).

	      o $username
		- The username.

	      o $password
		- The password.

	      o $new_link
		- If a second call is made to mssql_connect(3) with the same arguments, no new link will be established,  but  instead,  the  link
		identifier  of	the  already opened link will be returned. This parameter modifies this behavior and makes mssql_connect(3) always
		open a new link, even if mssql_connect(3) was called before with the same parameters.

RETURN VALUES

	Returns a MS SQL link identifier on success, or FALSE on error.

CHANGELOG

       +--------+------------------------------------+
       |Version |				     |
       |	|				     |
       |	|	     Description	     |
       |	|				     |
       +--------+------------------------------------+
       | 5.1.0	|				     |
       |	|				     |
       |	|  The $new_link parameter was added |
       |	|				     |
       +--------+------------------------------------+
EXAMPLES

       Example #1

	      mssql_connect(3) example

	      <?php
	      // Server in the this format: <computer><instance name> or
	      // <server>,<port> when using a non default port number
	      $server = 'KALLESPCSQLEXPRESS';

	      // Connect to MSSQL
	      $link = mssql_connect($server, 'sa', 'phpfi');

	      if (!$link) {
		  die('Something went wrong while connecting to MSSQL');
	      }
	      ?>

SEE ALSO

       mssql_close(3), mssql_pconnect(3).

PHP Documentation Group 													  MSSQL_CONNECT(3)

AIX