romax
Posts: 5
|
| Posted: 09/17/2004, 1:25 PM |
|
I keep getting an error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I can test the connection and it works but it keeps failing when I try to access the page.
Any ideas why this does not work?
|
 |
 |
peterr
Posts: 5971
|
| Posted: 09/17/2004, 3:37 PM |
|
Here are the answers:
http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=%22Da...3Amicrosoft.com
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonB
|
| Posted: 09/18/2004, 8:58 AM |
|
By "access the page" you probably mean the "published" page, thus it resides
on the webserver not your local workstation (which is where the "test"
executes).
The datasource must be set up in both places, with permissions granted
appropriately. Remember, the webserver runs under a different user id than
the one you logged in when you created the application. So even if both
locations are the same machine, the datasource may fail to work unless you
grant access to the database.
Another common mistake is to create a "user" datasource instead of a
"system" datasource. The user datasource will only be visible to you, not
the web server account.
I always create "connection string" datasources, never the "DSN" style, I
find it less confusing.
--
DonB
http://www.gotodon.com/ccbth
"romax" <romax@forum.codecharge> wrote in message
news:6414b4848392cd@news.codecharge.com...
> I keep getting an error:
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
> I can test the connection and it works but it keeps failing when I try to
> access the page.
>
>
> Any ideas why this does not work?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
