Sage 100

What is everyone's experience with the new 64 bit ODBC for Sage 100? I need to set up a linked server in a 64 bit SQL environment. Has anyone done this? Any issues to worry about?

Everything I was going to need it for is already reloaded the 32bit version.

I'm in the same boat @JimWoodhead . Any luck with the linked server in 64-bit SQL?

No not yet. We ate toying with taking client to SQL. We have SQL mirroring installed so that adds an additional twist.

If I install the 64-bit driver, it doesn't overwrite or remove the good old 32-bit SOTAMAS90 DSN does it?

It might

We are still testing

I know, I'll have to test it. The more i think about it, it doesn't really matter. I need it on the SQL server not on my TS or workstations. Thanks for letting me talk it out.

Well...Date fields are causing me some grief. But other than that using the 64-bit odbc driver to create a Sage 100 linked server is working like a charm.

I heard there is an issue with doing linked servers and Sage is aware of it.

Haven't used the 64-bit ODBC yet but dates have always caused me grief on Linked Servers that using SQL Express edition. I always have to convert them in the SELECT as in SELECT Convert(Varchar(10),InvoiceDate, 101) as InvDate as opposed to just: SELECT InvoiceDate Hope that's relevant.

Thanks @AlnoorCassim, yes it's relevant.

@JohnnyPabian do you know what the issue with linked server is?

@JohnLeonard - I am not sure - I happened to be at Sage Irvine in support and was talking with some of the staff and they said there was an issue. The sadder part is support really had no idea how to setup a linked server with MAS90 so I gave them some steps to do. So there really may not be an issue. I have some ugrades coming up that will shed the light. I can probably test today if the 64 bit odbc works to 64-bit for example - I will post that later.

It works. I got one working using the 64-bit driver at a client just this morning. There may be issues here and there but you can definitely access the tables and the data.

I did not do with a linked server but I could pull data into a 64-bit excel from a ver 5.0 install but i could not pull data from a 4.4 install for some reason - kept saying logon failed. Testing a silent dsn still resulted in login failed not tables returned for a 5.0 install. seems a little unstable.