[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior
that the application requested (see SQLSetEnvAttr)."
At the line where i open database connection i received the following error
Sub Page_Load
Dim conn As OdbcConnection
Dim comm As OdbcCommand
Dim dr As OdbcDataReader
Dim connectionString As String
Dim sql As String
connectionString
= "DSN=sageline50;uid=manager;pwd=test;"
sql = "SELECT * FROM Company"
conn = New OdbcConnection(connectionString)
conn.Open()
comm = New OdbcCommand(sql, conn)
dr = comm.ExecuteReader()
I have connected Sage L 50 multi company to Excel by 'Data - Import' in excel and its working fine. The problem is i have 2 companies on my sage but for some obscure reason Excel would pick up data from one location in Sage folder in program files. I am
not sure is there anything to do with ODBC driver/ file dsn in Administrative tools in control panel.
It would be great help if anyone culd let me know, how culd i access data for specific company in sage (multi company) from excel.
You need to set up an ODBC connection from control panel for each company, each company will be stored in a separate "accdata" folder. If you set up a new ODBC connection from control panel using the Sage driver then there will be a "Data Path" parameter
associated with the connection you put the path to the "accdata" folder here.
is their a way to write to sage ( create invoices etc) from external systems without buying the sage data objects system £1500 ! i read about a company who use SOAP xml to write to sage
shieldguy
Member
25 Points
7 Posts
How to connet to sage Line 50
Aug 07, 2006 01:56 PM|LINK
Hi am developing a web site which required to connect to the sage Line 50 and get the order information. I am using Asp.Net and sql serer 2005.
I dont know is there is a way to connect to the sage Line 50 database.
I really appriciate a help on this problem, thanks
Regards
AJ Kiven
jeff@zina.co...
All-Star
87677 Points
11637 Posts
Moderator
Re: How to connet to sage Line 50
Aug 11, 2006 01:23 PM|LINK
You might try connectionstrings.com for examples of using the ODBC connection.
Jeff
shieldguy
Member
25 Points
7 Posts
ASP.NET and sage L 50 communication
Aug 11, 2006 01:25 PM|LINK
I am currently trying to access the sage Line 50 through ODBC driver provided by the sage,
I am using ASP.NET but i getting the following error
"System.Data.Odbc.OdbcException: ERROR [08001] Cannot find all files in data path ERROR
[01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00 ERROR
[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000]
[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior
that the application requested (see SQLSetEnvAttr)."
At the line where i open database connection i received the following error
Sub Page_Load
Dim conn As OdbcConnection
Dim comm As OdbcCommand
Dim dr As OdbcDataReader
Dim connectionString As String
Dim sql As String
connectionString
= "DSN=sageline50;uid=manager;pwd=test;"
sql = "SELECT * FROM Company"
conn = New OdbcConnection(connectionString)
conn.Open()
comm = New OdbcCommand(sql, conn)
dr = comm.ExecuteReader()
customers.DataSource=dr
customers.DataBind()
dr.Close()
conn.Close()
End Sub
I had checked my connection string and its working fine
I really appriciate any help on this problem
Thanks
PeterChen
Member
5 Points
1 Post
Re: ASP.NET and sage L 50 communication
Aug 31, 2006 12:58 AM|LINK
1. You should use Sage ODBC driver to link to Sage Line 50;
2. Sage ODBC driver is read only, you can not write data back to Sage Data file;
3. Not all data you can get from Sage ODBC driver.
Good luck.
Jbrown
Member
10 Points
2 Posts
Connecting Sage L 50 (multi company) to excel
Sep 09, 2006 11:43 AM|LINK
I have connected Sage L 50 multi company to Excel by 'Data - Import' in excel and its working fine. The problem is i have 2 companies on my sage but for some obscure reason Excel would pick up data from one location in Sage folder in program files. I am not sure is there anything to do with ODBC driver/ file dsn in Administrative tools in control panel.
It would be great help if anyone culd let me know, how culd i access data for specific company in sage (multi company) from excel.
Thanks
blueju
Member
5 Points
1 Post
Re: Connecting Sage L 50 (multi company) to excel
Sep 15, 2006 01:18 PM|LINK
Hi,
You need to set up an ODBC connection from control panel for each company, each company will be stored in a separate "accdata" folder. If you set up a new ODBC connection from control panel using the Sage driver then there will be a "Data Path" parameter associated with the connection you put the path to the "accdata" folder here.
Cheers
Jbrown
Member
10 Points
2 Posts
Re: Connecting Sage L 50 (multi company) to excel
Sep 19, 2006 10:58 AM|LINK
Thanks alot! i figured it out as there is ACCDATA folder for each Company or COMPANY folder within SAGE folder.
Thanks again.
tommydog
Member
5 Points
1 Post
Re: Connecting Sage L 50 (multi company) to excel
Oct 12, 2006 09:57 PM|LINK
PeterYu
Member
10 Points
2 Posts
Re: How to connet to sage Line 50
Nov 14, 2006 11:46 PM|LINK
Sage Line50 does not support connect to external application including Web server.
We have developed solution to link Line 50 to Web server, which you can use to your web page.
www.ex4e.co.uk
danadanny
Member
22 Points
55 Posts
Re: ASP.NET and sage L 50 communication
Mar 20, 2007 10:49 AM|LINK
How can I get the Sage ODBC driver? Also, can the same driver be used for Sage Payroll?
Any advise is deeply appreciated.
Thank you.
Danny.