Re: Data source name not found and no default driver specified

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Jun 5, 4:48 pm, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
rabblerow...@xxxxxxxxx wrote:
Hi, I have IIS and SQL Server2K on the same machine where I am trying
to get an ASP file to return data. I can not get past this one error
though:

ERROR MESSAGE:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/WebFiles/Page1.asp, line 122

I've messed with and tripple checked each of the areas below
-Web Site's Configuration in IIS
-Registry key associated with ODBC Driver
-ODBC driver / DSN
-Changed the connection string in every way.

CONNECTION STRING:
MyConn= "PROVIDER=SQLOLEDB.1;DATA
SOURCE=xxx.xxx.xx.xx;UID=User;PWD=pwd;Network
Library=dbmssocn;Initial
Catalog=DB Name;"

Well, this is the correct connection string to use
(http://www.aspfaq.com/show.asp?id=2126). What error do you get when you use
it?

Why is it so important to use the IP address with the sql server on the same
machine? Use (local) for the data source instead of the IP.
The connection string attributes should be user id instead of uid, and
password instead of pwd (but this is not your problem)

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"- Hide quoted text -

- Show quoted text -


Hi Bob,

OK I changed the connection string exactly as you suggested, but I
still get the same error. Any other ideas?

Thanks,

Russ

.

Relevant Pages