Server-Side Applications

[fdsouth]

I recently designed a web site uses a few .ASP pages to read from a MS Access database and publish data based on a SELECT statment. I got everything working fine on my development computer (at work running NT & PWS). When I FTP'd everything over to my ISP, the links to the .ASP pages wouldn't work. I called and the ISP told me that on their customer's "free" web space they don't support server-side applications, including .ASP pages, since the platform is UNIX. They did graceously offer to support me for a minimum of $50 per month.

Is it possible to get around this and place the code into an .HTML file as VBScript or is that functionally the same thing? How else can I access the database, maybe from the client-side?

Thanks in advance.

 

[Trevman]

There is no way to access a database from the client side- as it would have to exist on the clients computer -- and even then it would not really be possible. Unfortionately, even though there are many things you can do on the client side -- web databasing isn't one of them. ===
Supports Mozilla and Web Standards
Knows HTML/XHTML, CSS1, JavaScript, PHP, C++, DOM1
===

 

[keypounder]

Hi dsouthard,
ask if they run chili ASP
if this is a valuable unix environment they should run it.
you may also consider since we are in Unix environment
ask if they support MySQL (Unix SQL version)(they should)
and by the same token use the MS access capability to
transfer MS access on a SQL server.(MySQL)

there is also some good application PHP/PERL
that will auto load your DB in MySQL
MY ISP does all of that
If you need the address let me know.

 

[fdsouth]

Thanks keypounder, I'll check to see if they support MySQL. Next question... If they do, how do I convert my MS Access database table into a MySQL table so I can access it using SELECT statements, etc. I downloaded MySQL and loaded it on my computer. It came with all the documentation I would probably need, but if you could help by pointing me in the right direction, I won't have to learn it from scratch.

Thanks again.

 

[keypounder]

I did not do that since a while however the only task from client (you ) to server should be automated through MS Access
you need first to create a ODBC
Set up ODBC data sources
Click the Windows Start button, point to Settings, click Control Panel, and then double-click the ODBC (32bit) icon (in Microsoft Windows 95 or later) or ODBC icon (in Microsoft Windows NT Workstation 4.0 or later).


Select the User DSN, System DSN, or File DSN tab, depending on the type of data source to be modified. More information about data sources.


To define a new data source for a currently installed driver, click Add.


To modify the definition of an existing data source:
Select the data source from the list. If you are modifying a file DSN, find the appropriate folder in the Look In box (use the Up control if necessary), and then select the data source from the folder.


Click Configure.
Complete the dialog boxes. For more information about the different options, click the Help button in each dialog box.

good luck

 

[keypounder]

forgot to mention
you should not have to write any SQL language
MS is set to transfer Access directly in SQL or Mysql version
so you keep working in Access environment
(hope I am correct)
from Access you should be able to verify my assertions

 

[fdsouth]

OK, got the Access database migrated to MySQL. From within my .HTML file how do I connect and run the SELECT statment. As I said I was using VBScript from within an .ASP page to process the request but that won't work on UNIX. I think I need to use Perl, but I hadn't even heard the term until today. Suggestions?

 

[keypounder]

try these links

http://www.socs.uts.edu.au/doc/pkg/MySQL/manual_187.html

http://www.mysql.com/doc/

http://hotwired.lycos.com/webmonkey/99/21/index2a.html

http://www.devshed.com/Server_Side/MySQL/ODBC/

 

[MikeT]

PHP was pretty much made for this situation.
You can even download a php processor for your PWS dev machine for free. Plus, php and MySQL play very well together.

http://www.php.net

is a great resource.
Be sure to make sure your host doesn't charge for php processing.

Keep us posted as to your progress!

 

[WhiteTiger]

Trevman is wrong, you can access databases over the web...my intranet me and my father set up over the office is on our hosted server...we can take anywhere on the internet, connect to the server, and our intranet asp pages, etc can be accessed via the web...not ASP pages on the web, we put them on the persons computer, and dynamically change the IP address to our server...we made some software the integrates for that kind of stuff...we also have a TON of tools we've made that were thinking of marketing...

These tools are things people always want, but I've looked all over the internet for them, and no one has 'em...MWA HAHAHAH! Regards,
Anthny
----------------------------------------
"You say [red]insanity[/red] like it's a BAD THING!"