Can We assign DataSet object to Object Type

Hi Friends,

I am having a Package scope variable DS of type system.object .In the Script Component which accept this variable as ReadWrite type I am Making the following assignment.

Public Overrides Sub PostExecute()

Variables.DsReport = DsReport // DsReport is a Data Set Object Created and Populated inside the script Component

End Sub

I am getting error while doing this sort of assignment.

Please help me to solve this problem

Regards,

Mahe

Which error do you get?

-Tom

Can view accept parameters

Hi All ,
i wonder if a view can accept parameters becoz i only
want to show certain columns based on user's input.
if it's not possible, could i know is there other
alternative as to accept both the user's input as well as
restrict the column to be displayed as readonly
thks & rdgsWhat version are you running? Please always state that information.
If you are using SQL Server 2000, you can create a table valued function
that can be used EXACTLY like a view which accepts parameters. Please read
about CREATE FUNCTION in the Books Online.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
> Hi All ,
> i wonder if a view can accept parameters becoz i only
> want to show certain columns based on user's input.
> if it's not possible, could i know is there other
> alternative as to accept both the user's input as well as
> restrict the column to be displayed as readonly
> thks & rdgs|||Hi Kalen ,
my appologies ..
btw i am using SQL 7.0 , is this possible then ?
thks
>--Original Message--
>What version are you running? Please always state that
information.
>If you are using SQL Server 2000, you can create a table
valued function
>that can be used EXACTLY like a view which accepts
parameters. Please read
>about CREATE FUNCTION in the Books Online.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
as[vbcol=seagreen]
>
>.
>|||No. In the relational model, a view is just like a table and a table doesn't
accept parameters.
In-line table values functions is what some call "a view that accepts parame
ters" but that feature was added
in 2000. Can you use a stored procedure instead?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:042d01c47ab0$eb6bcd80$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Kalen ,
> my appologies ..
> btw i am using SQL 7.0 , is this possible then ?
> thks
> information.
> valued function
> parameters. Please read
> message
> assql

Can view accept parameters

Hi All ,
i wonder if a view can accept parameters becoz i only
want to show certain columns based on user's input.
if it's not possible, could i know is there other
alternative as to accept both the user's input as well as
restrict the column to be displayed as readonly
thks & rdgs
What version are you running? Please always state that information.
If you are using SQL Server 2000, you can create a table valued function
that can be used EXACTLY like a view which accepts parameters. Please read
about CREATE FUNCTION in the Books Online.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
> Hi All ,
> i wonder if a view can accept parameters becoz i only
> want to show certain columns based on user's input.
> if it's not possible, could i know is there other
> alternative as to accept both the user's input as well as
> restrict the column to be displayed as readonly
> thks & rdgs
|||Hi Kalen ,
my appologies ..
btw i am using SQL 7.0 , is this possible then ?
thks
>--Original Message--
>What version are you running? Please always state that
information.
>If you are using SQL Server 2000, you can create a table
valued function
>that can be used EXACTLY like a view which accepts
parameters. Please read
>about CREATE FUNCTION in the Books Online.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
as
>
>.
>
|||No. In the relational model, a view is just like a table and a table doesn't accept parameters.
In-line table values functions is what some call "a view that accepts parameters" but that feature was added
in 2000. Can you use a stored procedure instead?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:042d01c47ab0$eb6bcd80$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Kalen ,
> my appologies ..
> btw i am using SQL 7.0 , is this possible then ?
> thks
> information.
> valued function
> parameters. Please read
> message
> as

Can view accept parameters

