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 8 1624
what error you got ?
Jason
"KJ" <kl******@hotma il.com> wrote in message
news:d8******** *************** **@posting.goog le.com... 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
"KJ" <kl******@hotma il.com> wrote in message
news:d8******** *************** **@posting.goog le.com... 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
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.
"KJ" <kl******@hotma il.com> wrote in message
news:d8******** *************** **@posting.goog le.com... 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
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
"KJ" <kl******@hotma il.com> wrote in message
news:d8******** *************** **@posting.goog le.com... 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
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 Connectionstrin g
<add key="Connection String" value="Data Source=ABCSQL1; Initial
Catalog=MSORCLR eport; User ID=bill1;Passwo rd=#Oracle1!" />
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
can u please tell us the database u are trying to connect ?
suresh
"KJ" wrote: 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
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.
"Kyle Johnson" <kl******@hotma il.com> wrote in message
news:ui******** ******@tk2msftn gp13.phx.gbl... 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 Connectionstrin g
<add key="Connection String" value="Data Source=ABCSQL1; Initial Catalog=MSORCLR eport; User ID=bill1;Passwo rd=#Oracle1!" />
Thanks
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
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
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stephen Cook |
last post by:
Having worked through the problems around enabling the document function
using an XmlUrlResolver I started work on building a useful class to hide
the intricacies.
Trying to generalise the process I've hit a snag.
How do I resolve multiple external references?
The transform method on a stylesheet only takes one resolver, not an array
Stephen
|
by: Cybertof |
last post by:
Hello,
Is it possible to connect to an external (out of the lan) sql server
through c# code ?
I would like to connect directly my c# application to an external sql
server. (i'm at home on my laptop, the app is running on it, the
sqlserver is at the office, and visible through NAT configuration with a
special port).
If yes,
|
by: Sameers (theAngrycodeR) via .NET 247 |
last post by:
I think I will get MAD very soon. Its very weired problem I amfacing here. Let me explain.
I have two DBF files from which I want to export data in CSVformat. I created a desktop application and used followingconnectionstrings.
Provider=Microsoft.Jet.OLEDB.4.0; DataSource=D:\MJGross\DataBases;Extended Properties=dBase III;
And
Provider=vfpoledb.1;Data Source=D:\MJGross\DataBases;ExtendedProperties=dBASE IV;Exclusive=false;Nulls=false
...
|
by: test.file |
last post by:
We have an application that is running under Citrix. The application
files are located on a shared network drive and the app is launched via
UNC. The app contains WinForms that are called from Excel and provide
database connectivity.
Every so often, we're getting an error "External component has thrown
an error" when they try to instantiate a form. I do not have the
InnerException in the MessageBox prompts, but in another unhandled...
|
by: Tom P |
last post by:
I'm using System.Configuration in .NET 2.0 to load in values
from an externally specified config file and deserialize
them into a C# class. During deserialization, I'm getting
an exception thrown by .NET It's having a problem with
the <connections> element seen below. I've tried different things, but
still I can't get the deserialize to succeed. Here's the problem in
detail below.
Can anybody tell me what I'm doing wrong? Shouldn't...
| |
by: Big Charles |
last post by:
Hi,
We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the bandwidtht that we have
in our local office won't be enough for the number of users that access
to our web app.
But for backup issues, the database server will be in our local office.
|
by: jun |
last post by:
Friends,
I need to insert around 13000 records from a sybase external DB to one
of my local table in access. I have the connection string set up and
everything works fine except for the execution time. It takes a lot of
time to populate the local table because I have a recordset variable
which loops through the 13000 records returned from the ADODB
connection object and inserts one line after the other into the local
table. Do you...
|
by: f rom |
last post by:
----- Forwarded Message ----
From: Josiah Carlson <jcarlson@uci.edu>
To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org
Sent: Monday, December 4, 2006 10:03:28 PM
Subject: Re: 1>make_buildinfo.obj : error LNK2019: unresolved external symbol __imp__RegQueryValueExA@24 referenced in function _make_buildinfo2
Ask on python-list@python.org .
- Josiah
|
by: ouistyty |
last post by:
Hi We have a simple asp page that query LDAP attribrute.
Everithing is working fine using a native domain account. but when
using an external account we have an error 70, acces denie.
Here's some basic info on our structure.
- Domain/Forest A with Exchange
- Domain/Forest B with external accounts.
- Forest A Trus Forest B and "Vice Versa"
- asp page on a Exchange FrontEnd server on default web site (same as
|
by: Zwoker |
last post by:
Hi all,
I am accessing data from an Oracle database via a connect string.
I got into the situation where I wanted to write my SQL select statement to do a join between a local table sitting in my MS Access (2003) database, and an external Oracle table. But I realised I had no idea how to write the SQL. It appears that the whole SQL command gets passed to Oracle, not giving me any visibility to my local tables, is that correct?
I know...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |