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...6&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

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@catamaranco.com> wrote in message
news:OHPKsDCcEHA.2520@TK2MSFTNGP12.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]

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@dnartreb.noraa> wrote in message
news:uVyljKCcEHA.1644@tk2msftngp13.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@catamaranco.com> wrote in message
> news:OHPKsDCcEHA.2520@TK2MSFTNGP12.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]

Little bit here:
http://www.aspfaq.com/2343

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:OKLAnQCcEHA.3944@tk2msftngp13.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@dnartreb.noraa> wrote in message
> news:uVyljKCcEHA.1644@tk2msftngp13.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@catamaranco.com> wrote in message
> > news:OHPKsDCcEHA.2520@TK2MSFTNGP12.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]

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@dnartreb.noraa> wrote in message
news:uVyljKCcEHA.1644@tk2msftngp13.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@catamaranco.com> wrote in message
> news:OHPKsDCcEHA.2520@TK2MSFTNGP12.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]

> 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

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@dnartreb.noraa> wrote in message
news:Os9nlkMcEHA.1408@TK2MSFTNGP12.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]