Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do you install Sybase version 9 OleDBClient?

6 posts in General Discussion Last posting was on 2006-05-16 20:30:11.0Z
Jim Rand Posted on 2006-05-14 17:29:09.0Z
Reply-To: "Jim Rand" <jimrand@ix.netcom.com>
From: "Jim Rand" <jimrand@ix.netcom.com>
Newsgroups: ianywhere.public.general
Subject: How do you install Sybase version 9 OleDBClient?
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: rrcs-24-97-42-186.nys.biz.rr.com
Message-ID: <446768ba@forums-2-dub>
X-Original-Trace: 14 May 2006 10:28:26 -0700, rrcs-24-97-42-186.nys.biz.rr.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 May 2006 10:28:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 May 2006 10:29:09 -0700
X-Trace: forums-1-dub 1147627749 10.22.108.75 (14 May 2006 10:29:09 -0700)
X-Original-Trace: 14 May 2006 10:29:09 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5333
Article PK: 1386

I have failed at getting ASA OleDB to work correctly on the client.

The code works on the development machine but does not work on a client
workstation:

Dim oADOConn As ADODB.Connection
Dim oADOCmd As ADODB.Command
Dim oADOParam As ADODB.Parameter
Dim oADORecSet As ADODB.RecordSet
Dim sConnect As String

sConnect =
"Provider=ASAProv;ServerName=PortlandDBServer;DatabaseName=MyDatabase" & _
"CommLinks=tcpic(host=192.168.16.2);User
ID=dba;Password=password"
Set oADOConn = New ADODB.Connection
oADOConn.ConnectionString = sConnect
oADOConn.Open ' It does
Set oADOCmd = New ADODB.Command
With oADOCmd
.CommandText = "dba.TestADO"
.CommandType = adCmdStoredProc
Set .ActiveConnection = oADOConn

Set oADOParam = New ADO
oADOParam.Type = adInteger
oADOParam.Value = 1
.Parameters.Append oADOParam

Set oADORecSet = .Execute ' This works on the development machine but
fails on the test client with the following error message "Wrong number of
parameters to function 'TestADO'

To install ASAProv on the client, I copied dbcon9.dll, dbgen9.dll,
dbodbc9.dll, dboledb9.dll dboledba9.dll to the client and ran regsrv32 on
both dboledb9.dll and dboledba9.dll

By the way, ODBC to the back end database works fine.

How do you get ASA OLEDB to work on a the client?


Rob Waywell Posted on 2006-05-15 20:09:31.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <446768ba@forums-2-dub>
Subject: Re: How do you install Sybase version 9 OleDBClient?
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4468dfc9$1@forums-2-dub>
X-Original-Trace: 15 May 2006 13:08:41 -0700, rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 May 2006 13:08:42 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 May 2006 13:09:31 -0700
X-Trace: forums-1-dub 1147723771 10.22.108.75 (15 May 2006 13:09:31 -0700)
X-Original-Trace: 15 May 2006 13:09:31 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5337
Article PK: 1389

The error doesn't seem to indicate a problem in the OLEDB layer. It is
saying that you haven't specified the right # of parameters for the stored
procedure dba.TestADO.

If you use that connection string to connect from dbisql on the client
machine and call the stored procedure, does it work?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Jim Rand" <jimrand@ix.netcom.com> wrote in message
news:446768ba@forums-2-dub...
>I have failed at getting ASA OleDB to work correctly on the client.
>
> The code works on the development machine but does not work on a client
> workstation:
>
> Dim oADOConn As ADODB.Connection
> Dim oADOCmd As ADODB.Command
> Dim oADOParam As ADODB.Parameter
> Dim oADORecSet As ADODB.RecordSet
> Dim sConnect As String
>
> sConnect =
> "Provider=ASAProv;ServerName=PortlandDBServer;DatabaseName=MyDatabase" & _
> "CommLinks=tcpic(host=192.168.16.2);User
> ID=dba;Password=password"
> Set oADOConn = New ADODB.Connection
> oADOConn.ConnectionString = sConnect
> oADOConn.Open ' It does
> Set oADOCmd = New ADODB.Command
> With oADOCmd
> .CommandText = "dba.TestADO"
> .CommandType = adCmdStoredProc
> Set .ActiveConnection = oADOConn
>
> Set oADOParam = New ADO
> oADOParam.Type = adInteger
> oADOParam.Value = 1
> .Parameters.Append oADOParam
>
> Set oADORecSet = .Execute ' This works on the development machine but
> fails on the test client with the following error message "Wrong number of
> parameters to function 'TestADO'
>
> To install ASAProv on the client, I copied dbcon9.dll, dbgen9.dll,
> dbodbc9.dll, dboledb9.dll dboledba9.dll to the client and ran regsrv32 on
> both dboledb9.dll and dboledba9.dll
>
> By the way, ODBC to the back end database works fine.
>
> How do you get ASA OLEDB to work on a the client?
>
>
>


Jim Rand Posted on 2006-05-16 13:18:39.0Z
Reply-To: "Jim Rand" <jimrand@ix.netcom.com>
From: "Jim Rand" <jimrand@ix.netcom.com>
Newsgroups: ianywhere.public.general
References: <446768ba@forums-2-dub> <4468dfc9$1@forums-2-dub>
Subject: Re: How do you install Sybase version 9 OleDBClient?
Lines: 111
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: user-10bj03d.cable.mindspring.com
Message-ID: <4469d0fa@forums-2-dub>
X-Original-Trace: 16 May 2006 06:17:46 -0700, user-10bj03d.cable.mindspring.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 May 2006 06:17:46 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 May 2006 06:18:39 -0700
X-Trace: forums-1-dub 1147785519 10.22.108.75 (16 May 2006 06:18:39 -0700)
X-Original-Trace: 16 May 2006 06:18:39 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5340
Article PK: 1391

Hi Rob,

What I've determined through testing is this:

Development computer (D)
Database server computer (S)
Client computer (C)

D -> S returning a result set from a command without paramaters works
D -> S returning a result set from a command with 1 parameter works
D -> S returning a result set from a command with 2 parameters works

Same code:

C -> S returning a result set from a command without paramaters works
C -> S returning a result set from a command with 1 parameter fails
C -> S returning a result set from a command with 2 parameters fails

Installing from the Sybase CD the entire SQLAnywhere distribution on (C) as
alternative attempt to install the client OLE Dlls does not resolve the
problem.

At this point, I've decided to abandon ADO and use RDO instead. The rest of
the application performs flawlessly with a combination of DAO query
passthrus for data retrieval and RDO for writebacks to Sybase.

Jim

