It's the same for me if I use OLEDB or ODBC... to be hones I don't really
know the difrence :-) I tryed the ODBC too but didn't manage to connect.
Could you post an example connection string for me? I tryed to do it with the
"wizard" but didn't manage to create the new connection. Also tryed to
manually decide the connection string under advanced "Driver={SYBASE ASE ODBC
Driver};Srvr=Aron1;Uid=username;Pwd=password", but that didnt work either.
Could you post and example of a connection string here?

The DSN I created had TCP as the protocol, how can I test if that is
correct? I know I have the correct port and IP on the connection.

Thanks alot

Hi Bruce ,

I saw your answers in good number of Google Searches .. Can you please give
us a light on this below issue

Hi Folks,



i am missing some thing in the script which is not giving me a Dataset



Below is the script

Create Table  AIG_TTSSIVA (

omsref                             varchar(16) null ,
moddate                            datetime null

)

SET NOCOUNT ON

begin

Insert into   AIG_TTSSIVA  SELECT   '0',''

Insert into   AIG_TTSSIVA  SELECT   SUBSTRING(a.uniquemsgref, 1, 16) AS
omsref ,max(a.moddate) as moddate   FROM tmsg_status a
where  cONVERT(CHAR(10), a.moddate , 101) =  '08/05/2008'
Group by SUBSTRING(a.uniquemsgref, 1, 16)

end

Select  omsref , moddate from   AIG_TTSSIVA

Drop Table  AIG_TTSSIVA





In the reporting services , gives the results , but we are NOT getting the
dataset on left hand side



But it works when the table was created Mannually by me in the database ,
Insted of Creating and Droping the Table Just deleting the content it works
fine. We are trying to avoid the reporting tabes in the Database , so that
Upgrades are smoother ..



Connection Details



Sybase OLE DB - ODBC - Sybase Database



Any Help - light on this is Highly appriciated



regds

siva ram