jkvandalen
asked on
Vista & IIS problem connecting to Databases
IIS is working, ASP & PHP also.
When trying to connect to database from both PHP & ASP test code, I keep getting
Database error:
PHP:
Cannot connect ot Database: [Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database server
ODBC Error
Session halted.
ASP:
Unable to establish connection to database.
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database server
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection settings or insufficient security set on your database folder or file.
For more details please refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
I tried applying the fixes recomended on this link (http://blogs.iis.net/bills/archive/2006/10/18/loadUserProfile-and-IIS7-_2D00_-understanding-temporary-directory-failures.aspx) but still does not work.
All these test run fine in IIS 6 & XP
When trying to connect to database from both PHP & ASP test code, I keep getting
Database error:
PHP:
Cannot connect ot Database: [Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database server
ODBC Error
Session halted.
ASP:
Unable to establish connection to database.
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database server
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection settings or insufficient security set on your database folder or file.
For more details please refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
I tried applying the fixes recomended on this link (http://blogs.iis.net/bills/archive/2006/10/18/loadUserProfile-and-IIS7-_2D00_-understanding-temporary-directory-failures.aspx) but still does not work.
All these test run fine in IIS 6 & XP
use apache and mysql, it makes it easier.
finaly point, dont use vista. I hate it with a passion and will not recommend it to anyone. A very unfinished package if i may say so.
finaly point, dont use vista. I hate it with a passion and will not recommend it to anyone. A very unfinished package if i may say so.
ASKER
I'm considering going back to XP ...
I need suppor for both ASP & ASP.Net and apache does not support it as far as I know (can't use Mono)
I need suppor for both ASP & ASP.Net and apache does not support it as far as I know (can't use Mono)
ASKER
Bugs ... that is the same link I mention.
Not working in my case even with impersonation.
I'm considering spending the $300 with MS just to find a solution :(
Not working in my case even with impersonation.
I'm considering spending the $300 with MS just to find a solution :(
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No 64bit.
At this time, I'm almost ready to go to XP but ... will be nice to find a solution in view that it seems to be a problem that is messing up with a lot of developers.
BTW, if I use Cassinni, everything works ... (ASP.Net)
At this time, I'm almost ready to go to XP but ... will be nice to find a solution in view that it seems to be a problem that is messing up with a lot of developers.
BTW, if I use Cassinni, everything works ... (ASP.Net)
why do you need to use IIS?
I doubt you will find a solution. As usuall, Microsoft deemed it would be a grand idea to release a new Windows version full of holes and bugs.
http://uk.youtube.com/watch?v=O2GyGv-RqFM&NR=1
heres a link to cheer ya'll up
heres a link to cheer ya'll up
awesome....absolutley awesome! LOL
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I went back to XP ...
im considering starting up a comment thread for xp vs vista and counting up the number of people who are for vista and the number who are for xp. would anyone here who commented be interested to take part if i did?
sure
I guess even @kevp75 should be given a share of points as he too recommended XP in ID: 19669512
I suspect you are seeing a variant of this:
http://blogs.iis.net/bills/archive/2006/10/18/loadUserProfile-and-IIS7-_2D00_-understanding-temporary-directory-failures.aspx
It really illustrates a hidden weakness within the database being used. Also turn on ASP.Net impersonation and set it to your own user/password.