Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DSN vs DSN less

Author  Topic 

missinglct
Yak Posting Veteran

75 Posts

Posted - 2005-10-28 : 11:32:30
Hi everyone,

I am currently using DSN less connection to connect to my SQL server db. My db connection string looks s.t like this:

Provider=SQLOLEDB;User ID=xxx;Password=yyy;Data Source=xxx.yyy.zzz.123;Initial Catalog=db_name;"

Now, when I run my application on the INTRANET, it works fine.
But when I run on the INTERNET, I got this error message:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Does anyone have any idea why I got that "SQL Server does not exist" problem?

Thank you for any input.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-31 : 00:14:18
See if this helps you

www.connectionstrings.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -