with Windows 7 becoming standard across, naturally there are issues cropping up everywhere after migration. people are clueless as to what would be the effect of the new system update on their processes and systems- atleast i was.
we faced issues with ODBC drivers for the database connections [for MySql and Vertica databases]. i really had to struggly to 'find' out which was the right ODBC right ODBC connection string to use. this issue was compounded because the Office 2010 does not support Jet Database Engine .
to start with, there are couple of scenarios to consider:
1. a 64 bit Windows OS with 64 bit Application [MS Office]
2.a 64 bit Windows OS with 32 bit Application [MS Office]
right now we are using the scenario 2. after much of trial and error , and searching around online [inlcuding MS Knowledg Base] i could finally get the below combination of connection string working:
most of this confusion can be avoided, if the system admin makes efforts to inform all the stakeholders of the correct system updates and most importantly if Microsoft can udpate its Knowledge Base with the correct and un-ambigous information about the dropping support to old technologies and alternatives offered.
we faced issues with ODBC drivers for the database connections [for MySql and Vertica databases]. i really had to struggly to 'find' out which was the right ODBC right ODBC connection string to use. this issue was compounded because the Office 2010 does not support Jet Database Engine .
to start with, there are couple of scenarios to consider:
1. a 64 bit Windows OS with 64 bit Application [MS Office]
2.a 64 bit Windows OS with 32 bit Application [MS Office]
right now we are using the scenario 2. after much of trial and error , and searching around online [inlcuding MS Knowledg Base] i could finally get the below combination of connection string working:
| Old | New | |
| Vertica | Vertica ODBC Driver 4.1 | Vertica ODBC Driver 4.0 |
| MySql | MySQL ODBC 5.1 Driver | MySQL ODBC 5.2w Driver or MySQL ODBC 5.2a Driver [supposed to be 'newer'] |
most of this confusion can be avoided, if the system admin makes efforts to inform all the stakeholders of the correct system updates and most importantly if Microsoft can udpate its Knowledge Base with the correct and un-ambigous information about the dropping support to old technologies and alternatives offered.
No comments:
Post a Comment