Establish ODBC connection from Linux

9 More Discussions You Might Find Interesting

1. AIX

Unable to establish connection over TLS 1.2 on AIX 7.1/7.2

Hello Team, I would need your help to enable communication over TLS1.2 on AIX 7.1 or 7.2 with IBM JDK 1.8 latest update. By default, the request is trying to establish a connection over TLSv1 even though TLS 1.2 is explicitly enabled on server as well as on Java 8. The openssl command throws...

2. BSD

Can't establish outbound ssh connection on an OpenBSD system

I am getting the below error when I try to make outbound ssh from an OpenBSD system. I can't ssh to any host except the localhost. I can ping the hosts which I can't ssh, though.~ uname -rs OpenBSD 6.1 ~ ssh -V OpenSSH_7.5, LibreSSL 2.5.2 ~ ssh hostname ssh: connect to host hostname...

3. Red Hat

Proxy tunneling failed: ForbiddenUnable to establish SSL connection.

Tryied both ways curl and wget wget --no-check-certificate https://mysitet.it:61617 --2017-05-05 17:29:02-- https://mysitet.it:61617/ Connecting to myproxy:8080... connected. Proxy tunneling failed: ForbiddenUnable to establish SSL connection. curl https://mysite.it:61617 curl: (56)...

4. Red Hat

Connection establish two server

How do make connection between two linux server.Such as SSH,rsync,ftp

5. Shell Programming and Scripting

Cron job fails with [DataDirect][ODBC lib] Connection not open error

Hi, When run the script directly...it executes as expected. But when put it in crontab the job fails with this error: Connection not open 08003: Connection not open Unable to connect to the database... how come it is not able to connect when cron job fires?... Do I need to...

6. Linux

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Data source name not found, and no default driver specified ERROR: Could not SQLConnect ...

7. HP-UX

Xterm :Cannot establish a connection to "Server IP" on port 22

Dears, I installed HP-UX Server, when I tried to reach it through Xterm it returns the error like Xrcmd Cannot establish a connection to "Server IP" on port 22 Anyone here to tell me the reason(s) find attached xterm.jpg

8. Windows & DOS: Issues & Discussions

Oracle 9i ODBC connection

I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message �The listener supports no services�. I...

9. SCO

SCO ODBC connection to Vista?

Hi, I'm trying to make an odbc connection to a SCO db using Vista, but I'm having some troubles. In the past I have used Vision97 on either windows 98 and XP, but it will not install on Vista. Is there an alternative driver that I can use to make my connection? Any other workaround? Thanks, ...

LEARN ABOUT PHP

odbc_setoption

ODBC_SETOPTION(3)							 1							 ODBC_SETOPTION(3)

odbc_setoption - Adjust ODBC settings

SYNOPSIS

       bool odbc_setoption (resource  $id, int	$function, int	$option, int  $param)

DESCRIPTION

	This  function	allows fiddling with the ODBC options for a particular connection or query result. It was written to help find work around
       to problems in quirky ODBC drivers. You should probably only use this function if you are an ODBC programmer and understand the effects the
       various	options will have. You will certainly need a good ODBC reference to explain all the different options and values that can be used.
       Different driver versions support different options.

	Because the effects may vary depending on the ODBC driver, use of this function in scripts to be made publicly available is strongly  dis-
       couraged.  Also,  some ODBC options are not available to this function because they must be set before the connection is established or the
       query is prepared. However, if on a particular job it can make PHP work so your boss doesn't tell you to use a commercial  product,  that's
       all that really matters.

PARAMETERS

	      o $id
		- Is a connection id or result id on which to change the settings. For SQLSetConnectOption(), this is a connection id. For SQLSet-
		StmtOption(), this is a result id.

	      o $function
		- Is the ODBC function to use. The value should be 1 for SQLSetConnectOption() and 2 for SQLSetStmtOption().

	      o $option
		- The option to set.

	      o $param
		- The value for the given $option.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      odbc_setoption(3) examples

	      <?php
	      // 1. Option 102 of SQLSetConnectOption() is SQL_AUTOCOMMIT.
	      //    Value 1 of SQL_AUTOCOMMIT is SQL_AUTOCOMMIT_ON.
	      //    This example has the same effect as
	      //    odbc_autocommit($conn, true);

	      odbc_setoption($conn, 1, 102, 1);

	      // 2. Option 0 of SQLSetStmtOption() is SQL_QUERY_TIMEOUT.
	      //    This example sets the query to timeout after 30 seconds.

	      $result = odbc_prepare($conn, $sql);
	      odbc_setoption($result, 2, 0, 30);
	      odbc_execute($result);
	      ?>

PHP Documentation Group 													 ODBC_SETOPTION(3)

Shell Programming and Scripting