nemanja-vozdova
07-27-2006, 05:19 AM
I have a huge problem with trying to connect MS Access 2003 database with Dreamweaver using ODBC.
When testing DSN connection in Dreamweaver instead of message:
Connection was made successfuly
it gives this message:
[Microsoft] [ODBC Access Driver] Disk or network error
[Microsoft] [ODBC Access Driver] Driver's SQL ConnectAttr failed
or, somtimes connection test goes well, but cannot see any of the tables in the database
Things I've done and are not making this problem:
1. Formated HDD and made fresh instalation of XP (SP2)
2. Installed IIS
3. Installed .NET ramework 2.0
4. Set the Access database security level to low
5. Set the Local internet security level to lowest enabling everything but popup blocker in advanced settings
When testing DSN connection in Dreamweaver instead of message:
Connection was made successfuly
it gives this message:
[Microsoft] [ODBC Access Driver] Disk or network error
[Microsoft] [ODBC Access Driver] Driver's SQL ConnectAttr failed
or, somtimes connection test goes well, but cannot see any of the tables in the database
Things I've done and are not making this problem:
1. Formated HDD and made fresh instalation of XP (SP2)
2. Installed IIS
3. Installed .NET ramework 2.0
4. Set the Access database security level to low
5. Set the Local internet security level to lowest enabling everything but popup blocker in advanced settings