wrote:
> rabblerow...@yahoo.com 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 -

rabblerowzer@yahoo.com 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;"
>

rabblerowzer@yahoo.com wrote:
> On Jun 5, 4:48 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
> wrote:
>> rabblerow...@yahoo.com 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)
>>

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