While running through the upgrade procedure from MT 2.11 to 2.12 all went well until the last step, updating the country data.
I keep getting the following error message:
---
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
/metatraffic2/clsConfig.asp, line 1267
--
Any idea what the problem is?
Regards,
Quintus
"Update Country Data" error from Pro 2.11 to 2.12
Hi Quintas,
I have seen this error message occasionally, usually in shared hosting environments.
You may want to look at loading the data directly on the database using Enterprise Manager. If this option is available to you, here are the steps:
Right click on the database where MetaTraffic is installed in Enterprise Manager and select All Tasks > Import Data.
Here are the steps in the wizard:
- Select your data source and select text file from the drop down
- Browse for the countries.txt file, Next
- Skip rows 1, Text qualifier: , Next
- Select Other - type || in the box, Next
- Choose a destination, this should already be set to your db, Next
- In the destination column, click the drop down menu and select mt_IPCountry table, click the Transform button, make sure that col1 = ic_ipstart, col2 = ic_ipend and col3 = ic_code. Select delete rows in destination table as well. OK, next.
- Next to run immediately and then load the data.
Regards,
~Chad
"Update Country Data" error from Pro 2.11 to 2.12
Thanks, appears to have worked that way.
Regards,
Quintus