"Do I need to create a new Data Source using the 32-bits driver?"
Yes. ESS uses the 64-bit drivers, but ODBC import uses the 32-bit drivers. So you need a DSN based on the 32-bit drivers in order to do the ODBC import server-side.
Thanks for the info.
I have created a new System DNS on the FMS with the 32-bit driver. I named it 'isams32'.
However, the new DNS does not appear as an option in the Import Record [ODBC] > Select ODBC Data Source.
The highlighted DNS "isams" is the existing data source that I mentioned. It works when I run the script with the client machine but not on the server.
And I realise that the current options are the DNS on my local PC instead of the server.
I hosted and developed the file remotely on the server.
You won't see "isams32" because you set it up on the FMS machine. The dialog box you show, is on your local PC. You are editing the script on your PC, so it knows nothing about things setup on the FM Server.
In your case, it sounds like you should be good if you just rename the DSN on the FM Server to be "isams". Read on for a bit more detail.
FM server machine
Setup a 32bit DSN entry using the 32bit ODBC Administrator. Make sure that the DSN is created in the "System" tab. It sounds like you have done this.
FM Client Machine(s)
Setup a 32bit DSN in the System tab of the ODBC Administrator. Name it EXACTLY the same as what you have on the FM Server. Note: I have not tried this, but I am fairly confident that if you setup the DSN on the client PC using the 64bit ODBC Admin app, it will not make a difference when it comes to running on the FM server. The key that I am aware of is naming things the same.
When you are setting up your scripting on your PC, you choose the DSN for your import like you have shown in your screenshot.
When the script runs on the FM Server, it will see a DSN that is named the same and off it goes...
Give this a try and let us know how it goes. This is definitely doable because I have a couple of clients where this has been working for quite some time now.
You are my saviour !!!
It is working.