469,573 Members | 1,296 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Possible to access data source not on local server?

D
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"
%>

Nov 13 '06 #1
3 2047
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" <em*******@comcast.netwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
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"
%>

Nov 13 '06 #2
The "Data Source" portion of your connection string looks like a UNC path, it
should look more like just the machine name (or ip address). e.g.,
Data Source=WHTSQLNT01
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"D" wrote:
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"
%>

Nov 13 '06 #3
D
I should've provided a few more key details - all of my pages interact
through intranet. We are not publishing any sites for internet use. It
is true that I'm using a UNC path - we've had one developer
successfully connect across servers this way, as well as using an
access dbo in the same source as the .asp files. Very redundant method
that appears to be. I will check the site that was provided in the last
post and also try your suggestions. Hopefully I can come up with some
resolution. Thank you both for your suggestions!

Nov 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
3 posts views Thread by Lyle Fairfield | last post: by
9 posts views Thread by Wayne Smith | last post: by
7 posts views Thread by D. Patrick | last post: by
5 posts views Thread by Jim | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.