9 More Discussions You Might Find Interesting
1. AIX
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... (4 Replies)
Discussion started by: Naina2019
4 Replies
2. BSD
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... (11 Replies)
Discussion started by: milhan
11 Replies
3. Red Hat
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)... (3 Replies)
Discussion started by: charli1
3 Replies
4. Red Hat
How do make connection between two linux server.Such as SSH,rsync,ftp (3 Replies)
Discussion started by: Mani T
3 Replies
5. Shell Programming and Scripting
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... (7 Replies)
Discussion started by: nuthakki
7 Replies
6. Linux
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
... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies
7. HP-UX
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 (3 Replies)
Discussion started by: smartyshan
3 Replies
8. Windows & DOS: Issues & Discussions
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... (3 Replies)
Discussion started by: jkuchar747
3 Replies
9. SCO
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,
... (1 Reply)
Discussion started by: knewknow
1 Replies
ODBC_CONNECT(3) 1 ODBC_CONNECT(3)
odbc_connect - Connect to a datasource
SYNOPSIS
resource odbc_connect (string $dsn, string $user, string $password, [int $cursor_type])
DESCRIPTION
The connection id returned by this functions is needed by other ODBC functions. You can have multiple connections open at once as long as
they either use different db or different credentials.
With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a stored proce-
dure that has anything other than a single select statement in it". Using SQL_CUR_USE_ODBC may avoid that error. Also, some drivers don't
support the optional row_number parameter in odbc_fetch_row(3). SQL_CUR_USE_ODBC might help in that case, too.
PARAMETERS
o $dsn
- The database source name for the connection. Alternatively, a DSN-less connection string can be used.
o $user
- The username.
o $password
- The password.
o $cursor_type
- This sets the type of cursor to be used for this connection. This parameter is not normally needed, but can be useful for work-
ing around problems with some ODBC drivers. The following constants are defined for cursortype:
o SQL_CUR_USE_IF_NEEDED
o SQL_CUR_USE_ODBC
o SQL_CUR_USE_DRIVER
RETURN VALUES
Returns an ODBC connection or ( FALSE) on error.
EXAMPLES
Example #1
DSN-less connections
<?php
// Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);
// Microsoft Access
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
// Microsoft Excel
$excelFile = realpath('C:/ExcelData.xls');
$excelDir = dirname($excelFile);
$connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$excelDir" , '', '');
?>
SEE ALSO
For persistent connections: odbc_pconnect(3).
PHP Documentation Group ODBC_CONNECT(3)