Any web devlopers here?
Thread Starter
|
Elder User
Joined: Sep 2002
Posts: 772
Likes: 0
From: White Sands, NM
Any web devlopers here?
Hi folks. I figure somebody here has to have experiance with developing web applications with vb.net
I've been developing windows applications with Visual Basic since version 4, and builiding web pages since you had to type the HTML out yourself, but I'm now trying to learn to merge the two skills with VB.Net.
Specifically, I'm trying to learn about the relationship of databases and web servers. Other than having to interface with legacy Sybase SQL server many, many moons ago, I've always used the Jet database engine in my application.
Now I want to use something a little more capable. My first choice was MS SQL server 2000, since VB.net integrates so easily with it, but my web host doesn't run a MS SQL server. They do however run a MySQL server.
My first question would be can I still use a MS SQL Server database, if I connect to it through ODBC instead of ADO?. When I deploy the application to the web server, wouldn't the ODBC drivers be deployed with it and allow the web server access to the database? In other words, does a web server use ODBC just like any other computer?
I've been developing windows applications with Visual Basic since version 4, and builiding web pages since you had to type the HTML out yourself, but I'm now trying to learn to merge the two skills with VB.Net.
Specifically, I'm trying to learn about the relationship of databases and web servers. Other than having to interface with legacy Sybase SQL server many, many moons ago, I've always used the Jet database engine in my application.
Now I want to use something a little more capable. My first choice was MS SQL server 2000, since VB.net integrates so easily with it, but my web host doesn't run a MS SQL server. They do however run a MySQL server.
My first question would be can I still use a MS SQL Server database, if I connect to it through ODBC instead of ADO?. When I deploy the application to the web server, wouldn't the ODBC drivers be deployed with it and allow the web server access to the database? In other words, does a web server use ODBC just like any other computer?
Last edited by AegisSailor; Oct 29, 2004 at 06:25 PM.
Junior User
Joined: Jun 2001
Posts: 84
Likes: 0
From: Houston
I would definitely agree with Webmaster, especially about getting away from MS databases. I am a former VB programmer, too, and a couple of years ago made the decision to start going open source as often as possible to avoid all the problems--and costs--inherent in using Microsoft products.
If you're working with dynamic, database-driven web pages, I recommend using PHP for the programming and MySQL for the database. Most web hosts support both, they are both open source, and many web development tools--Dreamweaver, for instance--support PHP, too.
There is definitely a learning curve moving from VB to PHP, but once you use PHP, you will be amazed at how much easier it is to write code with PHP than it was with VB. You also won't have to shell out big bucks for Microsoft's next development environment or worry about service packs breaking your apps.
Sorry that isn't the answer you wanted, but in the long run, you will be better off than trying to work with SQL Server, etc.
If you're working with dynamic, database-driven web pages, I recommend using PHP for the programming and MySQL for the database. Most web hosts support both, they are both open source, and many web development tools--Dreamweaver, for instance--support PHP, too.
There is definitely a learning curve moving from VB to PHP, but once you use PHP, you will be amazed at how much easier it is to write code with PHP than it was with VB. You also won't have to shell out big bucks for Microsoft's next development environment or worry about service packs breaking your apps.
Sorry that isn't the answer you wanted, but in the long run, you will be better off than trying to work with SQL Server, etc.
Thread
Thread Starter
Forum
Replies
Last Post
