Asp not connecting to SQL DB

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

Re: Asp not connecting to SQL DB

Thomas Grassi wrote:


> 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;

Why use obsolete technology? There's a perfectly good native OLE DB provider
for SQL Server (SQLOLEDB) that will provide more functionality, robustness
and performance than the deprecated OLE DB Provider for ODBC (MSDASQL). See
www.connectionstrings.com for connection string examples.

> Password=$sql;Persist Security
> Info=False;Server=TGCS-PHI4-NT;User ID=sa;

Aargh! Don't use sa to connect from applications! sa has god-like powers!
Create a limited-permissions login to use for your applications. Guard the
sa account as if your job depended on it.

> 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

See the above link

>
> Any ideas or suggestions

Nope. You haven't sufficiently described the symptoms. Error messages?
Timeouts?


Bob Barrows
--
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.

Re: Asp not connecting to SQL DB

Bob

When I select the web page I get just the asp code displaying not the page
at all. I believe that the Connect command is the problem

What else would you need to see?

Thanks

Tom

"Bob Barrows [MVP]" wrote in message
news:%23ootf$q8EHA.4004@tk2msftngp13.phx.gbl...
> Thomas Grassi wrote:
>
>
>> 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;
>
> Why use obsolete technology? There's a perfectly good native OLE DB
> provider
> for SQL Server (SQLOLEDB) that will provide more functionality, robustness
> and performance than the deprecated OLE DB Provider for ODBC (MSDASQL).
> See
> www.connectionstrings.com for connection string examples.
>
>> Password=$sql;Persist Security
>> Info=False;Server=TGCS-PHI4-NT;User ID=sa;
>
> Aargh! Don't use sa to connect from applications! sa has god-like powers!
> Create a limited-permissions login to use for your applications. Guard the
> sa account as if your job depended on it.
>
>> 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
>
> See the above link
>
>>
>> Any ideas or suggestions
>
> Nope. You haven't sufficiently described the symptoms. Error messages?
> Timeouts?
>
>
> Bob Barrows
> --
> 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.
>
>

Re: Asp not connecting to SQL DB

Thomas Grassi wrote:
> Bob
>
> When I select the web page I get just the asp code displaying not the
> page at all. I believe that the Connect command is the problem
>
That means your server is not processing the asp. I missed the fact that you
were using apache. There's something called Chili-Soft that allows apache to
process asp. I don't know much about it but you may want to give it a try.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"