ODBC drivers for Sybase
Hui Chun Kit, Jacky
Just a very silly questions, where can I find ODBC drivers for
Sybase on Windows95/98 or NT 4.0?
And does any people tried out Sybase ASE 11.03 for Linux? What is the
comment? Thanks!
Best Rgds,
Jacky Hui
dhag...@my-dejanews.com
jack...@geocities.com wrote:
> Dear all,
>
> Just a very silly questions, where can I find ODBC drivers for
> Sybase on Windows95/98 or NT 4.0?
> And does any people tried out Sybase ASE 11.03 for Linux? What is the
> comment? Thanks!
On your Sybase SQL Server CDs. Since version 11.something, Sybase has
shipped a repackaged version of Intersolv's drivers.
Other 3rd-party sources usually have "trialware" drivers:
www.intersolv.com
www.openlinksw.com
www.simbatech.com
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
VJ
You can download drivers free from our website at www.openlinksw.com or
www.openlinksw.co.uk. You can download either single-tier (60 day
evaluation) or multi-tier (Free non-expiring 2 user license).
--
Best regards
Vijay Pattni
Consultant
OpenLink Software http://www.openlinksw.com
Universal Database Connectivity Technology Providers
dhag...@my-dejanews.com wrote in article
<6uohoc$osq$1...@nnrp1.dejanews.com>...
Hui Chun Kit, Jacky
Can you provide more info?
I cannot find much info from their web sites. I have been there many times
but I don't know which version should I download , the single-tier or
multi-tier one?
By the way, I want to use the ODBC drivers on WIN32 platform. So i do not
need a Linux ODBC driver.
Thanks very much for your response.
Best Rgds,
Jacky Hui
Tim Haynes wrote:
> Hi,
>
> OpenLink (http://www.openlinksw.com/) supports Sybase from Linux clients; a
> portation of Sybase as a server on Linux is expected soon.
>
> Regards,
>
> ~Tim
>
Tim Haynes
If you only need the Windows client, you can use either the Lite (Single-Tier)
or Multi-Tier versions.
If you want future compatibility and scalability and you don't want to use a
Sybase comms layer, try multi-tier.
HTH,
~Tim
In article <361258BD...@school.net.hk>,
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
f...@acunet.net
kenn...@nospam.interserv.com
"Hui Chun Kit, Jacky" <ck...@school.net.hk> writes:
>Dear all,
>
> Just a very silly questions, where can I find ODBC drivers for
>Sybase on Windows95/98 or NT 4.0?
>And does any people tried out Sybase ASE 11.03 for Linux? What is the
>comment? Thanks!
>
>
>
>Jacky Hui
>
Complete list of ODBC drivers and vendors:
http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm
Complete list of JDBC drivers and vendors:
http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm
sco...@my-dejanews.com
on to the win95 platform. Select licensed products and install Open Client
and ODBC drivers.
In article <6v4ubm$itv$1...@nnrp1.dejanews.com>,
Tim Haynes
There is no need to install Open Client any more. OpenLink have a multi-tier
driver for Sybase on Linux that does not require it. It's available for free
non-expiry evaluation download by filling in the forms on our downloads
pages, <http://www.openlinksw.com/> onwards.
Best regards,
~Tim
In article <6vvmg4$l90$1...@nnrp1.dejanews.com>,
kei...@jaxn.com
I've downloaded the OpenLink multi-tier driver for Client:WIN95/Server:LINUX.
This installation seemed to go okay on both platforms but I get the following
error when I try to connect to the Sybase 11 Server from the WIN95 machine:
szSqlState = "08004", *pfNativeError = 0, *pcbErrorMsg = 58
szErrorMsg = "[OpenLink][ODBC][Driver]Connection rejected by data source"
Can anybody shed any light on this?
Thanks
In article <707gdb$bn4$1...@nnrp1.dejanews.com>,
Tim Haynes
Could you please post us the request broker debug trace (run the broker in
debug mode with oplrqb -d), showing the connection attempt and the
server-side error message why it fails?
Best regards,
Tim Haynes
Support Consultant
OpenLink Software Web: <http://www.openlinksw.co.uk/>
Universal Database Connectivity Technology Providers
In article <718ba2$sfs$1...@nnrp1.dejanews.com>,
kei...@jaxn.com
Below you'll find the request broker debug output. I noticed in the output
that the broker was compiled for kernel 2.0.33. I'm using 2.0.32, but will
be upgrading as soon as possible. I've read some other posts that say you
need to be running 2.0.36pre to work around a tcp/ip bug in the kernel.
Maybe that's my problem!!
Anyway, thanks again and here is the debug output:
==========================================================================
OpenLink Request Broker
Version 2.7A (Release 3.0) as of Wed Apr 15 1998 (cvsid 00043).
Compiled for Linux 2.0.33 (i586-pc-linux-gnulibc1)
Copyright (C) OpenLink Software.
Registered to OpenLink Demo Version
This is a 2 concurrent users license
restricted to 10 concurrent connections
oplrqb: using rulebook /usr/local/opt/openlink/bin/oplrqb.ini oplrqb: bound
UDP protocol to 127.0.0.1.60001 oplrqb: bound TCP protocol to 127.0.0.1.5000
oplrqb: using UDP address 192.168.0.2.0 for IPC oplrqb: request broker
started by sybase oplrqb: spawning
/usr/local/opt/openlink/bin/w3config/www_sv www_sv +debug oplrqb: started
persistent www_sv (pid=535) oplrqb: kee001 called (192.168.0.1.1032) oplrqb:
request: domain=Sybase 11 database=pubs2 serveropts= oplrqb: connectopts=
user=sybase opsys=win32 readonly=0 oplrqb: application=ODBCTE32
processid=4294852041 oplrqb: solve mapping:
syb11:pubs2:sybase:msdos:kee001:ODBCTE32:rw oplrqb: using mapping:
syb11:*:*:*:*:*:* oplrqb: using [generic_syb11] ServerProgram=sybc11_sv
oplrqb: connect params: domain=Sybase 11 db=pubs2 serveropts= readonly=0
oplrqb: connectopts= user=sybase opsys=win32 machine=kee001
application=ODBCTE32 oplrqb: spawning /usr/local/opt/openlink/bin/sybc11_sv
generic_syb11 +debug oplrqb: asking agent for server handle oplrqb: setting
Environment SYBASE11 oplrqb: change environment 'SYBASE' ->
'/usr/local/opt/sybase' oplrqb: change environment 'DSQUERY' -> 'SYBASE'
generic_syb11: server starting oplrqb: got it! oplrqb: asking agent for
connection handle generic_syb11: *14: Login failed. generic_syb11: * 4:
ct_connect(): protocol specific layer: external error: The attempt to connect
to the server failed. (44) oplrqb: agent generic_syb11 rejected connection
(reason 53: unknown error) oplrqb: rejected syb...@kee001.ODBCTE32 (unknown
error) generic_syb11: got SIGTERM generic_syb11: server shutting down oplrqb:
pid 536 died with exit code 0 oplrqb: agent died (pid=536) oplrqb: unable to
find an agent with pid 536 oplrqb: got signal 2 oplrqb: request broker
shutting down
==========================================================================
In article <719cnv$b9v$1...@nnrp1.dejanews.com>,
Tim Haynes
I note from you debug the lines:
> Environment SYBASE11 oplrqb: change environment 'SYBASE' ->
> '/usr/local/opt/sybase' oplrqb: change environment 'DSQUERY' -> 'SYBASE'
...
> *14: Login failed. generic_syb11:
> * 4: ct_connect(): protocol specific layer: external error: The attempt to >
connect to the server failed.
Are you sure the above are the correct values for the DSQUERY and SYBASE
variables? If you source the environment variable script that the
installation of Sybase left lying around, can you then connect to Sybase with
isql, in the username of sybase? ('sa' would be a good starting point for
testing usernames.) If you can connect with isql, check your DSQUERY and
SYBASE variables with the `env` command; these values should then go in
oplrqb.ini.
Please let us know how you get on with the above.
Best regards,
Tim Haynes
Support Consultant
OpenLink Software Web: <http://www.openlinksw.co.uk/>
Universal Database Connectivity Technology Providers
In article <71b483$puv$1...@nnrp1.dejanews.com>,
kei...@jaxn.com
server using the O/S username of 'sybase' instead of the database username of
'sa'. I'm connecting now and everything is working great.
Thanks to Tim Haynes of OpenLink for the excellent support. Without it, I'd
still be banging my head against the wall.
Thanks Again!!!
In article <71c0c7$sh5$1...@nnrp1.dejanews.com>,