Sockets

Is it possible to connect to Sybase ASE using Unix domain sockets
instead of TCP/IP?

Paul Ryland
dpar2@cam.ac.uk

0
Davin
6/29/1999 5:43:15 PM
sybase.sqlserver.linux 1108 articles. 1 followers. Follow

3 Replies
538 Views

Similar Articles

[PageSpeed] 36

Davin Yap wrote:
> 
> Is it possible to connect to Sybase ASE using Unix domain sockets
> instead of TCP/IP?

Not that I know of.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
0
Michael
6/29/1999 9:19:43 PM
This is a cryptographically signed message in MIME format.

--------------msA85E21818DD8367FB1957F87
Content-Type: multipart/mixed;
 boundary="------------875FE14C0BFB4EFCA3E80B74"

This is a multi-part message in MIME format.
--------------875FE14C0BFB4EFCA3E80B74
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Davin Yap wrote:

> Is it possible to connect to Sybase ASE using Unix domain sockets
> instead of TCP/IP?
>
> Paul Ryland
> dpar2@cam.ac.uk

Hi Davin,

OpenClient/ODBC etc uses TCP style packets not UDP.  If you want to use
UDP or other packets, you will have to use the OpenServer and handle the
user connections directly.  As UDP packets are not guaranteed to arrive
from the server/client, you will have to take this into account.  It can
be done but I'm not saying it would be easy.

It might be a fun project to play with.  I don't forsee any practical
purposes of using UDP instead of TCP.   IMHO

Jason

--------------875FE14C0BFB4EFCA3E80B74
Content-Type: text/x-vcard; charset=us-ascii;
 name="jfroebe.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Jason Froebe
Content-Disposition: attachment;
 filename="jfroebe.vcf"

begin:vcard 
n:Froebe;Jason 
tel;fax:773-864-7288
tel;work:1-800-8SYBASE
x-mozilla-html:TRUE
url:http://www.sybase.com
org:Sybase, Inc.;Customer Service & Support
version:2.1
email;internet:jfroebe@sybase.com
title:Senior Technical Support Engineer
adr;quoted-printable:;;8755 W. Higgins Road=0D=0ASuite 1100;Chicago;IL;60631;USA
x-mozilla-cpt:;2016
fn:Jason Froebe
end:vcard

--------------875FE14C0BFB4EFCA3E80B74--

