aspnewbie
|
| Posted: 09/17/2002, 10:54 AM |
|
New to SQL Server and ASP.
I have my SQL Server on a box in Denver - which will also host the site. I am Developing on a box in Phoenix.
I set up an ODBC connection locally and design the site in CCS with no problem.
I set up an identical ODBC connection on the server. But when I move the outputted files to the server in Denver and I get this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Why would the exact same settings not work locally on the server but would work remotely from my client machine?
Thanks for any assitance.
|
|
|
|
Jeremy
|
| Posted: 09/17/2002, 1:59 PM |
|
The server does not have the ODBC name specified, or does not have the right driver for the DSN name. The server is misconfigured.
|
|
|
|
aspnewbie
|
| Posted: 09/17/2002, 2:38 PM |
|
what i don't know about sql server could fill up an idiot's guide.
so on the sql server side i needed to add, via odbc, a "system dsn". i was trying to add a "user dsn" because i had a working user dsn on my client machine. oops.
thanks.
|
|
|
|
|
|
