| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 39741 | 2003-11-15 22:08:00 | Which Server Operating System Setup? | Erin Salmon (626) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 192301 | 2003-11-16 02:12:00 | Well, actually, yes. :D "apache ASP" to Google will find you the software. Looks as if there are enough smart people who don't like kilodollar pacakages, and are competent to do something about it. |
Graham L (2) | ||
| 192302 | 2003-11-16 02:33:00 | Yeah, there's Chillisoft, and I think one other, but they don't support about half of the language. I've tried using Chillisoft for example, but a lot of things are missing. From memory, it does do CDONTS, and there were some recordset commands it wasn't allowing. Not really worth the hassle. I think if you want to go ASP, you've got to go Microsoft. PHP can stay with Linux, ASP can stay with M$. :) Erin |
Erin Salmon (626) | ||
| 192303 | 2003-11-16 02:39:00 | Another thing... I've been browsing around to get a feel for what the various options cost - and I've discovered that Microsoft Small Business Server 2000 has SQL Server 2000 with it. However, I've been unable to find out anywhere which version of SQL Server it is. The only editions you can run in a live environment are SQL Server Standard or Enterprise Editions. Developer Edition allows you to use absolutely everything, but you can't make it live. Therefore, if SBS has SQL Server Standard with it (probably not), it would be an option. However, can someone explain the business with CALs to me - if you are running a webserver, what is the relevance of CALs? Do you need one CAL per connection, or one CAL per device the server communicates with, or one CAL per admin logged in to the server? Thanks, Erin |
Erin Salmon (626) | ||
| 192304 | 2003-11-16 02:58:00 | Chillisoft? A commercial thing? Apache::ASP is what you'll find from that google search. ;-) It'sa Perl based ASP implementation. I would say it's going to be a very actively developed/improved Open Source product. |
Graham L (2) | ||
| 192305 | 2003-11-16 03:46:00 | >>PHP can stay with Linux, ASP can stay with M$. I have used ASP with mySQL and it worked fine (using OBDC). I have also setup PHP to work with IIS 5.0 and again it worked fine for me. At the end of the day, it is your choice. |
Dolby Digital (160) | ||
| 192306 | 2003-11-16 04:18:00 | Hi, Dolby, can you run past me how you set up ASP and mySQL? Under windows, or using Apache ASP? Where can you get the necessary software from? Cheers, Erin |
Erin Salmon (626) | ||
| 192307 | 2003-11-16 04:32:00 | www.mysql.com There should be documentation there that details installation on Windows. Then it's just a matter of learning how to access MySQL dbases using ASP. |
agent (30) | ||
| 192308 | 2003-11-16 06:04:00 | Apache, PHP, MySQL (possibly PostgreSQL). They'll run fine under win32 as well if that is what you want. | -=JM=- (16) | ||
| 192309 | 2003-11-16 09:05:00 | Hi, agent - have set up mySQL with ASP as you described, and have created a DSN-less connection to it from an ASP website already known to be working correctly in all regards. So far all works fine, except that when I try to take two values out of the database (both are Decimal 10,0) and multiply those values, I get: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch /u3/parts/Products.asp, line 118 Any ideas? Cheers, Erin |
Erin Salmon (626) | ||
| 192310 | 2003-11-16 22:52:00 | Erin, You should put a checking procedure in your script to determine if the values out of your database are being returned as NULL. If it's returning NULL, that's usually when that error message shows, you should know what to do, basically just make sure the data returned isn't NULL, usually setting it to "" would do. |
Kame (312) | ||
| 1 2 3 4 | |||||