--------------msA85E21818DD8367FB1957F87
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIIK0gYJKoZIhvcNAQcCoIIKwzCCCr8CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
CF4wggUoMIIEkaADAgECAhBWn3S/IBuussvP/GEVAMiQMA0GCSqGSIb3DQEBBAUAMIHMMRcw
FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y
azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5
IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRp
dmlkdWFsIFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMB4XDTk5MDYwMjAwMDAw
MFoXDTAwMDExNTIzNTk1OVowggERMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UE
CxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9y
ZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMV
UGVyc29uYSBOb3QgVmFsaWRhdGVkMTMwMQYDVQQLEypEaWdpdGFsIElEIENsYXNzIDEgLSBO
ZXRzY2FwZSBGdWxsIFNlcnZpY2UxFTATBgNVBAMUDEphc29uIEZyb2ViZTEhMB8GCSqGSIb3
DQEJARYSamZyb2ViZUBzeWJhc2UuY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCv
FPO6fvT4mTkuSMHuenfNiFKeea19QVUzhvp+7D2emtmllf3QwwVVy3PIvLmBV0Z0F7THYYZL
0r5vPS1qyoBH1cUicx5kjVKuHYFR2xDbg7Z+/t4xsRTnaM6VKLdSjKplPrv7WQj1ZIj95ffs
M6K4tWBB72+/DdP8gZbC+HpOHwIDAQABo4IBwTCCAb0wCQYDVR0TBAIwADCBrAYDVR0gBIGk
MIGhMIGeBgtghkgBhvhFAQcBATCBjjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cudmVyaXNp
Z24uY29tL0NQUzBiBggrBgEFBQcCAjBWMBUWDlZlcmlTaWduLCBJbmMuMAMCAQEaPVZlcmlT
aWduJ3MgQ1BTIGluY29ycC4gYnkgcmVmZXJlbmNlIGxpYWIuIGx0ZC4gKGMpOTcgVmVyaVNp
Z24wEQYJYIZIAYb4QgEBBAQDAgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0NjUyYmQ2M2YyMDQ3
MDI5Mjk4NzYzYzlkMmYyNzUwNjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcwMTc0N2RhNWQz
ZjIxNDFiZWFkYjJiZDJlODkyMTBhZDZiZjFkMzExNDk5N2EyYmM0NWZmZjNlYTQ1MGMwMAYK
YIZIAYb4RQEGBwQiFiA3OWFlN2UyYmQ5YmJhNGU1ZThmNWI2MDVkNDdlYTc5OTAzBgNVHR8E
LDAqMCigJqAkhiJodHRwOi8vY3JsLnZlcmlzaWduLmNvbS9jbGFzczEuY3JsMA0GCSqGSIb3
DQEBBAUAA4GBAAY5k+xBgvdrkOG7GiOJLghY1MM5IlG+/pwZZd2bu58PHamBx6P+bBa45iNN
Pi7ahuBoKx4j6pAh+d6abx/tzR31I7VZ0nQp8W1M+r+Crg2S+8J7OPamaRCZsRroeyKaoXBJ
WopCWn4arc41pZnFWgbX8P3eMqqDgLl+tmXFDUuIMIIDLjCCApegAwIBAgIRANJ2Lo0UDD19
sqglXa/uDXUwDQYJKoZIhvcNAQECBQAwXzELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDlZlcmlT
aWduLCBJbmMuMTcwNQYDVQQLEy5DbGFzcyAxIFB1YmxpYyBQcmltYXJ5IENlcnRpZmljYXRp
b24gQXV0aG9yaXR5MB4XDTk4MDUxMjAwMDAwMFoXDTA4MDUxMjIzNTk1OVowgcwxFzAVBgNV
BAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYw
RAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkgUmVm
LixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2aWR1
YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQwgZ8wDQYJKoZIhvcNAQEBBQAD
gY0AMIGJAoGBALtaRIoEFrtV/QN6ii2UTxV4NrgNSrJvnFS/vOh3Kp258Gi7ldkxQXB6gUu5
SBNWLccI4YRCq8CikqtEXKpC8IIOAukv+8I7u77JJwpdtrA2QjO1blSIT4dKvxna+RXoD4e2
HOPMxpqOf2okkuP84GW6p7F+78nbN2rISsgJBuSZAgMBAAGjfDB6MBEGCWCGSAGG+EIBAQQE
AwIBBjBHBgNVHSAEQDA+MDwGC2CGSAGG+EUBBwEBMC0wKwYIKwYBBQUHAgEWH3d3dy52ZXJp
c2lnbi5jb20vcmVwb3NpdG9yeS9SUEEwDwYDVR0TBAgwBgEB/wIBADALBgNVHQ8EBAMCAQYw
DQYJKoZIhvcNAQECBQADgYEAiLg3O93alDcAraqf4YEBcR6Sam0v9vGd08pkONwbmAwHhluF
FWoPuUmFpJXxF31ntH8tLN2aQp7DPrSOquULBt7yVir6M8e+GddTTMO9yOMXtaRJQmPswqYX
D11YGkk8kFxVo2UgAP0YIOVfgqaxqJLFWGrBjQM868PNBaKQrm4xggI8MIICOAIBATCB4TCB
zDEXMBUGA1UEChMOVmVyaVNpZ24sIEluYy4xHzAdBgNVBAsTFlZlcmlTaWduIFRydXN0IE5l
dHdvcmsxRjBEBgNVBAsTPXd3dy52ZXJpc2lnbi5jb20vcmVwb3NpdG9yeS9SUEEgSW5jb3Jw
LiBCeSBSZWYuLExJQUIuTFREKGMpOTgxSDBGBgNVBAMTP1ZlcmlTaWduIENsYXNzIDEgQ0Eg
SW5kaXZpZHVhbCBTdWJzY3JpYmVyLVBlcnNvbmEgTm90IFZhbGlkYXRlZAIQVp90vyAbrrLL
z/xhFQDIkDAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZI
hvcNAQkFMQ8XDTk5MDYzMDE4NDUyOFowIwYJKoZIhvcNAQkEMRYEFFHSb5mUTSmNLBAErcJx
5SFbUeVvMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMAcG
BSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEoMA0GCSqGSIb3DQEBAQUABIGA
Nfz5mRkaADLySJg71UOcJuHkTxaHOPau46H2U6G/nHUhW2SuMy588UQ0NaSOEo1b7mXQ9v23
VfkdIxnmrcxu+ILzPcPxh3QJeWUQPl6nthl2QRgkHpx9tBF0SCWFyI0L/qaele7Vyx2YBUEu
r8NaGmBm82Z9v7I4hr54B6JO+G4=
--------------msA85E21818DD8367FB1957F87--

