Accessing MSSQL Data from ASP - Serious Noob Question-

[phpsocialclub]

Ok I have to admit this is my first attempt at windows programming.

I have been programming on linux with Php/Perl and MySQL for a while and know my way around that pretty well, having written a bunch of web apps and what not.

I now work at a company that has a MsSQL 2003 database and a Small Business Server. The database holds the data for our CRM.

The CRM kinda sucks and I want to write a custom interface into the data.

I have been at a loss on where to start and where to look for info.

I have recently downloads Visual Basic Express, but have not really dug in yet.

Can anyone recommend any good tutorials for me to create a ASP pages that reference MsSQL a database.

Also are there any any development tools I should use?

Thanks for all your help.

Andrew

 

[DotNetGnat]

asp pages are just simple text pages with .asp extension that can be created using notepad...so no problem there...but if you are looking for a better development tool then you have lot of options...

1. Visual Interdev
2. Microsoft Frontpage
3. UltraEdit
4. TextPad
5. NoteTab
and so on...so select the one that you like...

as far as asp programming is concerned here are some websites that provide good tutorials for beginners...

http://www.w3schools.com/asp

http://www.4guysfromrolla.com

http://www.webwizguide.info/asp/

tutorials

http://www.aspin.com

http://www.asp101.com

also check this forum regularly and you will learn a lot...try to go through these websites and try to put together a simple page and post back if you have any questions...there are lot of helpful guys on this forum and you are sure to get the solution...

good luck...

-DNG

 

[QatQat]

What about Crimson Editor? I use it for VBScript but also for Perl and PHP on windoz.

Similar to Ultraedit but Freeware with nice features like Column mode replace on multiple documents (like Interdev).

In terms of websites, DNG has mentioned all ASP "Bibles"; I recommend w3schools for beginners as you can preview code in action and interact with it.

Cheers


QatQat



Life is what happens when you are making other plans.

 

[Sheco]

The SQL Server enterprise tools will probably come in handy... especially Query Analyzer and Enterprise Manager. If you can't get your hands on those then "Toad" is an option.