Hi All ,
i wonder if a view can accept parameters becoz i only
want to show certain columns based on user's input.
if it's not possible, could i know is there other
alternative as to accept both the user's input as well as
restrict the column to be displayed as readonly
thks & rdgsWhat version are you running? Please always state that information.
If you are using SQL Server 2000, you can create a table valued function
that can be used EXACTLY like a view which accepts parameters. Please read
about CREATE FUNCTION in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
> Hi All ,
> i wonder if a view can accept parameters becoz i only
> want to show certain columns based on user's input.
> if it's not possible, could i know is there other
> alternative as to accept both the user's input as well as
> restrict the column to be displayed as readonly
> thks & rdgs|||Hi Kalen ,
my appologies ..
btw i am using SQL 7.0 , is this possible then ?
thks
>--Original Message--
>What version are you running? Please always state that
information.
>If you are using SQL Server 2000, you can create a table
valued function
>that can be used EXACTLY like a view which accepts
parameters. Please read
>about CREATE FUNCTION in the Books Online.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
>> Hi All ,
>> i wonder if a view can accept parameters becoz i only
>> want to show certain columns based on user's input.
>> if it's not possible, could i know is there other
>> alternative as to accept both the user's input as well
as
>> restrict the column to be displayed as readonly
>> thks & rdgs
>
>.
>|||No. In the relational model, a view is just like a table and a table doesn't accept parameters.
In-line table values functions is what some call "a view that accepts parameters" but that feature was added
in 2000. Can you use a stored procedure instead?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:042d01c47ab0$eb6bcd80$a301280a@.phx.gbl...
> Hi Kalen ,
> my appologies ..
> btw i am using SQL 7.0 , is this possible then ?
> thks
> >--Original Message--
> >What version are you running? Please always state that
> information.
> >
> >If you are using SQL Server 2000, you can create a table
> valued function
> >that can be used EXACTLY like a view which accepts
> parameters. Please read
> >about CREATE FUNCTION in the Books Online.
> >
> >--
> >HTH
> >--
> >Kalen Delaney
> >SQL Server MVP
> >www.SolidQualityLearning.com
> >
> >
> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:056c01c47aae$ea2814d0$a501280a@.phx.gbl...
> >> Hi All ,
> >>
> >> i wonder if a view can accept parameters becoz i only
> >> want to show certain columns based on user's input.
> >>
> >> if it's not possible, could i know is there other
> >> alternative as to accept both the user's input as well
> as
> >> restrict the column to be displayed as readonly
> >>
> >> thks & rdgs
> >
> >
> >.
> >

Can sql variable accept array?

Hi,
Can sql variable accept array?
regards,
florencehttp://www.algonet.se/~sommar/arrays-in-sql.html
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:110d01c3a21c$07657720$a301280a@.phx.gbl...
> Hi,
> Can sql variable accept array?
> regards,
> florence|||Florence,
SQL Server do not support array of values. You may have to pass comma seperated values to the code.
Refer to following url for more information.
Passing arrays to stored procedure
http://www.algonet.se/~sommar/arrays-in-sql.html
- Vishal|||http://www.algonet.se/~sommar/arrays-in-sql.html
--
Jacco Schalkwijk
SQL Server MVP
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:110d01c3a21c$07657720$a301280a@.phx.gbl...
> Hi,
> Can sql variable accept array?
> regards,
> florence|||http://www.aspfaq.com/2248
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:110d01c3a21c$07657720$a301280a@.phx.gbl...
> Hi,
> Can sql variable accept array?
> regards,
> florence

Can SQL 2005 be changed to accept case-INSENSITIVE passwords???

