|
|
You're in the
sql server reporting services
group:Problem with Reporting Service SQL 2000 and Sybase
sql server reporting services:
I work extensively with Sybase. The issue you are seeing is that query
variables for ODBC have to be a ? (unnamed parameter). I suggest you stick with the ODBC driver. I have had issues with OLEDB. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Landry" <landry@dsai.com.br.NEWS> wrote in message news:em6ndG7RFHA.688@TK2MSFTNGP10.phx.gbl... > Hi, > > The connection to Sybase with OLEDB and ODBC have the same problem when > the > query have parameter. The query below don´t execute: > > select prod_cod,cod_empresa from estatistica.dbo.zomba > where vida = @vida > > OLEDB error: "An error occurred while executing the query. The given type > name was unrecognized" > versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support) > > ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol > driver][SQL > Server] must declare variable @vida" > versions used: 04.10.0049 (provided by Sybase support) > > Someone have the same problem? > > Thanks, > Landry > > > >
Hi,
The connection to Sybase with OLEDB and ODBC have the same problem when the query have parameter. The query below don´t execute: select prod_cod,cod_empresa from estatistica.dbo.zomba where vida = @vida OLEDB error: "An error occurred while executing the query. The given type name was unrecognized" versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support) ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol driver][SQL Server] must declare variable @vida" versions used: 04.10.0049 (provided by Sybase support) Someone have the same problem? Thanks, Landry
The best thing to do is as you are doing, first get a query and then move on
to stored procedures. That is the data type of vida? Also, when are you getting this error? From the data tab clicking on the ! ? Or from the preview? Let's concentrate on ODBC. What error do you get with ODBC (it can't be the same as before because at that point you had this error: must declare variable @vida). I do all my queries from the generic query window. Try that (the button is to the right of the ... to switch to generic query designer). Also, what version of Sysbase. I am using 12.5.2 client and have used that against both an 11.x (I don't remember the exact version) and 12.5.1 servers. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Landry" <landry@dsai.com.br.NEWS> wrote in message news:e4V1j7BSFHA.1348@TK2MSFTNGP15.phx.gbl... > Hi, > > Thanks. > > I test ? with OLEDB and ODBC and have the same error! > > select prod_cod,cod_empresa from estatistica.dbo.zomba > where vida = ? > > I test Stored Procedures with parameters and have the same error. > > Landry > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> escreveu na mensagem > news:u%23sw%23m7RFHA.3704@TK2MSFTNGP12.phx.gbl... >>I work extensively with Sybase. The issue you are seeing is that query >>variables for ODBC have to be a ? (unnamed parameter). I suggest you stick >>with the ODBC driver. I have had issues with OLEDB. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Landry" <landry@dsai.com.br.NEWS> wrote in message >> news:em6ndG7RFHA.688@TK2MSFTNGP10.phx.gbl... >>> Hi, >>> >>> The connection to Sybase with OLEDB and ODBC have the same problem when >>> the >>> query have parameter. The query below don´t execute: >>> >>> select prod_cod,cod_empresa from estatistica.dbo.zomba >>> where vida = @vida >>> >>> OLEDB error: "An error occurred while executing the query. The given >>> type >>> name was unrecognized" >>> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support) >>> >>> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol >>> driver][SQL >>> Server] must declare variable @vida" >>> versions used: 04.10.0049 (provided by Sybase support) >>> >>> Someone have the same problem? >>> >>> Thanks, >>> Landry >>> >>> >>> >>> >> >> > >
Hi,
Thanks. I test ? with OLEDB and ODBC and have the same error! select prod_cod,cod_empresa from estatistica.dbo.zomba where vida = ? I test Stored Procedures with parameters and have the same error. Landry "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> escreveu na mensagem news:u%23sw%23m7RFHA.3704@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] >I work extensively with Sybase. The issue you are seeing is that query >variables for ODBC have to be a ? (unnamed parameter). I suggest you stick >with the ODBC driver. I have had issues with OLEDB. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Landry" <landry@dsai.com.br.NEWS> wrote in message > news:em6ndG7RFHA.688@TK2MSFTNGP10.phx.gbl... >> Hi, >> >> The connection to Sybase with OLEDB and ODBC have the same problem when >> the >> query have parameter. The query below don´t execute: >> >> select prod_cod,cod_empresa from estatistica.dbo.zomba >> where vida = @vida >> >> OLEDB error: "An error occurred while executing the query. The given >> type >> name was unrecognized" >> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support) >> >> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol >> driver][SQL >> Server] must declare variable @vida" >> versions used: 04.10.0049 (provided by Sybase support) >> >> Someone have the same problem? >> >> Thanks, >> Landry >> >> >> >> > >
Hi Bruce,
Thanks, the problem is ODBC version, now work fine with cliente version 12.5.3, the most recent. The Sybase suport will analyze the OLEDB to correct the error. Thanks, Landry "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> escreveu na mensagem news:urhgPMCSFHA.3336@TK2MSFTNGP09.phx.gbl... [quoted text, click to view] > The best thing to do is as you are doing, first get a query and then move > on to stored procedures. That is the data type of vida? > > Also, when are you getting this error? From the data tab clicking on the ! > ? Or from the preview? > > Let's concentrate on ODBC. What error do you get with ODBC (it can't be > the same as before because at that point you had this error: must declare > variable @vida). > > I do all my queries from the generic query window. Try that (the button is > to the right of the ... to switch to generic query designer). > > Also, what version of Sysbase. I am using 12.5.2 client and have used that > against both an 11.x (I don't remember the exact version) and 12.5.1 > servers. > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Landry" <landry@dsai.com.br.NEWS> wrote in message > news:e4V1j7BSFHA.1348@TK2MSFTNGP15.phx.gbl... >> Hi, >> >> Thanks. >> >> I test ? with OLEDB and ODBC and have the same error! >> >> select prod_cod,cod_empresa from estatistica.dbo.zomba >> where vida = ? >> >> I test Stored Procedures with parameters and have the same error. >> >> Landry >> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> escreveu na mensagem >> news:u%23sw%23m7RFHA.3704@TK2MSFTNGP12.phx.gbl... >>>I work extensively with Sybase. The issue you are seeing is that query >>>variables for ODBC have to be a ? (unnamed parameter). I suggest you >>>stick with the ODBC driver. I have had issues with OLEDB. >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> "Landry" <landry@dsai.com.br.NEWS> wrote in message >>> news:em6ndG7RFHA.688@TK2MSFTNGP10.phx.gbl... >>>> Hi, >>>> >>>> The connection to Sybase with OLEDB and ODBC have the same problem when >>>> the >>>> query have parameter. The query below don´t execute: >>>> >>>> select prod_cod,cod_empresa from estatistica.dbo.zomba >>>> where vida = @vida >>>> >>>> OLEDB error: "An error occurred while executing the query. The given >>>> type >>>> name was unrecognized" >>>> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support) >>>> >>>> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol >>>> driver][SQL >>>> Server] must declare variable @vida" >>>> versions used: 04.10.0049 (provided by Sybase support) >>>> >>>> Someone have the same problem? >>>> >>>> Thanks, >>>> Landry >>>> >>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |