Click here to Skip to main content
15,891,136 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Webservices and Custom Type Objects Pin
Heath Stewart22-Nov-03 5:11
protectorHeath Stewart22-Nov-03 5:11 
GeneralRe: Webservices and Custom Type Objects Pin
JoostV23-Nov-03 1:11
JoostV23-Nov-03 1:11 
GeneralRe: Webservices and Custom Type Objects Pin
Heath Stewart24-Nov-03 4:19
protectorHeath Stewart24-Nov-03 4:19 
GeneralCSS Help Needed - Clickable Table Cell Pin
BrianReeve21-Nov-03 9:11
BrianReeve21-Nov-03 9:11 
GeneralRe: CSS Help Needed - Clickable Table Cell Pin
Ian Darling21-Nov-03 9:33
Ian Darling21-Nov-03 9:33 
GeneralRe: CSS Help Needed - Clickable Table Cell Pin
Roger Wright21-Nov-03 9:37
professionalRoger Wright21-Nov-03 9:37 
GeneralRe: CSS Help Needed - Clickable Table Cell Pin
Rohit  Sinha21-Nov-03 10:42
Rohit  Sinha21-Nov-03 10:42 
GeneralHelp! Connection String Pin
CillyMe21-Nov-03 3:02
CillyMe21-Nov-03 3:02 
It's been awhile since I pressed the panic button. But I'm have trouble connecting to my SQL server from my classical ASP application. Here's the error:

Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
/SomeDevFolder/login.asp, line 69

If you print the connection string to screen:
"Connection string: Provider=sqloledb; Data Source='XXX.XXX.XXX.XXX'; Initial Catalog='MyDatabase'; User ID='sa'; Password='secret'"

1. I want to emphasize that the ASP script works fine with one SQL server and not with another.
2. The SQL server I'm having trouble to connect to is the default instance.
3. Yes, I have checked and double checked: The SQL server is in "Mixed Mode" (authentication) - I have no idea what it has to do with trusted connection or not. I have supplied both username/password. What more do they want from me?
4. I used Query Analyzer to connect to the SQL server I'm having trouble with - using same connection string (user name and password) - it worked fine.

I doubt if it's has to do with my ASP code since connection to another server works, but, here's the code anyway:
oConn.ConnectionString = "Provider=sqloledb; Data Source='" & Application.Contents("sDbSource") & "'; Initial Catalog='" & Application.Contents("sDbInitialCatalog") & "'; User ID='" & Application.Contents("sDbUser") & "'; Password='" & Application.Contents("sDbPassword") & "'"

oConn.Open

Help!


GeneralRe: Help! Connection String Pin
Terry O'Nolley23-Nov-03 18:11
Terry O'Nolley23-Nov-03 18:11 
GeneralRe: Help! Connection String Pin
Populate1233-Dec-03 22:29
Populate1233-Dec-03 22:29 
GeneralUnable to browse asp.net code Pin
okoji Cyril20-Nov-03 21:00
okoji Cyril20-Nov-03 21:00 
GeneralRe: Unable to browse asp.net code Pin
Paul Watson20-Nov-03 21:25
sitebuilderPaul Watson20-Nov-03 21:25 
Generalidiot question... Pin
l a u r e n20-Nov-03 8:36
l a u r e n20-Nov-03 8:36 
GeneralRe: idiot question... Pin
allia20-Nov-03 8:56
allia20-Nov-03 8:56 
GeneralRe: idiot question... Pin
l a u r e n20-Nov-03 9:04
l a u r e n20-Nov-03 9:04 
GeneralRe: idiot question... Pin
l a u r e n20-Nov-03 9:29
l a u r e n20-Nov-03 9:29 
GeneralRe: idiot question... Pin
allia20-Nov-03 10:21
allia20-Nov-03 10:21 
GeneralResizeable iframe Pin
Jim Taylor20-Nov-03 8:25
Jim Taylor20-Nov-03 8:25 
GeneralRe: Resizeable iframe Pin
allia20-Nov-03 8:51
allia20-Nov-03 8:51 
GeneralRe: Resizeable iframe Pin
Jim Taylor20-Nov-03 11:56
Jim Taylor20-Nov-03 11:56 
GeneralRe: Resizeable iframe Pin
Tomas Petricek20-Nov-03 10:58
Tomas Petricek20-Nov-03 10:58 
GeneralRe: Resizeable iframe Pin
Jim Taylor20-Nov-03 12:04
Jim Taylor20-Nov-03 12:04 
GeneralRegistration, Authentication, Cookies Pin
allia20-Nov-03 4:21
allia20-Nov-03 4:21 
GeneralStill Hanging... Pin
allia21-Nov-03 13:28
allia21-Nov-03 13:28 
GeneralRe: Still Hanging... Pin
alex.barylski23-Nov-03 18:55
alex.barylski23-Nov-03 18:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.