Hi,

I am using ADO to run the following stored procedure:

create procedure TESTADO1( @input varchar(255), @result varchar(255)
output )
as
begin
select @result = @input
end

Here is the code I use:

_variant_t vTmp = _T("Hello");
_ParameterPtr pParameter1 = spCmd->CreateParameter( _T("VALUE_IN1"),

adVarChar,

adParamInput,

255 ,

vTmp );
spCmd->Parameters->Append( pParameter1 );

_variant_t vVALUE_OUT2;
_ParameterPtr pParameter5 = spCmd->CreateParameter( _T("VALUE_OUT2"),

adVarChar,

Hi,

i'm a little bit in trouble. before i have syabase 12.x and
successfully linked our sybase database to sqlserver 2k and
2k5. when our company upgraded sybase to 15.x. i followed
the document
http://www.sybase.com/content/1029118/1029118.doc in linking
sybase 12.5 to sqlserver. but when i install the sybase
15.x openclient i can find the SYBASE OLEDB CONFIGURATION.
where i can find it?? or sybase change the SYBASE OLEDB
CONFIGURATION????

please help...

tengtium

Hi,

Are there any steps I would need to foolow to do this?

I have an access database which has a few sybase system 11 linked tables. Im
trying to run a make table query from ADO , well even just any query to see
if it works but i get an error stating that it can t find the table name
etc.

I will get entire error for you but are there any steps that i should
follow...

Many Thanks

Introduction. I just want to let you know that I was able
to execute Sql Statements yesterday but now I am getting the
following error.

"Login Failed, Check for vaild user ID, server name and
password
[Native Error code: 4002]
[DataDirect ADO Sybase Provider] Login failed."

Same application is running smoothly in other PCs using the
same configuration. My connection string is as follow:

"Provider=Sybase.ASEOLEDBProvider.2;Server Name= address>;Server Port Address= Catalog=;User
ID=;Password=;"

My configuration is:
-- XP profesional
-- VS2005
-- Sybase 12.5 (backend)
-- Sybase client OLE DB 12.5.0/P/02.50
Copyright 2001 Sybase, Inc.

Hello Paul,

I apologize for taking so long. I am posting a new message
because I am able to execute stored procedure using OLE DB.
There I will explain in more details.

PORNOLATION RELEASE

Hello,

I am using Sybase OLE DB Provider for VB6. My problem is that i set
the
connection string : Data
Source=MYDB;Password=pwd;Provider=sybase.ASEOLEDBProvider;User
Id=user;
And when i try this : cnx.Open i got this error :
"[SYBASE][OLE DB Sybase provider]Number contains an invalid character:
True"

thank u.

Is it possible to connect a 64-bit SQL Server 2005 to ASE15
via Linked Server with a 32-bit Sybase OLEDB provider
(v12.0)?

I understand that OLE 12.0(By DataDirect) has been EOL'ed
(End of Life), but we've proved that new v15 OLEDB (Sybase
built) is simply useless (maybe in our environment only)
even after asking a lot of questions in different forums and
struggling very hard with Tech. Support.

If it's possible that I can still use the Datadirect version
with my 64-bit SQL Server, I will stay with the old version
and neglect the End of Life Notification
(http://www.sybase.com/detail?id=1040652) for one more
while.

Appreciate if any light could be shed on this.

Thanks with regards,
Jonathan

Is there a download/trial version that contains a 64-bit OLE
DB driver? I need to connect a 64-bit SQL Server 2005
database to a sybase database (version 12.5 I think).

Thanks.

When a process against Sybase database lasts more time than
expected, I need to get some time-out errors. I tried using
connectiontimeout and commandtimeout properties, but the
process continues executing and does not end.

The OLE DB version used is 2.70.0038. The server version is
ASE 12.5.3/EBF 12934. A colleague told me this:

It is a bug of OLEDB CR# 398330 which is corrected in the
version OLEDB >= 2.70.0051. So, you should upgrade your
version OLEDB with open client windows Conn 12.5.1 ESD #11
or the last one EBF 14971: 12.5.1 ESD #20

Could you please tell me whether a new version of OLEDB
would certainly correct the but?

Many thanks.