Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zoikina
Starting Member
5 Posts |
 Posted - 2005-09-02 : 11:25:05
|
| Hi there, I'm hoping someone out there can help me.At my old job, I developed web applications that were based off of a MySQL server. I used PHPMyAdmin and learned the PHP coding, and although not formally trained in DBA or anything, I became very comfortable with using it and building database applications. I did everything through SQL/PHP script coding or through PHPMyAdmin. At my new job, I decided to build a database, but only had access to MS Access, which I can use, but don’t necessarily like. One day, in earshot of one of our admins, I grumbled “if I only had access to a SQL server, I’d turn this thing into a very cool web application.” Well, he heard, and gave me access to the SQL server and the web server. Thing is, it’s not MySQL, but MS SQL Server. And I feel like I am at a total loss. I was able to build a basic database in the Enterprise Manager on the SQL server, and create a web site on the web server, but I don’t even know how to begin to connect the two – what is the equivalent of MySQLConnect? I know I would have to learn the VBScript and everything for the advanced stuff, but for right now, I just want to make a simple web page that will do a simple select query from a database and return the rows, and simple forms to input into the database. How do I begin? What do I need to know to begin? I have a feeling the applications already on the server were contracted out, so I don’t actually know if anyone here could help me. Thanks for your help. |
|
|
zoikina
Starting Member
5 Posts |
Posted - 2005-09-02 : 14:53:16
|
| It's me again.I figured it out - I opened a ADODB Connection. I found the instructions at the http://www.w3schools.com web site. So now that I'm sort of on my way, if anyone can recommend any sites for tutorials or help forums, that would be super.Thanks. Zoik. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-03 : 01:52:25
|
| "New to SQL Server, Old to MySql"Welcome to SQL Team, zoikina !Kristen |
|
|
|
|
|
|
|
|
New to SQL Server, Old to MySql