v were uploading some pages and uploaded the entire database.

it was successful but there was a problem regarding viewing asp pages 

which had connectivity involved.



now the error shows on the line where v give the connection string. 

everything is right abt it. the username,password of the database on the 

server(i.e the one they gave) , the IP address of the server computer, and 

the database name of the server computer, everything is right.



surprisingly the same thing works when v right click on the page and view 

it through visual interdev. it then connects and shows the page properly.

(the connection string is that of their server where v have uploaded their 

files). but when v try to view the page by giving the link on the address 

bar:

i.e

www.akknshamillennium.om/product_detail.asp

it gives an SQL server error. i.e on the connection string line.

using the same connection string v tried connecting to their server using 

VB and it works perfectly alright.

can u pls suggest something abt this.



awaiting your reply. 

> surprisingly the same thing works when v right click on the page and view

> it through visual interdev. it then connects and shows the page properly.



    Does it connect to the remote server and display the page properly, or

is still on the local machine that you connect to with InterDev?



    I've never tried specifying the IP address in the connection string

before, however I have created an ODBC connection to an IP address and used

it in my DSN parameter.  Is it possible for you to do likewise?



- Chuck



----- Original Message -----

From: "Arvind " <arvindsud@r...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, April 20, 2001 10:07 PM

Subject: [asp_databases] ASP problem





> v were uploading some pages and uploaded the entire database.

> it was successful but there was a problem regarding viewing asp pages

> which had connectivity involved.

>

> now the error shows on the line where v give the connection string.

> everything is right abt it. the username,password of the database on the

> server(i.e the one they gave) , the IP address of the server computer, and

> the database name of the server computer, everything is right.

>

> surprisingly the same thing works when v right click on the page and view

> it through visual interdev. it then connects and shows the page properly.

> (the connection string is that of their server where v have uploaded their

> files). but when v try to view the page by giving the link on the address

> bar:

> i.e

> www.akknshamillennium.om/product_detail.asp

> it gives an SQL server error. i.e on the connection string line.

> using the same connection string v tried connecting to their server using

> VB and it works perfectly alright.

> can u pls suggest something abt this.

>

> awaiting your reply.