Dana Reed
|
| Posted: 05/13/2003, 8:32 AM |
|
I can connect to my SQL Sever 2k just fine, but it seems as when the ASP
page is running it times out trying to connect to the database and the page
never shows up.
I've tried several different ODBC connections without any luck. I made sure
IUSR and IWAM have write access to both the data directory as well as the
MDB.
What do I need to do? I'm able to develop/publish, etc but the pages will
not execute.
IIS 5 platform.
Dana
|
|
|
 |
DonB
|
| Posted: 05/13/2003, 1:17 PM |
|
Sounds like the datasource is invalid in the context of the IIS machine.
Are you using "Microsoft Jet OLEDB 4.0" as the driver (connectino string) or
a "ODBC Datasource name"? If the latter, is the datasource defined on the
server? Is your project set up to use the sames datasource for development
and for the server?
If using a DSN (that is, a datasource defined in the ODBC manager via the
Control Panel), you might have left the database type as "SQL Server" even
though you think you set it up for Access. Usually an Access connection
won't "time out" because the file can either be opened or it can't (no
waiting).
WIth SQL Server, the server machine might not be available and the driver
will wait 30 seconds or so before it gives up - at which point a time out is
reported. You likely have the wrong driver selected
Can you post the actual connection info (as shown in Common.asp in the class
definition "Class clsDB<your connection namer>". Besure to leave out the
password if one appears there.
DonB
"Dana Reed" <onlyzuul@pacbell.net> wrote in message
news:b9r36b$oeu$1@news.codecharge.com...
> I can connect to my SQL Sever 2k just fine, but it seems as when the ASP
> page is running it times out trying to connect to the database and the
page
> never shows up.
>
> I've tried several different ODBC connections without any luck. I made
sure
> IUSR and IWAM have write access to both the data directory as well as the
> MDB.
>
> What do I need to do? I'm able to develop/publish, etc but the pages will
> not execute.
>
> IIS 5 platform.
>
> Dana
>
>
|
|
|
|
Pepito
|
| Posted: 05/14/2003, 11:32 PM |
|
Using Norton Antivirus maybe?? disable script blocking....
"Dana Reed" <onlyzuul@pacbell.net> wrote in message
news:b9r36b$oeu$1@news.codecharge.com...
> I can connect to my SQL Sever 2k just fine, but it seems as when the ASP
> page is running it times out trying to connect to the database and the
page
> never shows up.
>
> I've tried several different ODBC connections without any luck. I made
sure
> IUSR and IWAM have write access to both the data directory as well as the
> MDB.
>
> What do I need to do? I'm able to develop/publish, etc but the pages will
> not execute.
>
> IIS 5 platform.
>
> Dana
>
>
|
|
|
|
Sandro
|
| Posted: 05/16/2003, 4:06 AM |
|
Put the .mdb OUTSIDE the site folder (not in a subdirectory).
"Dana Reed" <onlyzuul@pacbell.net> ha scritto nel messaggio
news:b9r36b$oeu$1@news.codecharge.com...
> I can connect to my SQL Sever 2k just fine, but it seems as when the ASP
> page is running it times out trying to connect to the database and the
page
> never shows up.
>
> I've tried several different ODBC connections without any luck. I made
sure
> IUSR and IWAM have write access to both the data directory as well as the
> MDB.
>
> What do I need to do? I'm able to develop/publish, etc but the pages will
> not execute.
>
> IIS 5 platform.
>
> Dana
>
>
|
|
|
|
Sandro
|
| Posted: 05/16/2003, 4:10 AM |
|
Put the .mdb OUTSIDE the site folder (not in a subdirectory). Connect with
ADO.
"Dana Reed" <onlyzuul@pacbell.net> ha scritto nel messaggio
news:b9r36b$oeu$1@news.codecharge.com...
> I can connect to my SQL Sever 2k just fine, but it seems as when the ASP
> page is running it times out trying to connect to the database and the
page
> never shows up.
>
> I've tried several different ODBC connections without any luck. I made
sure
> IUSR and IWAM have write access to both the data directory as well as the
> MDB.
>
> What do I need to do? I'm able to develop/publish, etc but the pages will
> not execute.
>
> IIS 5 platform.
>
> Dana
>
>
|
|
|
|
|
