Just installed new Computer running Windows XP Home SP2. I use to have
Windows 2000 ISA server and Windows 2000 SQL Server along with my windows
2000 workstation. Well I decided to nix all that and settle for just one
computer with a lot of disk space and memory. The old electric bill is now
better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another product
that would run my web site on my computer. I installed Apache and it seems
to be working with my HTM pages I developed them using Frontpage 2003.
I then installed SQL 2000 Developers software and imported the orginal
databases I used and that seems to be working fine also.
Now for the problem.
The asp pages I wrote will not connect to the sql database. here is my
original db_connect.inc
<%
strConnect ="Provider=MSDASQL.1;Password=$sql;Persist Security
Info=False;Server=TGCS-PHI4-NT;User ID=sa;Data Source=SQL;Initial
Catalog=WrestlingHistory"
%>
My workstation name is TGKW001 which is what the SQL Server is called on my
local computer.
I am not sure what I need to specify for the strConnect
Any ideas or suggestions
Thanks in advance
Tom 10 1288
On Tue, 4 Jan 2005 17:39:42 -0500, "Thomas Grassi"
<th**********@hotmail.com> wrote: Just installed new Computer running Windows XP Home SP2. I use to have Windows 2000 ISA server and Windows 2000 SQL Server along with my windows 2000 workstation. Well I decided to nix all that and settle for just one computer with a lot of disk space and memory. The old electric bill is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another product that would run my web site on my computer. I installed Apache and it seems to be working with my HTM pages I developed them using Frontpage 2003.
I then installed SQL 2000 Developers software and imported the orginal databases I used and that seems to be working fine also.
Now for the problem.
The asp pages I wrote will not connect to the sql database. here is my original db_connect.inc <% strConnect ="Provider=MSDASQL.1;Password=$sql;Persist Security Info=False;Server=TGCS-PHI4-NT;User ID=sa;Data Source=SQL;Initial Catalog=WrestlingHistory" %>
My workstation name is TGKW001 which is what the SQL Server is called on my local computer.
I am not sure what I need to specify for the strConnect
Any ideas or suggestions
Thanks in advance
Tom
Since you're using Apache, how are you doing ASP processing? By
default I don't think apache can do ASP.
Please do not multipost Thomas. This is definitely a database-related
question
so .asp.db was the perfect group in which to post it. Posting it here as
well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.
There are times when you will not be sure which group is most appropriate,
and you will want to post a question to both groups. In that situation, you
should use the cross-posting technique, rather than posting the same message
multiple times. To crosspost, put a semicolon-delimited* list of the
newsgroups to which you wish to post in the To: header of your post and post
it once. It, and any replies to it, will appear in all the newsgroups in
your list. So, if I reply in .asp.db, my reply will also appear here in
..asp.general.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Handy
Well I am not sure how that is working. Maybe thats the problem. I was under
the impression that Apache was and IIS replacement. If that is not so then I
may have to bite the bullet and upgrade to Windows XP Pro
Any thoughts?
Tom
"handy" <ha********@gmail.com.killthis.com> wrote in message
news:93********************************@4ax.com... On Tue, 4 Jan 2005 17:39:42 -0500, "Thomas Grassi" <th**********@hotmail.com> wrote:
Just installed new Computer running Windows XP Home SP2. I use to have Windows 2000 ISA server and Windows 2000 SQL Server along with my windows 2000 workstation. Well I decided to nix all that and settle for just one computer with a lot of disk space and memory. The old electric bill is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another product that would run my web site on my computer. I installed Apache and it seems to be working with my HTM pages I developed them using Frontpage 2003.
I then installed SQL 2000 Developers software and imported the orginal databases I used and that seems to be working fine also.
Now for the problem.
The asp pages I wrote will not connect to the sql database. here is my original db_connect.inc <% strConnect ="Provider=MSDASQL.1;Password=$sql;Persist Security Info=False;Server=TGCS-PHI4-NT;User ID=sa;Data Source=SQL;Initial Catalog=WrestlingHistory" %>
My workstation name is TGKW001 which is what the SQL Server is called on my local computer.
I am not sure what I need to specify for the strConnect
Any ideas or suggestions
Thanks in advance
Tom
Since you're using Apache, how are you doing ASP processing? By default I don't think apache can do ASP.
On Tue, 4 Jan 2005 17:55:46 -0500, "Thomas Grassi"
<th**********@hotmail.com> wrote: Well I am not sure how that is working. Maybe thats the problem. I was under the impression that Apache was and IIS replacement. If that is not so then I may have to bite the bullet and upgrade to Windows XP Pro
Any thoughts?
IIS and Apache are both web servers. Both can handle ASP, though IIS
is far better at it. Have you tested your Apache install with a
"Hello World!" ASP page? If not, do so. If you need help configuring
Apache for ASP, there are Apache support groups and lists for that
help.
Jeff
Tom "handy" <ha********@gmail.com.killthis.com> wrote in message news:93********************************@4ax.com.. . On Tue, 4 Jan 2005 17:39:42 -0500, "Thomas Grassi" <th**********@hotmail.com> wrote:
Just installed new Computer running Windows XP Home SP2. I use to have Windows 2000 ISA server and Windows 2000 SQL Server along with my windows 2000 workstation. Well I decided to nix all that and settle for just one computer with a lot of disk space and memory. The old electric bill is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another product that would run my web site on my computer. I installed Apache and it seems to be working with my HTM pages I developed them using Frontpage 2003.
I then installed SQL 2000 Developers software and imported the orginal databases I used and that seems to be working fine also.
Now for the problem.
The asp pages I wrote will not connect to the sql database. here is my original db_connect.inc <% strConnect ="Provider=MSDASQL.1;Password=$sql;Persist Security Info=False;Server=TGCS-PHI4-NT;User ID=sa;Data Source=SQL;Initial Catalog=WrestlingHistory" %>
My workstation name is TGKW001 which is what the SQL Server is called on my local computer.
I am not sure what I need to specify for the strConnect
Any ideas or suggestions
Thanks in advance
Tom
Since you're using Apache, how are you doing ASP processing? By default I don't think apache can do ASP.
On Tue, 04 Jan 2005 23:02:43 GMT, je*********@zina.com (Jeff Cochran)
wrote: On Tue, 4 Jan 2005 17:55:46 -0500, "Thomas Grassi" <th**********@hotmail.com> wrote:
Well I am not sure how that is working. Maybe thats the problem. I was under the impression that Apache was and IIS replacement. If that is not so then I may have to bite the bullet and upgrade to Windows XP Pro
Any thoughts?
IIS and Apache are both web servers. Both can handle ASP, though IIS is far better at it. Have you tested your Apache install with a "Hello World!" ASP page? If not, do so. If you need help configuring Apache for ASP, there are Apache support groups and lists for that help.
Really? I wasn't aware Apache had added asp processing. Used to be
you had to use Chilisofts stuff (acquired by Sun now).
I'll have to look into it - is there an asp module or is it 'native'
to apache?
There is an apache module for asp but it only supported perlscript the last
time I looked (a couple of months ago). They also appear to be working on a
..net module. http://httpd.apache.org/related_projects.html#apacheasp
--
--Mark Schupp
Head of Development
Integrity eLearning www.ielearning.com
"handy" <ha********@gmail.com.killthis.com> wrote in message
news:ij********************************@4ax.com... On Tue, 04 Jan 2005 23:02:43 GMT, je*********@zina.com (Jeff Cochran) wrote:
On Tue, 4 Jan 2005 17:55:46 -0500, "Thomas Grassi" <th**********@hotmail.com> wrote:
Well I am not sure how that is working. Maybe thats the problem. I was under the impression that Apache was and IIS replacement. If that is not so then I may have to bite the bullet and upgrade to Windows XP Pro
Any thoughts?
IIS and Apache are both web servers. Both can handle ASP, though IIS is far better at it. Have you tested your Apache install with a "Hello World!" ASP page? If not, do so. If you need help configuring Apache for ASP, there are Apache support groups and lists for that help. Really? I wasn't aware Apache had added asp processing. Used to be you had to use Chilisofts stuff (acquired by Sun now).
I'll have to look into it - is there an asp module or is it 'native' to apache?
On Tue, 04 Jan 2005 16:45:38 -0700, handy
<ha********@gmail.com.killthis.com> wrote: On Tue, 04 Jan 2005 23:02:43 GMT, je*********@zina.com (Jeff Cochran) wrote:
On Tue, 4 Jan 2005 17:55:46 -0500, "Thomas Grassi" <th**********@hotmail.com> wrote:
Well I am not sure how that is working. Maybe thats the problem. I was under the impression that Apache was and IIS replacement. If that is not so then I may have to bite the bullet and upgrade to Windows XP Pro
Any thoughts?
IIS and Apache are both web servers. Both can handle ASP, though IIS is far better at it. Have you tested your Apache install with a "Hello World!" ASP page? If not, do so. If you need help configuring Apache for ASP, there are Apache support groups and lists for that help. Really? I wasn't aware Apache had added asp processing. Used to be you had to use Chilisofts stuff (acquired by Sun now).
I'll have to look into it - is there an asp module or is it 'native' to apache?
There is an ASP MOD but it's Perlscript, not VBScript (Makes sense if
you're running Apache anyway). There's always Chilisoft's ASP as
well. And if you're running Apache, you're likely developing in
Perl/PHP or anything but ASP/ASP.NET.
Jeff
Thomas Grassi wrote: Just installed new Computer running Windows XP Home SP2. I use to
have Windows 2000 ISA server and Windows 2000 SQL Server along with my
windows 2000 workstation. Well I decided to nix all that and settle for just
one computer with a lot of disk space and memory. The old electric bill
is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another
product that would run my web site on my computer. I installed Apache and it
seems to be working with my HTM pages I developed them using Frontpage
2003.
Just upgrade and sick with XP Pro. Forget Apache if you're doing ASP.
Thomas Grassi wrote: Just installed new Computer running Windows XP Home SP2. I use to
have Windows 2000 ISA server and Windows 2000 SQL Server along with my
windows 2000 workstation. Well I decided to nix all that and settle for just
one computer with a lot of disk space and memory. The old electric bill
is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another
product that would run my web site on my computer. I installed Apache and it
seems to be working with my HTM pages I developed them using Frontpage
2003.
Just upgrade and stick with XP Pro. Forget Apache if you're doing ASP.
Thomas Grassi wrote: Just installed new Computer running Windows XP Home SP2. I use to
have Windows 2000 ISA server and Windows 2000 SQL Server along with my
windows 2000 workstation. Well I decided to nix all that and settle for just
one computer with a lot of disk space and memory. The old electric bill
is now better. But my problems have just begun.
Since Windows XP Home does not support IIS I had to find another
product that would run my web site on my computer. I installed Apache and it
seems to be working with my HTM pages I developed them using Frontpage
2003.
Just upgrade and stick with XP Pro. Forget Apache if you're doing ASP. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Google Mike |
last post by:
After a lot of thought and research, and playing with FreeTDS and
InlineTDS, as well as various ODBC connections, I have determined that
the fastest and cheapest way to get up and going with PHP on...
|
by: Ramir Santos |
last post by:
my analysis server is hosted on a win2k server with IIS, the hosting page is
on another machine. I have followed everything as per MS KB article and I
could not connect through the analysis server...
|
by: TP |
last post by:
Hi,
This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.
Right now I...
|
by: Ann Marinas |
last post by:
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed...
|
by: Jeremy Dillinger |
last post by:
I am trying to design a program that will use data from a MySQL database.
Currently all the data is being used with PHP scripts from a website. I am
also trying to build a software solution that...
|
by: NewsReader |
last post by:
Hello,
I have been looking around the net for a script to help me connect to and
help gather information from Cisco routers/switches. I have pieced together
a couple of different scripts from...
|
by: cj.snead |
last post by:
Hello,
I am having trouble connecting to a remote named instance of SQL Server
via Pocket PC. I have had absolutely no luck connecting with VS 2005
(even to a default instance), so I wen't back...
|
by: =?Utf-8?B?R2lkaQ==?= |
last post by:
Hi,
I've my win32 application which connecting to my sql database.
till now i used MSDE as my database and now i want to upgrade to sql express
2005. after the upgrade i tried to connect to the...
|
by: mairhtin o'feannag |
last post by:
Hello,
I'm having problems connecting to my new v9 db box. The pertinent
information is below:
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END...
|
by: aboutjav.com |
last post by:
Hi,
I need some help. I am getting this error after I complete the asp.net
register control and click on the continue button. It crashed when it
tries to get
it calls this Profile property
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |