Showing posts with label enabled. Show all posts
Showing posts with label enabled. Show all posts

Sunday, March 25, 2012

Data Enabled WebSite

I am looking at developing a data enabled web site. I am quite proficient
with SQL server, VB & ASP. For these reasons I have decided to develop the
site in ASP.NET (learning presently) with an SQL Server backend.
I have been told this is not the way to go and the better alternative is PHP
& MySQL.
I would appreciate any feedback re the pros and cosn of each option and
whether there is truth to this or not.
ThanksIf your quite proficient in that why would you want to change? Being
familiar with a tool(s) goes a long way and can help to reduce costs quite a
bit by being more accurate, confident and faster.
--
Andrew J. Kelly
SQL Server MVP
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Exactly, my thoughts precisely however if the general opinion was that I was
going down the wrong path then i would be forced to learn new tricks in
order to complete the task correctly.
If there general opinion is that it's mrerly a matter of choice then I'll
stay with what I know.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> If your quite proficient in that why would you want to change? Being
> familiar with a tool(s) goes a long way and can help to reduce costs quite
a
> bit by being more accurate, confident and faster.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||Murphy,
Stick with your initial tools. You are building a solution that assumes IIS
and SQL Server, but these are very well accepted technology solutions.
bill burrows
"Murphy" <murphy@.murphy.com> wrote in message
news:uCcCN1NoDHA.2216@.TK2MSFTNGP12.phx.gbl...
> Exactly, my thoughts precisely however if the general opinion was that I
was
> going down the wrong path then i would be forced to learn new tricks in
> order to complete the task correctly.
> If there general opinion is that it's mrerly a matter of choice then I'll
> stay with what I know.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> > If your quite proficient in that why would you want to change? Being
> > familiar with a tool(s) goes a long way and can help to reduce costs
quite
> a
> > bit by being more accurate, confident and faster.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||Get a decent database structure and access.
You already know sql server so will be able to cunstruct
that easily and a decent stored procedure interface.
Without this there is not hope of building a reliable
efficient system. You can spend the time you would have
spent learning a new database on testing and refining this
one.
Adain you should find it easier to learn and be effective
in (make less serious mistakes) in asp.net than in php if
you already know asp well.
If you go for php and mysql you will just be another
beginner trying to hack together a web site.|||Ignore the advice!
I work day in day out with PHP/MySQL and although they are open source,
reliable and easy to work with, I am now opting to go down the .NET route.
SQL Server is a more powerful database and .NET is a more powerful platform
to code on.
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Not sure its a good idea to ignore the advice... I'm all .NET myself, but
MySQL and PHP certainly is a good "cost free" alternative. Now that's said;
go with .NET and SQL Server!
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> Ignore the advice!
> I work day in day out with PHP/MySQL and although they are open source,
> reliable and easy to work with, I am now opting to go down the .NET route.
> SQL Server is a more powerful database and .NET is a more powerful
platform
> to code on.
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||As I will be hosting the site with a hosting company who provide the SQL db
etc cost is not an issue to me.
"CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> Not sure its a good idea to ignore the advice... I'm all .NET myself, but
> MySQL and PHP certainly is a good "cost free" alternative. Now that's
said;
> go with .NET and SQL Server!
> --
> Carsten Thomsen
> Enterprise Development with VS .NET, UML, and MSF
> http://www.apress.com/book/bookDisplay.html?bID=105
> "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > Ignore the advice!
> >
> > I work day in day out with PHP/MySQL and although they are open source,
> > reliable and easy to work with, I am now opting to go down the .NET
route.
> >
> > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > to code on.
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||If it's for serious use, go .NET/ASP etc.
If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
then MySQl, and PHP are good. Although I still use ASP and SQL.
Angus
"Murphy" <murphy@.murphy.com> wrote in message
news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> As I will be hosting the site with a hosting company who provide the SQL
db
> etc cost is not an issue to me.
> "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > Not sure its a good idea to ignore the advice... I'm all .NET myself,
but
> > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > go with .NET and SQL Server!
> >
> > --
> > Carsten Thomsen
> > Enterprise Development with VS .NET, UML, and MSF
> > http://www.apress.com/book/bookDisplay.html?bID=105
> > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > Ignore the advice!
> > >
> > > I work day in day out with PHP/MySQL and although they are open
source,
> > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > >
> > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > to code on.
> > >
> > > "Murphy" <murphy@.murphy.com> wrote in message
> > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > with SQL server, VB & ASP. For these reasons I have decided to
develop
> > the
> > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > >
> > > > I have been told this is not the way to go and the better
alternative
> is
> > > PHP
> > > > & MySQL.
> > > >
> > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > whether there is truth to this or not.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi
ASP.NET and SQL Server is the way forward.
Good place to get ASP.NET and SQL Server hosting web space is:
http://www.dotnet-webhosting.com/sql-server-hosting/default.aspx
£22/Month (included web space, SQL Server DB and free domain)
Regards
G,
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||Hi
We offer a very good and reliable service.
http://www.nt-webspace.com
Only £6 / Month and as a special offer we are giving away free domain
till 31st Dec 2003.
Here are the plan details
==========================NO SETUP FEES!
30 day Money Back Guarantee
Windows 2003 ® / IIS ® 6.0 Servers!
24 hour - 7 day a week support!
Unlimited web page updates!
Personal cgi-bin directory
200 MB Disk Space! (Special Offer now 400 MB !! )
Pop3 E-mail boxes with unlimited aliases and auto-responders!
2 GB / Month Bandwidth Transfer!
Microsoft Active Server ?
FTP access for updating web site
Microsoft Access ®/ FoxPro ® Database Support!
Microsoft MS SQL Server 7.0 (£27/mo. additional
Regards
NT-Webspace.com
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||www.oneandone.co.uk are rather good.
Angus
"NT-Webspace.com" <gbaryah@.hotmail.com> wrote in message
news:792f1e6b.0312120107.7c2f9b03@.posting.google.com...
> Hi
> We offer a very good and reliable service.
> http://www.nt-webspace.com
> Only £6 / Month and as a special offer we are giving away free domain
> till 31st Dec 2003.
> Here are the plan details
> ==========================> NO SETUP FEES!
> 30 day Money Back Guarantee
> Windows 2003 ® / IIS ® 6.0 Servers!
> 24 hour - 7 day a week support!
> Unlimited web page updates!
> Personal cgi-bin directory
> 200 MB Disk Space! (Special Offer now 400 MB !! )
> Pop3 E-mail boxes with unlimited aliases and auto-responders!
> 2 GB / Month Bandwidth Transfer!
> Microsoft Active Server T
> FTP access for updating web site
> Microsoft Access ®/ FoxPro ® Database Support!
> Microsoft MS SQL Server 7.0 (£27/mo. additional
> Regards
> NT-Webspace.com
>
> "Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message
news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> > If it's for serious use, go .NET/ASP etc.
> >
> > If it's for a hobby site (say a VA, if you're afollower of my hobby,
FS!)
> > then MySQl, and PHP are good. Although I still use ASP and SQL.
> >
> > Angus
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > As I will be hosting the site with a hosting company who provide the
SQL
> > db
> > > etc cost is not an issue to me.
> > >
> > > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > > Not sure its a good idea to ignore the advice... I'm all .NET
myself,
> > but
> > > > MySQL and PHP certainly is a good "cost free" alternative. Now
that's
> > said;
> > > > go with .NET and SQL Server!
> > > >
> > > > --
> > > > Carsten Thomsen
> > > > Enterprise Development with VS .NET, UML, and MSF
> > > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > > Ignore the advice!
> > > > >
> > > > > I work day in day out with PHP/MySQL and although they are open
> > source,
> > > > > reliable and easy to work with, I am now opting to go down the
.NET
> > route.
> > > > >
> > > > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > > > to code on.
> > > > >
> > > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > > > with SQL server, VB & ASP. For these reasons I have decided to
> > develop
> > the
> > > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > > >
> > > > > > I have been told this is not the way to go and the better
> > alternative
> > is
> > PHP
> > > > > > & MySQL.
> > > > > >
> > > > > > I would appreciate any feedback re the pros and cosn of each
option
> > and
> > > > > > whether there is truth to this or not.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

Thursday, March 22, 2012

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Sunday, February 19, 2012

Daily scheduled job has its schedule disabled despite successful completion

I have a job which is scheduled to run once daily. The job is enabled and the schedule is also enabled. After the job runs (successfully), the schedule has its 'Enabled' flag reset (i.e. the 'Enabled' checkbox in the schedule properties has become unchecked) and so is not rescheduled.

I have other jobs configured in a similar way, but they are run and then rescheduled in the normal way without any problems.

What could be going on?I'm sure you'd know but there is definately no disables step in the job?
e.g
EXEC sp_update_job @.job_name = 'bla bla',
@.enabled = 0|||This may be of some use to you. Have you checked the logs?

http://support.microsoft.com/default.aspx?scid=kb;en-us;295378&Product=sql2k