Re: Possible to access data source not on local server?
- From: "sloan" <sloan@xxxxxxxxx>
- Date: Mon, 13 Nov 2006 14:26:13 -0500
Which database and which version are you using (trying to connect to
remotely)?
www.connectionstrings.com has some examples;
If you're using msde
then
DISABLENETWORKPROTOCOLS=0
google that.
I'm guessing you're using trusted/integrated security, and the remote
machine isn't setup to use that account.
I'd suggest creating a non windows / sql authentication account to connect
with to the remote machine
"D" <email0203@xxxxxxxxxxx> wrote in message
news:1163437240.390909.242110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello everyone
I have developed a web application using .asp to access a data
source on a different server than where my .asp files are stored. I've
tried to determine how to establish this connection ( to a SQL server )
to access the data source but I cannot. Is this possible and if
so...how? provided below is my connection string. Thank you!
<%
CONST POST = "POST"
CONST DBCONNSTRING = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial Catalog=ACC;Data
Source=\\WHTSQLNT01\BMC"
'CONST DBCONNSTRING = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=ACC;database=ACC;Data Source=(Local)"
'CONST DBCONNSTRING = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=PUBS;database=PUBS;Data Source=(Local)"
CONST APPSCOOKIENAME = "AppNumsCookie"
CONST GROUPCOOKIENAME ="GroupsCookie"
%>
.
- References:
- Prev by Date: Re: Caching file stream?
- Next by Date: Re: Path to WebResource.axd
- Previous by thread: Possible to access data source not on local server?
- Next by thread: Re: Possible to access data source not on local server?
- Index(es):
Relevant Pages
|
