HELP!!: Can Connect via VB/Can't via ASP 
Author Message
 HELP!!: Can Connect via VB/Can't via ASP

I have a simple ASP that attempts to connect to a sqlserver database. The
call times out with the 80004005 General Network Error. A VB app using the
same connection string is able to connect without a problem.
I am running NT Server v4.0 sp6
                    IIS v4
                    ado v2.5
                    sqlserver v7
The article on the MS site
( http://www.*-*-*.com/ ) indicates
the cause may be the renaming of the SQL Server computer. Wouldn't I run
into the same problem in VB as well?
I have tried to explcitly cerate the adodb.connection.2.5, but to no avail.
Is there a difference in the way that IIS is translating the sqlserver alias
to IP Address? Since both applications are using ADO shouldn't the
translation be the same?

I have reinstalled the NT4 sp6 and SQL 7. Even trying to connect via ODBC
results in the same error message.
Does anybody have any suggestions?

Thanks in advance.

Here is the simplest example of IIS Code that cannot connect:
<%
dim rs

dim ObjdbConn
set ObjdbConn = server.CreateObject("ADODB.Connection.2.5")

objDbConn.Open "Driver={SQL
Server};Server=DEV-99;Database=MNetDev;uid=tom;pwd=password;"
%>

or

<OBJECT RUNAT=server PROGID=ADODB.Connection.2.5 id=conn> </OBJECT>
<TITLE></TITLE>
</HEAD>
<BODY>

<%
conn.ConnectionString= "Driver={SQL
Server};Server=DEV-99;Database=MNetDev;uid=tom;pwd=password;"
conn.Open
%>

</BODY>
</HTML>



Mon, 06 Jan 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. 'Canned' data in VB program

2. line graph in vb (canned routine)

3. NEED HELP - Can't connect to SQL7 Via ADO

4. How do I create a canned form?

5. Canned AcctReceivable Module needed!

6. Canned pages....

7. Connecting to Access via Visual Basic via Internet

8. Cans access2.0 engine access btrieve files?

9. Crystal Reports Canned Code

10. Canned objects and/or images

11. Switching from inhouse software to canned package.

12. Looking 4 Canned Control

 

 
Powered by phpBB® Forum Software