Data not showing for some users

Hi there,

Some users, when they select a table and try to "Return all rows" in Enterprise Manager, they get the word Binary instead of the data that should be there. The table has 4 columns, an ID column and three data columns. The ID field data is correct but the data in the other columns just show the word 'Binary'.

I got the user to connect to the database using the 'sa' login and the problem is still there. I can connect from my machine and see the data fine. Only one user is experiencing these problems.

The problem occurs with all the tables in the database. Any field that should have text data, e.g. nchar, nvarchar, etc., is showing 'Binary'. Fields that have numeric or date types show fine.

If the users runs a select query from Query Analyser, then the data appears fine.

Any help??This problem seems to have occured since i tried to install a SQLBase odbc driver. The data in the database is fine but Enterprise Manager seems to be corrupted.

Any help??

data horizontally

Hi
I would like to show the data in the report horizontally instead of
vertically. I am using reporting services 2000 and sql server 2000.
Thanks
passxPradeepRed...@.gmail.com wrote:
> Hi
> I would like to show the data in the report horizontally instead of
> vertically(which is the normal format). I am using reporting services 2000 and sql server 2000. Any immediate solutions will reallybe appreciated.
>
> Thanks
> passx|||PradeepRed...@.gmail.com wrote:
> Hi
> I would like to show the data in the report horizontally instead of
> vertically(which is the normal format). I am using reporting services 2000 and sql server 2000. Any immediate solutions will reallybe appreciated.
>
> Thanks
> passx|||PradeepRed...@.gmail.com wrote:
> Hi
> I would like to show the data in the report horizontally instead of
> vertically(which is the normal format). I am using reporting services 2000 and sql server 2000. Any immediate solutions will reallybe appreciated.
>
> Thanks
> passx|||PradeepReddy1@.gmail.com wrote:
> Hi
> I would like to show the data in the report horizontally instead of
> vertically. I am using reporting services 2000 and sql server 2000.
>
> Thanks
> passx
I think you can solve your problem when you can use the matrix and
place the row you want to place in a Column group
Regards
RajDeep.A|||No Raj
My requirement is something different. For example :
If we retrieve some values from a table in sql. Now these values are
represented as follows in the reporting serivices.
1st row 1st column of sql data in 1st row 1st column of report.
2nd row 1st column of sql data in 1st row 2nd column of report
3rd row 1st column of sql data in 1st row 3rd column of report.
|||ly for 1st row 2nd column of sql data in 2nd row 1st column in
report.
Hope this makes my requirement much more clear.
I think this can be done in sql but have no idea how to do that.
Any help will be appreciated.
RajDeep wrote:
> PradeepReddy1@.gmail.com wrote:
> > Hi
> >
> > I would like to show the data in the report horizontally instead of
> > vertically. I am using reporting services 2000 and sql server 2000.
> >
> >
> > Thanks
> > passx
> I think you can solve your problem when you can use the matrix and
> place the row you want to place in a Column group
> Regards
> RajDeep.A

Data Getting truncated as I insert i.e. instead of inserting Hello it inserts H

m inserting some data in big-sized fieldand small-sized fields, data of varchar type, int's, dateTime, andothers... i am using something called a stored procedure to add datainto a table.. now when i execute the stored procedure my data getstruncated (although i made the sizes for my fields ridiculously biglike 1000 just in case) for example if i want to enter Jasmine it onlyinserts 'J' in the field
I am sure there's something wrong in the stored procedure, and I amguessing it's a problem of using single vs. double quotes and stufflike that within my insert statement...
the following is my stored procedure:
CREATE procedure addLabor
@.lName varchar,
@.fName varchar,
@.mName varchar,
@.title varchar,
@.craft varchar,
@.lastFour varchar,
@.SSN varchar,
@.dateOfHire varchar,
@.currentProj varchar,
@.status tinyInt,
@.project_id int,
@.updateBy varchar,
@.updateDate varchar,
@.address varchar,
@.email varchar,
@.phone varchar,
@.zip varchar,
@.myfeedBack varchar,
@.ethnicity varchar,
@.userID int
as
BEGIN
SET NOCOUNT OFF
DECLARE @.newid INT
insert into laborPersonal ( lName, fName, mName, title, craft,lastFour, SSN, dateOfHire, currentProj, status, project_id,updateBy,
updateDate, address, email, phone, zip, ethnicity)
VALUES
(@.lName , @.fName , @.mName , @.title , @.craft , @.lastFour , @.SSN ,@.dateOfHire , @.currentProj ,
@.status, @.project_id , @.UpdateBy, @.UpdateDate , @.address , @.email , @.phone , @.zip , @.ethnicity )
SELECT @.newid = SCOPE_IDENTITY()
insert into feedBack
(lID, feedBack, userID, project_id)
values
(@.newid ,+'
+@.myfeedBack + ',
+@.userID ,
@.project_id )
SET NOCOUNT ON
END
GO

When i use 2 single quotes it insert the following string: "@.lName" not the actual value of the variable @.lName
my exec statement is this:
EXEC addLabor 'Razor', 'Nazor', 'mid', 'Mr', 'Carpenter Forman','1234','keOWVozC+wmBvaqgkVkZci5y4vFLdTKfZOVG4C6BSN6H2MBP6pdsIWA0SdPAlPJra0EjEj+uXI/kXSiBuwwnKQ==','6/27/2005 12:00:00 AM' , 'O.C. Public Library', 1, 3, '3', '7/25/20052:38:02 PM', '1233 Shady Canyon, Irvine', '', '', '12345','123-12-1234', 'African American', '3'
I appreciate any help or hints
thanks to all
All of your parameters are declared like this:
@.lName varchar,
Should be like this:

@.lName varchar(1000),
a type of varchar is like varchar(1), meaning a variable length string with a max of 1 character. The number used should likely match the underlying length of the field in the table