Results 1 to 1 of 1
Thread: problem with mssql express 2005
Mar 31, 2009, 04:10 #1
- Join Date
- Aug 2004
- 0 Post(s)
- 0 Thread(s)
problem with mssql express 2005
I have a site built on asp and mssql express. All worked smoothly localy until the day I changed form xp to vista. I put again mssql and connect fine but when the script asks via ADO to add or update a record this error comes up:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'NAME\SQLEXPRESS' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
I am not good at databases. Any help would be appriciated I am desperate