|
I would like to use Microsoft SQL Server 2005 Express Edition for my site. But I seem to be having trouble configuring it to work. I keep getting the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.
|
|
|
While Microsoft SQL Server 2005 Express Edition is a fully functional free version of Microsoft SQL Server, it does have some unique characteristics. One of the most significant, which is the cause of the error message shown above, is that the Express Edition installs as a named instance of SQL Server. This requires that the database connection that you configure in the software must be sure to include the named instance of SQL Server. You do this by appending a slash with the instance name after the name or IP address of your SQL Server in the connection string. For example, if your connection string looked like this:
Driver=SQL Server;Server=localhost;UID=login;PWD=password;Database=dbname
You would alter it so that it instead looks like this for SQL Server 2005 Express Edition:
Driver=SQL Server;Server=localhost\SQLEXPRESS;UID=login;PWD=password;Database=dbname
|
