Currently having a small problem with my new implementation of MAS ...
We have just upgraded our implementation of MAS to a new server ... running Windows Server 2003 R2 (32bit) which runs fine ... We have a datamart running SQL 2000 which pulls data from MAS via the Providex ODBC driver .
I took the oppurtunity to upgrade my SQL server as well , to SQL 2005 64bit running on Windows Server 2003 R2 64 bit ... of course it is only now that i have thought of the providex driver ....
Has anyone been succesfull in implementing the Providex ODBC driver on a 64 bit system ? if so how ? this could greatly help me ....
At the moment the solution i am using is to run my ETLs on another server which is 32bit . however the ETLs are transferring data between MAS , and the SQL 2005 instance on the 64 bit server.
Any help would be very much appreciated.
Thanks.
Steven Yvinec-Kruyk
Ubisoft Canada
We have just upgraded our implementation of MAS to a new server ... running Windows Server 2003 R2 (32bit) which runs fine ... We have a datamart running SQL 2000 which pulls data from MAS via the Providex ODBC driver .
I took the oppurtunity to upgrade my SQL server as well , to SQL 2005 64bit running on Windows Server 2003 R2 64 bit ... of course it is only now that i have thought of the providex driver ....
Has anyone been succesfull in implementing the Providex ODBC driver on a 64 bit system ? if so how ? this could greatly help me ....
At the moment the solution i am using is to run my ETLs on another server which is 32bit . however the ETLs are transferring data between MAS , and the SQL 2005 instance on the 64 bit server.
Any help would be very much appreciated.
Thanks.
Steven Yvinec-Kruyk
Ubisoft Canada