Accessing extern database
-
I'm trying to make dynamic pages containing database data. My system is a WindowsXP. The database is a MS ACCESS 97 database and it's located on another computer in the network. I made the DSN targeting that database on the network. I cannot move the database on the server cause it's vital that it stays there. I exported the asp file on the database computer and I copied it on the xp server. When I load the asp file I get this error: HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Why? Can anyone help me with the procedures for connecting to an extern database ? Thank you !
-
I'm trying to make dynamic pages containing database data. My system is a WindowsXP. The database is a MS ACCESS 97 database and it's located on another computer in the network. I made the DSN targeting that database on the network. I cannot move the database on the server cause it's vital that it stays there. I exported the asp file on the database computer and I copied it on the xp server. When I load the asp file I get this error: HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Why? Can anyone help me with the procedures for connecting to an extern database ? Thank you !
BlackRider wrote: HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Why? Can anyone help me with the procedures for connecting to an extern database ? You need to make sure you are creating a SYSTEM DSN when using ASP, not a USER DSN. Also, your ConnectionString may be referencing either the application path or local path to the DSN and you need to make sure you are targeting the network path instead. HTH Nick Parker