Sage ODBC Setup

Sage ODBC Setup

Didn't find your answer?

I've set up a fair few Sage Line 50 ODBC/Excel links but this one has stumped me.

We have a Vista machine on which ODBC was fine until we recently upgraded it to Sage v17. There was no Sage ODBC driver when I tried to set up the ODBC connection.

I contacted Sage support and they showed be how to install it from an executable file in the Sage directory but, although the process seemed to execute OK, nothing appeared in the ODBC drivers.

I tried again while logged in as admin but same issue.

Any thoughts?

Cheers

Replies (6)

Please login or register to join the discussion.

avatar
By cparker87
20th Sep 2011 16:02

Hijack

Sorry to hijack your thread, but am I right in thinking the ODBC Link means you can use excel to input data into Sage?

 

Thanks (0)
Replying to User deleted:
avatar
By stevie
20th Sep 2011 16:16

ODBC link

cparker87 wrote:

Sorry to hijack your thread, but am I right in thinking the ODBC Link means you can use excel to input data into Sage?

 

 

No, the other way round, the data is extracted from Sage into Excel.

Thanks (1)
Replying to User deleted:
avatar
By ChrisDL
20th Sep 2011 16:21

Sorry but no

cparker87 wrote:

Sorry to hijack your thread, but am I right in thinking the ODBC Link means you can use excel to input data into Sage?

 

No you can't unfortunately - unless you have a developer who can write you something using SDO, you are stuck with import. ODBC is a good way of getting data out of Sage and into Excel but is a bit less used than it was since the excel add-in was introduced.

 

Coming back to the OP's issue - is excel showing the the V16 or earlier driver? You might try using that instead of the one you just installed.

Thanks (1)
avatar
By stevie
20th Sep 2011 19:08

v16

No Sage drivers showing at all - just SQL.

Thanks (1)
avatar
By ChrisDL
21st Sep 2011 07:37

Try the ODBC Data Source Administrator

The only other thing I can think of is that you might need to do some more configuration if you have done a manual install - try running the ODBC Data Source Administrator (either from control panel or odbcad32.exe) and see if the driver is listed and what options you can set

Thanks (1)
avatar
By stevie
22nd Sep 2011 14:09

Solved it!

The OS was actually Win 7 and there are 2 versions of ODBC administrator. One is in the sys32 directory and the other in syswow64 directory. When I ran the latter the drivers were present. Got the solution from a google search:

the ODBC Administration you need to use is the 64 bit version. The 32 bit version that you are probably using does not know how to connect you to your database (which is why you are not seeing the driver in the -32 bit- list). Navigate to C:\Windows\SysWOW64\odbcad32.exe . Use that and your driver should pop up when trying to create a System DSN. (I pulled my hair out for a few hours looking for this answer - I hope it's what you needed).

 

Thanks (2)