IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > System Administration > IIS
Reload this Page

Connecting to SQL Server via IIS with ASP

Discuss Connecting to SQL Server via IIS with ASP in the IIS forum on Dev Shed.
Connecting to SQL Server via IIS with ASP IIS forum discussing Microsoft's Internet Information Server including its configuration, optimization and other related topics. IIS is the most popular web server for the Windows platform.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old December 6th, 2004, 04:44 PM
jiska78 jiska78 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2004
Posts: 5 jiska78 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Connecting to SQL Server via IIS with ASP
Hey guys..

Bit of a complicated situation here - let me try and explain as best I can..

We are not using Active directory and as such do not have access to Kerberos authentication methods. What I need to do is connect to an SQL (2000) database using ASP 3.0 - I have setup an account on SQL Server with read access to two tables (and no password). Just to complicate the issue even further, the IIS server and the SQL server reside on different machines on the network.

Can anyone give me some advice on connection strings that will work within this environment as i'm not having much luck at present.

Thankyou in advance
Reply With Quote
  #2  
Old December 20th, 2004, 11:50 AM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
  
Join Date: Jun 2003
Posts: 10,714 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 1 Month 5 m
Reputation Power: 688
www.able-consulting.com has examples of nearly every connection string possible.
__________________
======
Doug G
======
"Hide, hide witch! The good folk come to burn thee. Their keen enjoyment hid behind their gothic mask of duty." -Mark Clifton
Reply With Quote
  #3  
Old December 21st, 2004, 08:27 AM
amine amine is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Posts: 26 amine User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
connecting sql data base with asp using dsn
hi friend a example to connect with asp
1 create a dsn (control pannel/admistr tools /odbc )
2 a file for connect
login.asp
<%
Set MaConn = Server.CreateObject("ADODB.Connection")
MaConn.open "dsn=base;uid=sa;pwd=;"
%> her base remind the dsn name ok
3 the you can use it in our other files by
<%
<!--#include file="login.asp" -->
%>
Reply With Quote
Reply

Viewing: Dev Shed Forums > System Administration > IIS > Connecting to SQL Server via IIS with ASP

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway.