Sql em - developer version?

[Guest]

Do any 'classic' asp developers have any knowledge about the client side sql
server EM tool found here:

http://www.amazon.com/exec/obidos/tg/detail/-/B000050AVL/103-3705998-1519030?v=glance&s=software&n=507846&vi=tech-data

I am hoping this will allow me to leverage default sql server database on
remote web host...but not sure if it will
run on WinXp Professional... .I was told it does...

Also: any other fast track hints to get started would be great...I have some
knowledge on Access sp's and I understand that dates are handled differently
in sql server...

Would it be a good idea to initialize the database path, username and
password in the global asa...?

Thanks
Jason

[Aaron [SQL Server MVP]]

Re: Sql em - developer version?

Per the licensing agreement, you cannot manage production databases with the
developer edition. It is for local development/testing only.

Several alternatives though:

http://www.aspfaq.com/2442

--

http://www.aspfaq.com/

(Reverse address to reply.)




<jason@catamara nco.com> wrote in message
news:OHPKsDCcEH A.2520@TK2MSFTN GP12.phx.gbl...[color=blue]
> Do any 'classic' asp developers have any knowledge about the client side[/color]
sql[color=blue]
> server EM tool found here:
>
>[/color]
http://www.amazon.com/exec/obidos/tg...6&vi=tech-data[color=blue]
>
> I am hoping this will allow me to leverage default sql server database on
> remote web host...but not sure if it will
> run on WinXp Professional... .I was told it does...
>
> Also: any other fast track hints to get started would be great...I have[/color]
some[color=blue]
> knowledge on Access sp's and I understand that dates are handled[/color]
differently[color=blue]
> in sql server...
>
> Would it be a good idea to initialize the database path, username and
> password in the global asa...?
>
> Thanks
> Jason
>
>[/color]

[Curt_C [MVP]]

Re: Sql em - developer version?

Aaron,
You adding anything in regards to SQL Express on the site?

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com


"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:uVyljKCcEH A.1644@tk2msftn gp13.phx.gbl...[color=blue]
> Per the licensing agreement, you cannot manage production databases with[/color]
the[color=blue]
> developer edition. It is for local development/testing only.
>
> Several alternatives though:
> http://www.aspfaq.com/2442
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> <jason@catamara nco.com> wrote in message
> news:OHPKsDCcEH A.2520@TK2MSFTN GP12.phx.gbl...[color=green]
> > Do any 'classic' asp developers have any knowledge about the client side[/color]
> sql[color=green]
> > server EM tool found here:
> >
> >[/color]
>[/color]
http://www.amazon.com/exec/obidos/tg...6&vi=tech-data[color=blue][color=green]
> >
> > I am hoping this will allow me to leverage default sql server database[/color][/color]
on[color=blue][color=green]
> > remote web host...but not sure if it will
> > run on WinXp Professional... .I was told it does...
> >
> > Also: any other fast track hints to get started would be great...I have[/color]
> some[color=green]
> > knowledge on Access sp's and I understand that dates are handled[/color]
> differently[color=green]
> > in sql server...
> >
> > Would it be a good idea to initialize the database path, username and
> > password in the global asa...?
> >
> > Thanks
> > Jason
> >
> >[/color]
>
>[/color]

[Aaron [SQL Server MVP]]

Re: Sql em - developer version?

Little bit here:

http://www.aspfaq.com/2343

--

http://www.aspfaq.com/

(Reverse address to reply.)




"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:OKLAnQCcEH A.3944@tk2msftn gp13.phx.gbl...[color=blue]
> Aaron,
> You adding anything in regards to SQL Express on the site?
>
> --
> Curt Christianson
> Owner/Lead Developer, DF-Software
> Site: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> news:uVyljKCcEH A.1644@tk2msftn gp13.phx.gbl...[color=green]
> > Per the licensing agreement, you cannot manage production databases with[/color]
> the[color=green]
> > developer edition. It is for local development/testing only.
> >
> > Several alternatives though:
> > http://www.aspfaq.com/2442
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > <jason@catamara nco.com> wrote in message
> > news:OHPKsDCcEH A.2520@TK2MSFTN GP12.phx.gbl...[color=darkred]
> > > Do any 'classic' asp developers have any knowledge about the client[/color][/color][/color]
side[color=blue][color=green]
> > sql[color=darkred]
> > > server EM tool found here:
> > >
> > >[/color]
> >[/color]
>[/color]
http://www.amazon.com/exec/obidos/tg...6&vi=tech-data[color=blue][color=green][color=darkred]
> > >
> > > I am hoping this will allow me to leverage default sql server database[/color][/color]
> on[color=green][color=darkred]
> > > remote web host...but not sure if it will
> > > run on WinXp Professional... .I was told it does...
> > >
> > > Also: any other fast track hints to get started would be great...I[/color][/color][/color]
have[color=blue][color=green]
> > some[color=darkred]
> > > knowledge on Access sp's and I understand that dates are handled[/color]
> > differently[color=darkred]
> > > in sql server...
> > >
> > > Would it be a good idea to initialize the database path, username and
> > > password in the global asa...?
> > >
> > > Thanks
> > > Jason
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Guest]

Re: Sql em - developer version?

Ok, but what I just want to connect to an existing production database on my
remote web host....can I do this....support staff at my web host say it is
possible?

I will only have one local testing db and wish to connect to an existing
remote db and manipulate it...

Sorry if this is a dumb question.


"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:uVyljKCcEH A.1644@tk2msftn gp13.phx.gbl...[color=blue]
> Per the licensing agreement, you cannot manage production databases with[/color]
the[color=blue]
> developer edition. It is for local development/testing only.
>
> Several alternatives though:
> http://www.aspfaq.com/2442
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> <jason@catamara nco.com> wrote in message
> news:OHPKsDCcEH A.2520@TK2MSFTN GP12.phx.gbl...[color=green]
> > Do any 'classic' asp developers have any knowledge about the client side[/color]
> sql[color=green]
> > server EM tool found here:
> >
> >[/color]
>[/color]
http://www.amazon.com/exec/obidos/tg...6&vi=tech-data[color=blue][color=green]
> >
> > I am hoping this will allow me to leverage default sql server database[/color][/color]
on[color=blue][color=green]
> > remote web host...but not sure if it will
> > run on WinXp Professional... .I was told it does...
> >
> > Also: any other fast track hints to get started would be great...I have[/color]
> some[color=green]
> > knowledge on Access sp's and I understand that dates are handled[/color]
> differently[color=green]
> > in sql server...
> >
> > Would it be a good idea to initialize the database path, username and
> > password in the global asa...?
> >
> > Thanks
> > Jason
> >
> >[/color]
>
>[/color]

[Aaron [SQL Server MVP]]

Re: Sql em - developer version?

> Ok, but what I just want to connect to an existing production database on
my[color=blue]
> remote web host....can I do this....support staff at my web host say it is
> possible?[/color]

Yes, it is possible, but not legal.

A

[Guest]

Re: Sql em - developer version?

Thanks Aaron....I'll investigate the MSDE option....the Acess ADP solution
does not interest me as it will not allow me to create Stored procs...

- Jason

"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:Os9nlkMcEH A.1408@TK2MSFTN GP12.phx.gbl...[color=blue][color=green]
> > Ok, but what I just want to connect to an existing production database[/color][/color]
on[color=blue]
> my[color=green]
> > remote web host....can I do this....support staff at my web host say it[/color][/color]
is[color=blue][color=green]
> > possible?[/color]
>
> Yes, it is possible, but not legal.
>
> A
>
>[/color]