I tried connecting with DSN from both a classic ASP page using VBScript, and from a .NET web service using C#, both give an error "Invalid object name 'xxx'" where 'xxx' is the name of the table I specify in my query. Since I'm just using a DSN, my connection string is fairly simple:
Expand|Select|Wrap|Line Numbers
- "DSN=myDSN;Uid=myUID;pwd=myPWD"
But that might not be the whole problem, I was installing a program that uses a SQL db, and installation threw this error
Expand|Select|Wrap|Line Numbers
- [dbnetlib][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I'm using MS SQL Server 2005 Express, and management Studio Express.
Jared