0
Jason
6/30/1999 6:45:26 PM
Jason Froebe wrote:
> 
> Davin Yap wrote:
> 
> > Is it possible to connect to Sybase ASE using Unix domain sockets
> > instead of TCP/IP?
> >
> > Paul Ryland
> > dpar2@cam.ac.uk
> 
> Hi Davin,
> 
> OpenClient/ODBC etc uses TCP style packets not UDP.  If you want to use
> UDP or other packets, you will have to use the OpenServer and handle the
> user connections directly.  As UDP packets are not guaranteed to arrive
> from the server/client, you will have to take this into account.  It can
> be done but I'm not saying it would be easy.
> 
> It might be a fun project to play with.  I don't forsee any practical
> purposes of using UDP instead of TCP.   IMHO

Actually this person was not asking about UDP vs TCP, but rather about
Unix Domain vs Internet Domain sockets. Unix Domain sockets don't get on the
network at all, and so are potentially faster.

However I don't see how Sybase can be made to listen on a Unix Domain socket.

Michael
--
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
0
Michael
7/1/1999 12:26:50 AM
Reply:

Similar Artilces:

Linux to a Microsoft SQLserver
I have been trying to install DBD:Sybase for this function. I have installed the freetds and am tring to install the DBD:Sybase but when I try to do my make on the install I get this error messages. Any Ideas. Jason cc -c -I/usr/local/freetds/include -I/usr/lib/perl5/site_perl/5.6.0/i586- linux/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 -O2 -pipe -DVERSION=\"0.93\" -DXS_VERSION=\"0.93\" - fpic -I/usr/lib/perl5/5.6.0/i586-linux/CORE dbdimp.c dbdimp.c: In function `syb_ct_prepare_send': dbdimp...

Where to get the sqlserver for linux?
On Fri, 6 Nov 1998 09:53:02 +0800, "liangxs" <liangxs@263.net> wrote: > > http://www.redhat.com/redhat/sybase-reg.phtml -- Tony Cook [TeamPS] moderator powersoft.public.watcom_c_c++.general (Please repond in news: I ignore uninvited email responses) I have just purchased a copy of Caldera OpenLinux Version 1.3, which comes complete with ASE 11.0.3.3. You can download the complete package from their web-site which is :- http://www.calderasystems.com/products/openlinux/index.html Wayne liangxs wrote in message ... > > > ...

Linux to Linux VPN
Hey All, Hopefully this is something that can be done. I have a main office with a Win2000 server. I have a remote office with 3 computers, right now each of the remote computers connects to the windows2000 server over the internet using VPN with the W2K box being the VPN server. This causes a few problems because of the domain login and the user's are not the ummmm brightest with computers. What I want to do it place a perment VPN with auto re-connect so when they unplug the DSL modem to plug in the Fax (I know I know) and then plug the DSL back in it will re-sync the VPN...

Migrate linux to linux
We want to migrate our gw7 from netware to linux but because we lack a spliffy new server i need to move it to a temporary server first. Thankfully we have an OES2 'test' server currently running in our production tree with suse10 and oes2. After we migrate the Netware server to the test server and get everything running, is it enough to just install the agents on the real server, copy the entire database over from test maintaining path etc, change some ip's in the nds and hit start ? - Arjan On Wed, 20 Feb 2008 15:46:01 +0000, Arjan wrote: > After we m...

experimental: linux abstract domain sockets
--J2SCkAp4GZ/dPZZf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable perl5120delta has an entry for "Abstract namespace sockets." They're a Linux-ism with which I am only somewhat familiar. They were added in 99f13d4c and have been only barely touched since then. Are they used? Do we want to be committed to fixing bugs if they're found? When would we want to call this experiment concluded? My initial feeling is that abstract namespace sockets are pretty simple in implementation, and we'r...

Strange Warning in SQLServer errorlog on Linux
Hello! I have ASE 11.0.3.3 installed on my RedHat 5.1 Linux box. I've recently found following lines in server error log : 00:1998/10/16 14:10:21.20 server WARNING: memory usage in procedure headers (1) does not match memory usage count in Pss (20) for server process id 7. 00:1998/10/16 14:10:21.21 server WARNING: memory usage in procedure headers (1) does not match memory usage count in Pss (-18) for server process id 7. 00:1998/10/16 14:10:21.89 server WARNING: memory usage in procedure headers (1) does not match memory usage count in Pss (21) for server process id 7. 0...

Samba: win to linux fine, natilus (linux) to linux asks for password
Hi! Basically that is my particular issue, adding that I've set it up over openvpn as well, to the same server. [win -> linux] - see public (for existing users) shares and try to enter them - when asked for user and password, can see the contents of the public share along with my home folder - can see the shared local printer, and open and view current print jobs on the server (cannot print tough, will write another post about that) [linux to linux] - try to access the server via smbclient -L and can see shares ok - from nautilus, with the address smb://10.22.22.1 ...

odd perl & linux socket query problem.....
------=_NextPart_000_0032_01C38C11.40D465A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hiya, not really sure if this should be in beginners or not, but I am a = beginner :). I'm trying to write a script (or currently using some other stuff to = test) to send a network query out, querying game servers.... #!/usr/bin/perl -w use Socket; my $serverip =3D "194.109.69.91"; my $serverport =3D 27960; my $getstatus =3D "\xFF\xFF\xFF\xFFgetstatus"; //THIS IS THE LINE I'M = HAVING PROBLEMS WITH...

Socket to Socket example needed
Does anyone have any configuration examples of how to set up a socket to socket connection. I would appeciate any examples or help anyone can offer. Thanks. Rob McGinness Rutland Regional Medical Center 802-747-6526 rmcginness@rrmc.org I guess that you talk about one AIM module that drives two socket conections. If you try to build such module, you must create two protocol objects within the project. Each protocol object can control its own related objects (frame, port, open, close, etc.) > Does anyone have any configuration examples of how to set > up a socket to socke...

LINUX and Adaptive Server for LINUX
What does everybody think about the stability of Sybase on LINUX, and where can i get mor information about it? -- Ramses Palomo CSSoftware, Inc. Guatemala rpalomo@starnet.net.gt This is a multi-part message in MIME format. --------------1131468DB38D86409C30C2E2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Ramses Palomo wrote: > > What does everybody think about the stability of Sybase on LINUX, and > where can i get mor information about it? > > -- > Ramses Palomo > CSSoftware, Inc. Guatemala > rpalomo@starne...

ext/Socket/Socket.xs
In Socket.xs do I take it that this if (strEQ(name, "MSG_CTRUNC")) #if defined(MSG_TRUNC) || defined(HAS_MSG_CTRUNC) /* might be an enum */ return MSG_CTRUNC; #else goto not_there; #endif should be MSG_CTRUNC? As in: #if defined(MSG_CTRUNC) || defined(HAS_MSG_CTRUNC) /* might be an enum */ Secondly, Socket.pm EXPORTs MSG_URG, but there is no code to generate it in Socket.xs. Was this an oversight somewhere? Nicholas Clark On Sun, Jun 03, 2001 at 03:03:46PM +0100, Nicholas Clark wrote: > In Socket.xs do I take it that this > > if (strEQ(...

