Sage - 19.01.11.285
Windows 7 Pro, 64bit
ACCDATA is on a a shared drive on a 32bit Windows 2003 server, which is being retired.
Excel 2003 / Data / Import External Data / Import Data
New Source / ODBC DSN
Next
SageLine50v19
Next
Sage 50 2013 ODBC Connect UserID/Pwd OK
Connection(tab)
Test Connection(button)
Sage 50 2013 ODBC Connect UserID/Pwd OK
Test connection failed because of an error initialising provider.
Unspecified error.
Any advice on Sagev19 ODBC driver is very welcome and appreciated!
Thank you.
Richard.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
v19 ODBC Driver
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: v19 ODBC Driver
Sounds like it is not asking you for a path, so is using the default path and this may be wrong.
You can setup a separate DSN you can specify the path and it should work.
or
You can configure the default driver to have the correct path.
I tend to configure it/refresh it using a bit of VBA because you can avoid the ODBC dialogue and having to click ok all the time.
It also makes it a piece of cake, to change versions/paths/passwords etc.
You can setup a separate DSN you can specify the path and it should work.
or
You can configure the default driver to have the correct path.
I tend to configure it/refresh it using a bit of VBA because you can avoid the ODBC dialogue and having to click ok all the time.
It also makes it a piece of cake, to change versions/paths/passwords etc.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Amazon [Bot], Semrush [Bot] and 2 guests