We have a SQL 2000 server that has been migrated to a SQL 2005 server.
Now when the users log on to the SQL app a lot of them can't logon.
I believe this is due to the SQL passwords being case-insensitve in SQL 2000
and being case-sensitive in 2005. Is there a way to make SQL 2005 passwords
case-insensitive?
Thanks!How did you determine that it is case sensitivity that is causing these
login issues? Are the user names and passwords stored in a table in
the database? Or are the logins defined in SQL Server to use
windows/mixed authentication?
If the user names and passwords are stored in a table in the DB, try
running : "sp_helpsort" in the old and new databases. The result will
tell you if SQL Server 2005 has been set up to use a case sensitive
collation. If it is - you might want to look up how to change
collation so that it is the same as whatever was being used in SQL
Server 2000 - if you want the same behavior in SQL Server 2005.
If defined in SQL Server, run "EXEC sp_change_users_login 'Report'" to
see if any of those logins are out of sync. If they are out of sync,
use this same sp (look it up in BOL) to sync them.
winsysadmin wrote:
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL 2000
> and being case-sensitive in 2005. Is there a way to make SQL 2005 passwords
> case-insensitive?
> Thanks!|||> Is there a way to make SQL 2005 passwords case-insensitive?
Sorry, but SQL 2005 requires that SQL login passwords be case-sensitive for
security reasons. In SQL 2000, password case sensitivity was determined by
the instance collation. This behavior change is documented in the SQL 2005
Books Online:
<Excerpt
href="ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm">
A password entered by a user must match the password stored in the server.
If a password does not match the password stored in SQL Server, the login
fails. If the precise case of the password characters is forgotten, the
password must be reset.
</Excerpt>
--
Hope this helps.
Dan Guzman
SQL Server MVP
"winsysadmin" <winsysadmin@.discussions.microsoft.com> wrote in message
news:369B36BD-BEDC-4EE9-BFFE-F41502EC2D84@.microsoft.com...
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL
> 2000
> and being case-sensitive in 2005. Is there a way to make SQL 2005
> passwords
> case-insensitive?
> Thanks!|||Thanks for confirming this for me.
"Dan Guzman" wrote:
> > Is there a way to make SQL 2005 passwords case-insensitive?
> Sorry, but SQL 2005 requires that SQL login passwords be case-sensitive for
> security reasons. In SQL 2000, password case sensitivity was determined by
> the instance collation. This behavior change is documented in the SQL 2005
> Books Online:
> <Excerpt
> href="http://links.10026.com/?link=ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm">
> A password entered by a user must match the password stored in the server.
> If a password does not match the password stored in SQL Server, the login
> fails. If the precise case of the password characters is forgotten, the
> password must be reset.
> </Excerpt>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "winsysadmin" <winsysadmin@.discussions.microsoft.com> wrote in message
> news:369B36BD-BEDC-4EE9-BFFE-F41502EC2D84@.microsoft.com...
> > We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> > Now when the users log on to the SQL app a lot of them can't logon.
> > I believe this is due to the SQL passwords being case-insensitve in SQL
> > 2000
> > and being case-sensitive in 2005. Is there a way to make SQL 2005
> > passwords
> > case-insensitive?
> > Thanks!
>
>|||Thanks, I'll try those commands you mention.
"sqlQuest@.gmail.com" wrote:
> How did you determine that it is case sensitivity that is causing these
> login issues? Are the user names and passwords stored in a table in
> the database? Or are the logins defined in SQL Server to use
> windows/mixed authentication?
> If the user names and passwords are stored in a table in the DB, try
> running : "sp_helpsort" in the old and new databases. The result will
> tell you if SQL Server 2005 has been set up to use a case sensitive
> collation. If it is - you might want to look up how to change
> collation so that it is the same as whatever was being used in SQL
> Server 2000 - if you want the same behavior in SQL Server 2005.
> If defined in SQL Server, run "EXEC sp_change_users_login 'Report'" to
> see if any of those logins are out of sync. If they are out of sync,
> use this same sp (look it up in BOL) to sync them.
>
> winsysadmin wrote:
> > We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> > Now when the users log on to the SQL app a lot of them can't logon.
> > I believe this is due to the SQL passwords being case-insensitve in SQL 2000
> > and being case-sensitive in 2005. Is there a way to make SQL 2005 passwords
> > case-insensitive?
> > Thanks!
>

Can SQL 2005 be changed to accept case-INSENSITIVE passwords???

We have a SQL 2000 server that has been migrated to a SQL 2005 server.
Now when the users log on to the SQL app a lot of them can't logon.
I believe this is due to the SQL passwords being case-insensitve in SQL 2000
and being case-sensitive in 2005. Is there a way to make SQL 2005 passwords
case-insensitive?
Thanks!How did you determine that it is case sensitivity that is causing these
login issues? Are the user names and passwords stored in a table in
the database? Or are the logins defined in SQL Server to use
windows/mixed authentication?
If the user names and passwords are stored in a table in the DB, try
running : "sp_helpsort" in the old and new databases. The result will
tell you if SQL Server 2005 has been set up to use a case sensitive
collation. If it is - you might want to look up how to change
collation so that it is the same as whatever was being used in SQL
Server 2000 - if you want the same behavior in SQL Server 2005.
If defined in SQL Server, run "EXEC sp_change_users_login 'Report'" to
see if any of those logins are out of sync. If they are out of sync,
use this same sp (look it up in BOL) to sync them.
winsysadmin wrote:
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL 20
00
> and being case-sensitive in 2005. Is there a way to make SQL 2005 password
s
> case-insensitive?
> Thanks!|||> Is there a way to make SQL 2005 passwords case-insensitive?
Sorry, but SQL 2005 requires that SQL login passwords be case-sensitive for
security reasons. In SQL 2000, password case sensitivity was determined by
the instance collation. This behavior change is documented in the SQL 2005
Books Online:
<Excerpt
href="ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264
-b547-cbee8013c995.htm">
A password entered by a user must match the password stored in the server.
If a password does not match the password stored in SQL Server, the login
fails. If the precise case of the password characters is forgotten, the
password must be reset.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"winsysadmin" <winsysadmin@.discussions.microsoft.com> wrote in message
news:369B36BD-BEDC-4EE9-BFFE-F41502EC2D84@.microsoft.com...
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL
> 2000
> and being case-sensitive in 2005. Is there a way to make SQL 2005
> passwords
> case-insensitive?
> Thanks!