"Rob Waywell" <rwaywell_no_spam_please@ianywhere.com> wrote in message
news:4468dfc9$1@forums-2-dub...
> The error doesn't seem to indicate a problem in the OLEDB layer. It is
> saying that you haven't specified the right # of parameters for the stored
> procedure dba.TestADO.
>
> If you use that connection string to connect from dbisql on the client
> machine and call the stored procedure, does it work?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Jim Rand" <jimrand@ix.netcom.com> wrote in message
> news:446768ba@forums-2-dub...
> >I have failed at getting ASA OleDB to work correctly on the client.
> >
> > The code works on the development machine but does not work on a client
> > workstation:
> >
> > Dim oADOConn As ADODB.Connection
> > Dim oADOCmd As ADODB.Command
> > Dim oADOParam As ADODB.Parameter
> > Dim oADORecSet As ADODB.RecordSet
> > Dim sConnect As String
> >
> > sConnect =
> > "Provider=ASAProv;ServerName=PortlandDBServer;DatabaseName=MyDatabase" &
_
> > "CommLinks=tcpic(host=192.168.16.2);User
> > ID=dba;Password=password"
> > Set oADOConn = New ADODB.Connection
> > oADOConn.ConnectionString = sConnect
> > oADOConn.Open ' It does
> > Set oADOCmd = New ADODB.Command
> > With oADOCmd
> > .CommandText = "dba.TestADO"
> > .CommandType = adCmdStoredProc
> > Set .ActiveConnection = oADOConn
> >
> > Set oADOParam = New ADO
> > oADOParam.Type = adInteger
> > oADOParam.Value = 1
> > .Parameters.Append oADOParam
> >
> > Set oADORecSet = .Execute ' This works on the development machine
but
> > fails on the test client with the following error message "Wrong number
of
> > parameters to function 'TestADO'
> >
> > To install ASAProv on the client, I copied dbcon9.dll, dbgen9.dll,
> > dbodbc9.dll, dboledb9.dll dboledba9.dll to the client and ran regsrv32
on
> > both dboledb9.dll and dboledba9.dll
> >
> > By the way, ODBC to the back end database works fine.
> >
> > How do you get ASA OLEDB to work on a the client?
> >
> >
> >
>
>


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-05-16 13:28:10.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How do you install Sybase version 9 OleDBClient?
References: <446768ba@forums-2-dub> <4468dfc9$1@forums-2-dub> <4469d0fa@forums-2-dub>
In-Reply-To: <4469d0fa@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <4469d36a$1@forums-1-dub>
Date: 16 May 2006 06:28:10 -0700
X-Trace: forums-1-dub 1147786090 10.25.98.170 (16 May 2006 06:28:10 -0700)
X-Original-Trace: 16 May 2006 06:28:10 -0700, keating-dm20.sybase.com
Lines: 33
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5341
Article PK: 1392

Are you sure that you are running the same version/build of the
provider? MDAC? Other relevant software i.e., development tool
deployment components, OS? The provider is definitely installed as you
are able to connect. The only concern is that your provider is vague as
to what ASAProv you want. If there are multiple major versions of
providers, your connection will use the DEFAULT ASAProv. Use ASAProv.90
to ensure that the provider used is for ASA9.



--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Rob Waywell Posted on 2006-05-16 15:55:59.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <446768ba@forums-2-dub> <4468dfc9$1@forums-2-dub> <4469d0fa@forums-2-dub>
Subject: Re: How do you install Sybase version 9 OleDBClient?
Lines: 146
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4469f60f$1@forums-1-dub>
Date: 16 May 2006 08:55:59 -0700
X-Trace: forums-1-dub 1147794959 10.25.98.235 (16 May 2006 08:55:59 -0700)
X-Original-Trace: 16 May 2006 08:55:59 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5342
Article PK: 1393

At this point I would say the most likely explanation is that you are
connecting to a different version of the database from C than you are from
D.