Linux Services on Linux OES2
Hi all, i´m testing a 2 node cluster (maybe more in the future) on OES2 (SLES10SP1, iSCSI on HP MSA1510i). Finally i want to cluster some NSS-Volumes, Groupwise and a CVS Server. Will this be possible?? Are there Linux-Services, which are not possible to implement with Novell Cluster Services? Thanks in advance. Alex Alexander Lorenz, NSS volumes and GroupWise are possible to cluster. I'm not sure about the CVS server though. Basically any serice that can access data from an NSS volume or from eDirectory should be possible to cluster. NCS requires NSS volumes, in...

OES(Linux) to OES2 (Linux)
Have a gaggle of servers running OES Linux. What are the reasons, compelling or otherwise, for upgrading/migrating, to OES2? Most of what I see are focused on convincing NetWare user to migrate to OES2. Being EOL or near EOL, would not be sufficient reason. -- joea ------------------------------------------------------------------------ On Fri, 14 Aug 2009 14:36:04 +0000, joea wrote: > Being EOL or near EOL, would not be sufficient reason. If it's a production system it is. I would get all OES1 servers updated to OES2 ASAP. -- Joe Marton Novel...

Dual boot
Recently, all of the sata controllers on my system board went south. Rather than buy a new board, I decided to dump Windows completely (since it is a pain to get working from an external drive) and just go with Ubuntu as an external. The Ubuntu install went fine. Everything so far is working. I decided to take the drive that used to have XP on it and set up a couple of other distro's to take a look at. I installed Kbuntu, and everything worked fine. I then installed Mepis. After the install I got a grub error:2 which I believe is that it cannot find the OS. I know this is d...

How to share a printer Linux to Linux
Hi, I've seen lots of posts on sharing printers in a mixed network, but I have 3 machines all with SUSE 10.3 - and I am having great difficulty in figuring out how to share the printer attached to the machine I use as a server. I have even tried Samba, but no success. Has anyone succeeded with setting up a shared printer using YAST? thanks for any reply -- prtowlson ------------------------------------------------------------------------ I just solved your problem yesterday. I'm printing using cups and IPP. So I didn't print via samba. You should ...

Web resources about - Sockets - sybase.sqlserver.linux

AC power plugs and sockets - Wikipedia, the free encyclopedia
AC power plugs and sockets are devices that allow electrically operated equipment to be connected to the primary alternating current (AC) power ...

Ratcheting-Socket-Wrench-22156-480x360 - Flickr - Photo Sharing!
Free Photos – 3/8-Inch Ratcheting Socket Wrench / Chrome Socket Wrench /Repair and Fix Tool kits More photos and details about possible copyright ...

Mitch Robinson lied to Carlton about incident that left him with a broken eye socket
Mitch Robinson lied to Carlton officials when asked why he had suffered a broken eye socket during a scuffle in the early hours of Sunday morning. ...

Brisbane Broncos forward Alex Glenn facing six weeks on sideline with fractured eye socket
Wayne Bennett ranks Brisbane fullbacks as Justin Hodges injury leaves Broncos with fifth choice rookie

ASRock Rack Announces EP2C612D24 and 4L: Dual Socket Haswell-EP with 24 DDR4 Slots
... 16GB UDIMMs, this allows for a maximum of 384GB, although moving up to RDIMM, LRDIMMs or 64GB NVDIMMs pushes the max to 1.5TB in a dual socket ...

Meet Beam, the Android projector that turns any light bulb socket into an entertainment center
In case you were looking for an out-of-the-box smart projector, then Beam might be worth looking into. The unusual-looking device has just been ...

A charred eye socket provides proof that 43 missing Mexico students are dead
People gather outside of the home of Alexander Mora, one of 43 college students missing since September whose charred remains have now been positively ...

Cool Chart of the Week: Solar Socket Parity In California, Australia, Germany, Italy, & Netherlands
I forget now how I ran across this chart, but it’s a nice one. It shows that residential solar PV power hit socket parity (aka grid parity) in ...

Dell Aims Four-Socket Server at Modern Database Hardware Needs
Launches x86 PowerEdge servers in bid to carve out more high-end server market share Read More

Video: Socket To Me! Nitwit At ‘Hand To God’ Tries To Charge Phone On Set
... on a performance of Hand To God at Broadway ’s Booth Theatre a few days ago, this patron leapt onstage and tried to plug his phone into a socket ...

Resources last updated: 11/25/2015 7:45:04 PM