Hi.

I'm setting up a ODBC connection on a mac. I'm using Sybase
SQL Anywhere's driver. When running the iodbctest app I get
the following error:

1: SQLDriverConnect = [iODBC][Driver Manager]Driver's
SQLAllocEnv() failed (0) SQLSTATE=IM004
1: ODBC_Connect = [iODBC][Driver Manager]Driver's
SQLAllocEnv() failed (0) SQLSTATE=IM004

I've searched around but can't seem to find the solution to
the problem. Any hints as to what might be wrong?

LESS Than A Dollar A Day Gets
HUGE Exposure. Let Us Handle
All The Work - VISITORS GUARANTEED
OR YOUR MONEY BACK!!!

http://submitmywebpage.com/offers/

cAn]T.P$6<=bejNZaxUnjVg<

Am only experiencing this on one machine.
W2003 standard server acting as the terminal server.

Have created a profile in the ODBC administrator to connect to a ASA11
db which resides on a different subnet.

TS server (192.168.20.5)
DB(192.168.101.7)

Have other odbc connections on other machines in the same situation
and all connect fine.

This is a major problem since my application usesa transaction object
to carry out some functions.

The problem seems to be when I test the connection it always says that
my password is incorrect. But after resetting the password two or
three times then I get a successful connection test. Then once closing
and reopening the test fails again..

The application always makes a successfully connection but when using
the transaction object it will popup the odbc profile..

So the problem seems to be some corruption with the odbc profile..
Have tried to delete the profile and create a new one but to no
effect..

Hi All,

I have developed an SSIS package that uses odbc to connect to sybase
and execute a stored procedure. Works fine on my local machine which
has syodase.dll driver version 3.70.0.20. The production server
however has the odbc syodase.dll version 4.20.0.67 and the package
does not work. I've boiled the problem down to the driver difference
right down to modifying the ssis package on the production server
using Microsoft Visual Studio, so there's no doubt about the root
cause of the problem. Now what to do about it....does anyone know how
to roll back the odbc version. I've tried picking up the odbc
directory on my local machine and copying it over to the server, but
this doesn't seem to do the trick.

Any suggestions would be much appreciated!!

Regards,
Terry

dbodbc9.dll 9.0.2.3668

Hello,

on a win ce 5.0 mobile terminal we have problems with an 'self ending
application'. The application just is gone - no error message, nothing.

For information: the terminal connects with dbodbc9.dll either with WLAN
or GPRS to the external db-server. The terminal connects and sends some
small inserts and then disconnects.

What we found out is, that whenever the applications exits, there's an
active sybase connection, and that the exit seems to happen more often,
when the connection quality is poorer (almoste never with WLAN, more
often with GPRS and even more often when using GPRS on the countryside).

We now like to find the real cause for that. My questions are:
- we added
LOG=logfile.txt
to our dsn-file. But actually we don't find any usefull information in
this file. Is there a connection parameter to get more/all informations?
- or is there maybe a debug-version of this dll, which could help

I am struggling to get hold of sybase odbc libraries (specifical C
headers/libraries) for solaris. Having spoken to someone at Sybase I'm
assured they exist. From digging around the Sybase web site it looks
like some third party drivers (DataDirect) have been replaced by
Sybase own. Other pages seem to only refer to Windows and Linux. The
SDK for solaris certainly doesn't include anything.

So, does Sybase provide ODBC support for solaris? If so, what product
is it part of?

(this is for connecting to ASE 12.5.3)

Sean.

hi ..
Now current Sybase 15 and PB 6.5, I install Client with NAMEPIPE
protocol it is ping sever it connected , I can also work Sybase
central .

While running program with Pb with Sqlca.DBMS
I try using "SYC Sybase System 10" & also "SYC Adaptive Server
Enterprise"
same error is coming.

Transaction Error Code : -1
Database Error Code : 999
DBMS : SYC Adaptive Server Enterprise
Database : vrkdb
User ID : sa
DBParm :
Login ID : sa
ServerName : SYBASE15
AutoCommit : False
Database Error Message : Unable to initialize Client Library Context

Hi,

I am trying to connect to a Sybase 12 data source using a Sybase 15
driver. It failes, but not always, with a 30046 error code.

I tried turning on the ODBC trace, but no file was created.

Does anyone know of any known issues with the trace? What's this
error all about?

Thanks!

Hello,
We are using Sybase 11.9.2 with Pb 6.5, but Now Our Company bought
Sybase15,
I have a problem to Link “Profile String” in ini file between PB 6.5
and Sybase15.

How can I carry out this?
Thanks..!

I'm stuck and need an answer for the big boss sharpish!

I have an Access app that points at Sybase via DSN but before it can
be released the DBAs want sp_who to have a value for the hostname so
they can know who is running the Access app. Here's my best stab so
far but doesn't work -

CurrentDb.QueryDefs("MY_PT_QUERY").Connect =
"ODBC;DSN=MyApp;ServerName=" & Server & ";UID=" & username & ";PWD=" &
pwd & ";CS_HOSTNAME=MYPC;DATABASE=MYDB"

Please help!!!