Did you do these tests through dbisql or through the application?
If you run dbunload -n ... from C and check the CREATE PROCEDURE statement
for dba.TestADO procedure, is it what you expected?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Jim Rand" <jimrand@ix.netcom.com> wrote in message
news:4469d0fa@forums-2-dub...
> Hi Rob,
>
> What I've determined through testing is this:
>
> Development computer (D)
> Database server computer (S)
> Client computer (C)
>
> D -> S returning a result set from a command without paramaters works
> D -> S returning a result set from a command with 1 parameter works
> D -> S returning a result set from a command with 2 parameters works
>
> Same code:
>
> C -> S returning a result set from a command without paramaters works
> C -> S returning a result set from a command with 1 parameter fails
> C -> S returning a result set from a command with 2 parameters fails
>
> Installing from the Sybase CD the entire SQLAnywhere distribution on (C)
> as
> alternative attempt to install the client OLE Dlls does not resolve the
> problem.
>
> At this point, I've decided to abandon ADO and use RDO instead. The rest
> of
> the application performs flawlessly with a combination of DAO query
> passthrus for data retrieval and RDO for writebacks to Sybase.
>
> Jim
>
>
> "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com> wrote in message
> news:4468dfc9$1@forums-2-dub...
>> The error doesn't seem to indicate a problem in the OLEDB layer. It is
>> saying that you haven't specified the right # of parameters for the
>> stored
>> procedure dba.TestADO.
>>
>> If you use that connection string to connect from dbisql on the client
>> machine and call the stored procedure, does it work?
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Sybase Adaptive Server Anywhere Developer - Version 8
>> Sybase Certified Professional
>>
>> Sybase's iAnywhere Solutions
>>
>> Please respond ONLY to newsgroup
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports:
>>
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> "Jim Rand" <jimrand@ix.netcom.com> wrote in message
>> news:446768ba@forums-2-dub...
>> >I have failed at getting ASA OleDB to work correctly on the client.
>> >
>> > The code works on the development machine but does not work on a client
>> > workstation:
>> >
>> > Dim oADOConn As ADODB.Connection
>> > Dim oADOCmd As ADODB.Command
>> > Dim oADOParam As ADODB.Parameter
>> > Dim oADORecSet As ADODB.RecordSet
>> > Dim sConnect As String
>> >
>> > sConnect =
>> > "Provider=ASAProv;ServerName=PortlandDBServer;DatabaseName=MyDatabase"
>> > &
> _
>> > "CommLinks=tcpic(host=192.168.16.2);User
>> > ID=dba;Password=password"
>> > Set oADOConn = New ADODB.Connection
>> > oADOConn.ConnectionString = sConnect
>> > oADOConn.Open ' It does
>> > Set oADOCmd = New ADODB.Command
>> > With oADOCmd
>> > .CommandText = "dba.TestADO"
>> > .CommandType = adCmdStoredProc
>> > Set .ActiveConnection = oADOConn
>> >
>> > Set oADOParam = New ADO
>> > oADOParam.Type = adInteger
>> > oADOParam.Value = 1
>> > .Parameters.Append oADOParam
>> >
>> > Set oADORecSet = .Execute ' This works on the development machine
> but
>> > fails on the test client with the following error message "Wrong number
> of
>> > parameters to function 'TestADO'
>> >
>> > To install ASAProv on the client, I copied dbcon9.dll, dbgen9.dll,
>> > dbodbc9.dll, dboledb9.dll dboledba9.dll to the client and ran regsrv32
> on
>> > both dboledb9.dll and dboledba9.dll
>> >
>> > By the way, ODBC to the back end database works fine.
>> >
>> > How do you get ASA OLEDB to work on a the client?
>> >
>> >
>> >
>>
>>
>
>


Jim Rand Posted on 2006-05-16 20:30:11.0Z
Reply-To: "Jim Rand" <jimrand@ix.netcom.com>
From: "Jim Rand" <jimrand@ix.netcom.com>
Newsgroups: ianywhere.public.general
References: <446768ba@forums-2-dub> <4468dfc9$1@forums-2-dub> <4469d0fa@forums-2-dub> <4469f60f$1@forums-1-dub>
Subject: Re: How do you install Sybase version 9 OleDBClient?
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: rrcs-24-97-42-186.nys.biz.rr.com
Message-ID: <446a361b$1@forums-2-dub>
X-Original-Trace: 16 May 2006 13:29:15 -0700, rrcs-24-97-42-186.nys.biz.rr.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 May 2006 13:29:16 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 May 2006 13:30:11 -0700
X-Trace: forums-1-dub 1147811411 10.22.108.75 (16 May 2006 13:30:11 -0700)
X-Original-Trace: 16 May 2006 13:30:11 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5343
Article PK: 1395

First the bad news. We gave up on ADO.

Now the good news. I took the functionality that this one call through ADO
provided, created a VB DLL that uses RDO, referenced Microsoft Access to the
DLL. It works and is incredibly fast!

I guess we will never know what caused the problem with ADO.

Jim