|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
December 20th, 2001, 11:07 AM
|
|||
|
|||
ASP & SQL Server help needed
Hi,
I need to develop some ASP pages with a SQL Server Backend ... I've only used Access 2000 so far and would always just put a copy of the Access database in the WWW Root folder for connections. Now I need to use ASP to connect to SQL Server 6.5 which looks ridiculously overcomplicated from what I'm used to ... I'd rather use MySQL and PHP but the job requires ASP/SQL setup ... anyway, when I make my site in the WWW Root and set up my connections to the database, do I just map my connection to a database in the SQL Server directory? Or can SQL Server manage a database in the InetPub/WWW Root directories? Any insight would be appreciated. Thanks.
|
|
#2
December 30th, 2001, 02:56 PM
|
|||
|
|||
|
I don't have any experience with SQL Server 6.5, just 7 and 2000, so I'm not positive that this will apply, but I think it will.
To connect to a SQL Server database in ASP, you use a connection string that specifies the IP address of the SQL Server and specifies a database. This way, you let SQL Server worry about where to keep the files.
__________________
Lucas Alexander http://www.alexanderdevelopment.net
|
|
| Viewing: Dev Shed Forums > Other > Beginner Programming > ASP & SQL Server help needed |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
