External Connection String

[KJ]

This is kind of confusing. I'm trying to create a connection string to
connect to a database on another server supposely in the network.


Now if I set the Data Source = dbservername on my local computer it
works

I can ping the server by usually ping dbservername.

But when I upload my asp.net appliaction to the web server, it does
not work.

Now I'm not a network person but what do I need to do?

I have the internal ip and the host name and the port if needed.

To get it to work on my local machine. I had to setup an alias.

Please Help

 

[jji]

what error you got ?

Jason

 

[Jeff Dillon]

The question is...can the webserver ping the database server?

Find out, before responding. Ask others around you, or make a phone call to
the people who run the webserver.

Jeff

 

[Kevin Spencer]

All databases are NOT created equal. What's yours?

Also, it would help if you posted the entire Connection String. Feel free to
change the names to protect the innocent, if necessary.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

 

[Shaun Wilde]

If you can't ping the database server from the webserver then you could add
the details of the IP Address of the databaseserver to your hosts file.
found in system32/drivers/etc

Shaun

 

[Kyle Johnson]

Alright

I can ping the IP address of the dbserver from the webserver. The
server in the DMZ is not setup for internal DNS.

This is what Network support told me.

Now below is my Connectionstring

<add key="ConnectionString" value="Data Source=ABCSQL1;Initial
Catalog=MSORCLReport; User ID=bill1;Password=#Oracle1!" />

Thanks

 

[Guest]

can u please tell us the database u are trying to connect ?

suresh

 

[Kevin Spencer]

Looks like a SQL Server Connection String offhand, although that password
has me confused. Just to be sure, what IS the database?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

 

[BillGatesFan]

Hey I figured it out. My connection string was wrong. The web server
could not resolve the server name so I had to use the IP address
followed by the port.

eX. Data Source=1.1.1.1,2300

And that worked!

Thanks