Hi,

I have a question between ASP & SQL Server.

I am new.

I created a ASP website, I put the MS Access database file in the ASP Account. And then, I wrote the code to open the MS Access file.
This one is ok.

Recently, I install the SQL Server into my home computer, my computer is NOT server.
If I write the code to open the SQL Server. I cannot do it, because SQL Server is NOT a file, I cannot upload the file to my ASP Account, right.
So, I cannot connect the SQL Server from ASP to SQL Server,
if I want to connect from ASP to SQL Server,
Must I make a independent server on another computer for running the ASP website only?
Please let me know, thanks.

Hi,

There is a few confusing things in this post,

what do you mean open the sql server from asp??

what do you mean sql server is not a file??
SQL server is 2 files per database or more

Which version of sql server did you install on your home machine?
is the sql service running on that machine?