MS SQL

[suklee]

We have a MS SQL database at work (MSDE with 2GB limit), and I want to write a simple intranet application to access the database. To start, I want to access the products and display the item number, item description, and the associated JPG.

Should I go with PHP or ASP, assuming I have limited (=zero) knowledge of both languages?

The server has Apache 1.3 and Tomcat 3.3 installed, FWIW... TIA.

 

[tfinch2]

php

 

[torpid]

ASP would be a difficult on an apache server. And costly.

 

[suklee]

great, thanks for the unanimous decision! :beer:

 

[boran]

apache --> php
IIS --> asp

it's about as simple as that, getting php on IIS is not easy and getting asp on apache is not easy.

 

[suklee]

Do you guys recommend downloading "PHP 4.3.11 installer [1,054Kb]" or "PHP 5.0.4 installer [2,272Kb]" with my version of Apache?

 

[everman]

If this is a really simple app, php 4.3.11 will be fine, unless you want to use any features in 5.0?

 

[suklee]

No, probably very simple and I'll go with 4.3.11 to start. Thnx

 

[notfred]

You should get an IIS webserver or a MySQL database server.

 

[suklee]

We already have Apache 1.3.x and MSDE installed... so figure might as well make use of it.

btw nice greasemonkey script there :thumbsup:

 

[kamper]

Originally posted by: boran
getting php on IIS is not easy and getting asp on apache is not easy.

My experience installing php with IIS has been just click and run, easiest thing in the world. Maybe I just got lucky?

 

[mugs]

Wait... are Apache and MSDE on the same machine? Meaning you installed Apache on a windows machine? Why not just use IIS?

 

[mugs]

Originally posted by: kamper

Originally posted by: boran
getting php on IIS is not easy and getting asp on apache is not easy.

My experience installing php with IIS has been just click and run, easiest thing in the world. Maybe I just got lucky?

Same here... now, I've never tried to get PHP code that I wrote on a linux machine to run on a windows machine, but I don't imagine there would be any difficulties there either.

 

[suklee]

Originally posted by: mugs
Wait... are Apache and MSDE on the same machine? Meaning you installed Apache on a windows machine? Why not just use IIS?

Correct. Don't ask me why, I didn't do it! We bought a software system that has a JAVA front-end, and they setup Apache, Tomcat, and MSDE for us on the server.

 

[Red and black]

If you're running Apache on an MSwindows machine, you really want to be using Apache 2.X. Apache 1.3 on MSwindows is not reliable, particularly mod_ssl. Trust me on this. You can google if you want for equivalent statements from the Apache developers.

But I agree with the other posters who questioned the whole MSwindows thing in the first place. For a simple DB-driven web page, some linux-based system with Apache 1.3, PHP, and MySQL is the standard low-cost easy-to-set-up way. For a more complex app, you could substitute Perl or Ruby or Python instead of PHP, and PostgreSQL instead of MySQL.

 

[suklee]

OK, new question from the super SQL n00b...

I've got a pw with read access and have connected to the database. I just want to see what the column names are... basically SEE what sorts of data is inside. how do I do that? ( i dont even know what the field names are)

 

[WildHorse]

 

[oog]

Originally posted by: Kai920
OK, new question from the super SQL n00b...

I've got a pw with read access and have connected to the database. I just want to see what the column names are... basically SEE what sorts of data is inside. how do I do that? ( i dont even know what the field names are)

sp_columns @table_name=whatever (or you can do a select *)

 

[suklee]

Originally posted by: oog

Originally posted by: Kai920
OK, new question from the super SQL n00b...

I've got a pw with read access and have connected to the database. I just want to see what the column names are... basically SEE what sorts of data is inside. how do I do that? ( i dont even know what the field names are)

sp_columns @table_name=whatever (or you can do a select *)

I downloaded VsqlW to query my db because MSDE doesn't come with SQL Query Analyzer... I can use this right?

I entered sp_columns @table_name=v_pro; but nothing happens..

 

[oog]

it works for sql server. i just tried it. did you switch dbs? also, you may need to put "exec" in front. it's not necessary in query analyzer, but i don't know about VsqlW.

try this:

 

[statik213]

Originally posted by: kamper

Originally posted by: boran
getting php on IIS is not easy and getting asp on apache is not easy.

My experience installing php with IIS has been just click and run, easiest thing in the world. Maybe I just got lucky?

same here.... v. easy install

 

[torpid]

Originally posted by: Kai920

Originally posted by: oog

Originally posted by: Kai920
OK, new question from the super SQL n00b...

I've got a pw with read access and have connected to the database. I just want to see what the column names are... basically SEE what sorts of data is inside. how do I do that? ( i dont even know what the field names are)

sp_columns @table_name=whatever (or you can do a select *)

I downloaded VsqlW to query my db because MSDE doesn't come with SQL Query Analyzer... I can use this right?

I entered sp_columns @table_name=v_pro; but nothing happens..

Have you tried connecting to it using access 2000/2003?

 

[suklee]

Originally posted by: torpid
Have you tried connecting to it using access 2000/2003?

No I haven't, how would I do that, I don't see any option inside Access to do so.

 

[suklee]

Originally posted by: oog
it works for sql server. i just tried it. did you switch dbs? also, you may need to put "exec" in front. it's not necessary in query analyzer, but i don't know about VsqlW.

try this:

thanks, I tried that but didn't work. I was told the table I want to use is called V_PRO? but doesn't seem to work.

attached is screen cap:
Text

 

[suklee]

bumps