Sponsored Content
Full Discussion: Unix to Sql Server via JDBC
Top Forums Shell Programming and Scripting Unix to Sql Server via JDBC Post 302168549 by Smiling Dragon on Monday 18th of February 2008 11:11:11 PM
Old 02-19-2008
Quote:
will appreciate any response at xxx@xxx.com
Please read the rules before posting, in this particular case, rule 10
Quote:
(10) Don't post your email address and ask for an email reply. Don't send a private message with a technical question. The forums are for the benefit of all, so all Q&A should take place in the forums.
The exact format of the URL will depend on what you are using to connect but the format I know for talking to SQL server instances is:
jdbc:<client>:mssqlserver4:<instancename>@<ip/dns>:<port>
Munging the data in your supplied URL would produce:
jdbc:microsoft:sqlserver:IE@133.5.144.155:1433

You'd probably do better looking at your client config manual for the exact config file syntax to use.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Installing Ms Sql Server 2000 On Unix

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)
Discussion started by: sreedhargunda
1 Replies

2. 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

3. Shell Programming and Scripting

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,... (0 Replies)
Discussion started by: usagi67
0 Replies

4. Programming

JDBC code to pass the SQL query as parameter and execute?

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)
Discussion started by: laknar
0 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. Emergency UNIX and Linux Support

How to connect Unix and Sql Server 2005?

Hi All Can any one please help me about How to connect Unix with Sql Server 2005 I want to do it urgently and i didn't find the way. (14 Replies)
Discussion started by: parthmittal2007
14 Replies

7. 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

8. 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

9. IP Networking

Connection to DB from client server through jdbc:Oracle:Oci8 fail

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
icapnotify(1M)															    icapnotify(1M)

NAME
icapnotify - Test email connectivity to HP for Instant Capacity (iCAP) systems. Request a confirmation response email from HP. Turn config- uration change notification and asset reporting on or off. SYNOPSIS
icapnotify <reply_address> icapnotify -a on|off icapnotify -n on|off Obsolescent: icod_notify <reply_address> icod_notify -a on|off icod_notify -n on|off DESCRIPTION
When a reply_address is specified, sends an asset report via email to HP, root, and the specified email address. Confirmation email is sent from HP to the specified reply email address indicating that HP received the asset report email. Note that asset reporting is optional but can be useful for viewing complexwide asset information at the HP Utility Pricing Solutions por- tal (http://www.hp.com/go/icap/portal). The deprecated command provides identical functionality to the command and is maintained for backward compatibility. For detailed information on email configuration and requirements, see the located at /usr/share/doc/icapUserGuide.pdf. Options The command recognizes these options and arguments: -a on|off Turns email asset reporting on or off. This option is used to specify if the Instant Capacity software should send asset reports to HP via email. The command displays the present setting for this option. -n on|off Turns configuration change notification on or off. If specified on, executing the command results in a configuration change notification email sent to the system contact email address summarizing any configuration change. Configuration change notification email can be turned off by specifying off. Configuration change notifications are not sent if the system contact email address is not set. EXTERNAL INFLUENCES
Environment Variables o LANG determines the locale to use for the locale categories when both LC_ALL and the corresponding environment variable (begin- ning with LC_) do not specify a locale. If LANG is not set or is set to the empty string, a default of C is used (see lang(5)). o LC_CTYPE determines the interpretation of single- and multiple-byte characters. o LC_MESSAGES determines the language in which messages are displayed. If any internationalization variable contains an invalid setting, icapnotify behaves as if all internationalization variables are set to C (see environ(5)). International Code Set Support Single- and multiple-byte character code sets are supported. RETURN VALUE
The command exits with one of these values: 0 Command succeeded. >0 Command failed; error message sent to STDERR. EXAMPLES
Test email connectivity with HP by sending an asset report to HP, root , and super_user@corp.com, and request a confirmation email from HP to be sent to super_user@corp.com: icapnotify super_user@corp.com Turn email asset reporting on: icapnotify -a on Turn email asset reporting off: icapnotify -a off Turn configuration change notification on: icapnotify -n on Turn configuration change notification off: icapnotify -n off AUTHOR
was developed by HP. SEE ALSO
icapmodify(1M), icapstatus(1M), icapmanage(1M), icapd(1M), icap(5). icapnotify(1M)
All times are GMT -4. The time now is 08:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy