Hello,
I've been given the task of transferring a website from one server to another. Unfortunately the website was written in asp and is linked to a MS SQL database and I haven't had much experience with either. It was using a MS SQL 2000 database but the new host only has MS SQL 2005. I got a backup of the database and uploaded that to the new one and it all seemed to upload fine.
At first the website wouldn't connect but I changed the connection string to
Driver={SQL Native Client};Server=xxx.xxx.xxx.xxx, xxxx;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
It's now coming up with an error which says:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_list_map_citys'.
I haven't been able to find any useful help about this error.
Apart from the connection string is there anything else I have to change to get it to work on MS SQL 2005 or should I be looking somewere else for the problem?
Sorry if this question has been answered elsewhere but I couldn't find anything to help me.
Any help would be greatly appreciated as I have to get it working soon.
Thank you