Skip to main content
Inspiring
June 9, 2006
Question

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)?

  • June 9, 2006
  • 12 replies
  • 1483 views
I got a local version of SQL2000 and I can connect using Dreamweaver and I
can see data when testing the recordset but when I view the page, I get the
standard error

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not
found.
/orderhistory.asp, line 19

Any clue what is causing this error and how to solve it?

I know the 80004005 error is the "I can't find the database" error but I
wonder, since I can see the data in dreamweaver, why it's not appearing when
the page is view.

Thanks for the help.


This topic has been closed for replies.

12 replies

Inspiring
June 14, 2006
Check to see that your server is (local) when you connect.
It's okay to change the user you're logging in as. If you log in as a user
without permission to see certain databases, then they won't show up. When
in doubt, do a test logging in as the sa account to eliminate any
permissions issues. If that works, then start working from there - what
does your normal login need to access? Does it have that access? Does it
use SQL Server authentication or Windows authentication?

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6p4gs$nsf$1@forums.macromedia.com...
> I've actually gone backwards with this issue. When I wrote before, I could
> actually connect through Dreamweaver and see the database through
> Dreamweaver; I couldn't view the page in a browser but now it is totally
> trashed and I can't even get Enterprise Manager to to Register SQL Server
> . I get an error..."SQL Server does not exist or access denied
> []ConectionOpen"
>


Inspiring
June 14, 2006
You should probably check out the forum for Enterprise manager and see if
anybody can help you resolve your issues through that. Lion migh thave some
other suggestions.
"lee" <lfairban_nospam@amep.com> wrote in message
news:e6p9kv$19i$1@forums.macromedia.com...
>I have .NET installed. Are there issues with this that would cause my
>problems here?>
>


Inspiring
June 14, 2006
I have .NET installed. Are there issues with this that would cause my
problems here?>


Inspiring
June 14, 2006
Now It changed from computername\Local... that had all my test databases to
computername\MicrosoftBCM

Not sure where or how to change that back. Can't find where to change it.

Not sure how it did that. I'm guessing the microsoftbcm is a default. it
contains "master" northwoods and the other databases that come by default.



Inspiring
June 14, 2006
I've actually gone backwards with this issue. When I wrote before, I could
actually connect through Dreamweaver and see the database through
Dreamweaver; I couldn't view the page in a browser but now it is totally
trashed and I can't even get Enterprise Manager to to Register SQL Server .
I get an error..."SQL Server does not exist or access denied
[]ConectionOpen"


Inspiring
June 14, 2006
system DSN


Inspiring
June 14, 2006
You still have a connection string.
Did you set up a system DSN, user DSN, or file DSN?

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6n9a6$dcq$1@forums.macromedia.com...
> for my local I'm just using an ODBC so I don't have a connection string
>


Inspiring
June 13, 2006
for my local I'm just using an ODBC so I don't have a connection string


Inspiring
June 13, 2006
Your connection string? (please redact any usernames or passwords)

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6n51l$8b8$1@forums.macromedia.com...
> Anyone else?
>


Inspiring
June 13, 2006
Anyone else?