External Connection String

  • Thread starter Thread starter KJ
  • Start date Start date
K

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
 
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
 
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.
 
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
 
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
 
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.
 
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
 
Back
Top