Sql2000 to SqlExpress
Posted on 2007-10-12
I have a Sql2000 database which I put onto a SqlExpress server. The way I did this was to take the PosServer.bak and restore it into the SqlExpress server.
My program which is access2000 had problem with the new database which I fixed by removing relationships from the database and creating them again.
Another program which looks at the same data is now having trouble saving data to the database although it connects and reads data no problem.
The following code:
Dim RsNewDlv As ADODB.Recordset
Set RsNewDlv = New ADODB.Recordset
RsNewDlv.Open "Select top 1 * From DeliveryHead", CnnPosServer, adOpenKeyset, adLockOptimistic, adCmdText
RsNewDlv!DeliveryNo = gblDeliveryNo
RsNewDlv!GrnCreated = False
Gives this error
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'QLIKVIEW\SQLEXPRESS' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
this is the connection string.
What might be the cause of this. I don't understand why I should have to add it as a linked server because it is not and I tried it anyway and different errors came up.