Sage Odbc Connection String

You can also make a connection to a database by passing a connection string via a Command or Recordset object. Si tu as 10 postes qui se connectent à ta base par ODBC, il faut installer le driver ODBC sur chacun des 10 postes (et donc, me semble-t-il avoir 10 licences odbc). Driver: Specify the driver as MySQL ODBC 3. In my previous article "Connecting to an External ODBC database e. This is the connection string that Power Query accepts to connect you to the Pervasive database. The quickest way for you to gain access to the connection strings is to look into the DSN for the standard MAS ODBC. Thus far in this tips series on Access and SQL Server we have created an ODBC Data Source Name (DSN) using the OLEDB driver, created a System DSN for the new SNAC (SQL Native Client) driver and created linked tables in Access by using the SNAC DSN. credentials hard-coded in the ODBC connection string. SAP Analytics 28,960 views. How i figured it out?? Thank to the follow sql query: USE MASTER GO xp_readerrorlog 0, 1, N'Server is listening on' GO. How can I connect and fetch data from a Sage 200 database through a ODBC connection using C#? I have no code to show because I'm stuck even with the connection string part. Advanced Options. Can you use a 32 bit odbc driver on bit OS let’s oraclient10g home1 odbc Oarclient10g 32 to access a bit Oracle db. You will see a screen like the one below, requesting your ODBC details:. Choose second option (Shared database server) if you manually created database on sql server. Databases Sage ODBC - invalid username and password Hi,I have an ASP that talks to the Sage Line 50 ODBC drivers. Download & install PostgresQL ODBC driver. Edit the SQL statement (New SQL Statement) that will be executed for newly received submissions. ) TableName. ; Under From Other Sources open From Microsoft Query. Driver={Pervasive ODBC Client Interface}; DSN=CSM Prerequisites: The workstation has the required ODBC data source configured. Databases are great for storing information, but sometimes you want to use or analyze that data in Excel. Similarly, 64-bit Excel will only list data sources using 64-bit drivers. The Sage 50 UK ODBC Driver is a powerful tool that allows you to connect with live data from Sage 50 UK, directly from any applications that support ODBC connectivity. J'ai essayé à maintes reprise de réparer ma base avec l'outil de maintemance fournit avec sage, rien à faire. Also I was using I rewrote the connection string in my web. 1 Chapter 3, “Installing FileMaker ODBC client drivers,” explains how to install the driver files needed for accessing a FileMaker data source using ODBC. Wayne Schulz is a Sage 100 Consultant located in Connecticut. In my case the sin in question is still using the bde and odbc. These parameters can only be set in the Windows registry using regedit. Sage Socket Connection Failed Error Code 10061 The most common causes of socket error 10013 are a firewall or anti-virus Socket errors occur for a variety of reasons. Select the "MAS 90 4. Create an ODBC connection to Sage Intacct in Informatica and browse and transfer Sage Intacct data. Connection String for Win10; Pervasive connection with MVC ASP. INI\ODBC Drivers. Introduction. If you open the ODBC connection that points to MAS90, it allows you to specify a default company, userID and password. config file and now my application works. NET Tutorial on Code Examples - Microsoft SQL Server. Accounts, Budget, Campaign etc). It contains the following topics: "Connecting to Excel Spreadsheets Through ODBC" "Connecting to SQL Server Database Through ODBC". I can read the data using the same connection string in a VBScript using ADODB. Connection String Examples. Here is an example of the connect string generated by my tutorial:. This is useful, but you need to be careful. If you want to connect to a Drill data source from an application that does not require a DSN, you can use an ODBC connection string. Thanks also for the connection string hint. Setting Up a Cluster Network; Setting Up MQTT; Step-by-Step: How To Add and Link Multiple Database to Multiple Pages for Alarm Logging; Step-by-Step: Add Client To Active Directory Domain - Part 2. net Project and pervasive SQL. Programs that use Open Database Connectivity (ODBC) to connect to remote databases need a way to identify the type of database and the computer to which they are connecting. The knowledge articles contains solutions and guides. I want to access the SAGE DB i have server name and password and all. without These customizations are supported at runtime using human-readable schema files. exe utility found in the ACT installation folder on the server. Using this driver, you can read your Sage 50 Accounts data files using other software such as Microsoft Excel, Microsoft Access and Microsoft Word. Connect to odbc- how do we know which database it is? Connect to odbc- how do we know which database it is? using would be to use a fully-defined connection. Set the Server and Database values to the value of the DNS field of the ODBC driver you set up earlier. Setting Up a Cluster Network; Setting Up MQTT; Step-by-Step: How To Add and Link Multiple Database to Multiple Pages for Alarm Logging; Step-by-Step: Add Client To Active Directory Domain - Part 2. com? I often tap into different data sources for call and sales stats in applications like MS Access that I then link with. NET Tutorial on Code Examples - Microsoft SQL Server. This allows you to create reports using your company data directly from these programs. [OLE/DB provider returned message: Invalid connection string attribute] I've spoken to Sage, who do not support ODBC on SQL Server, only with MS Office. From the Registry menu, select Export Registry File. mdb If you need more help with this, feel free to create a support ticket and we can provide you with the exact path. ODBC/SQL allows you to open up your ProvideX data to the most popular database managers, query applications, and report writers: MS SQL Server 7, Excel or Word with MSQUERY, Informix, and Crystal Reports, just to name a few. Connection String Options The connection string properties describe the various options that can be used to establish a connection. The exact connection string I'm trying is:. Each version of Sage 50 Accounts comes with an ODBC driver installer, which you can copy from the installation disc and install on any PC that needs to connect to a centralised Sage 50 Accounts database. Enter "DRIVER={Splunk ODBC Driver};" in the string field, and click OK. Lesson 20: Retrieve data from a database - Free tutorials on HTML, CSS and PHP - Build your own website. Hope that helps. odbc sql connection string | Documentine. Sage Line 50 ODBC Schema I have been working on a client management system that is closely integrated with a Sage Line 50 database. Reason: Not associated with a trusted SQL Server connection. This is useful, but you need to be careful. I want to access the SAGE DB i have server name and password and all. I really don't know anything about using Pervasive, but maybe this willl help with the connection string settings, http: Oh yeah, now I remember why I can't stand pervasive. I successfully added an ODBC connection to. If you do not see this driver, then you will probably need to run Sage 100 ERP WorkStation setup. Choose second option (Shared database server) if you manually created database on sql server. Hi Guys, When i have linked table based on DSN odbc connection to postgresql , i am going to : VBA editor, in immediate window. I forgot to add that the J_SOTAMAS90 drive is setup as a system DSN and it test good. 0, but as of September 2017, it had. But the can't because odbc connected on premise data cannot be connect in a easy way. Crystal will NOT save the password inside the. reg, and save it to a network share. rb connection_string = ' driver=. It is not the issue of the ODBC, as MS Excel can fetch data using the same ODBC. The Windows is 64-bit, but the driver is only 32-bit. Can someone tell me how to use VBA to set the ODBC connection string for queries? My workbook has 9 queries, all needing the same string. Any thoughts? Cheers. Note that this FAQ has been written with the assumption that IMan is running on a dedicated server with no other requirements for ODBC connection. Sage Intelligence Training From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution. > I am trying to connect to Sage Line 50 data files through odbc So you will need the odbc connection string to the. To access the. Data Source Name (DSN) Configuration. Sage Customer Support is not responsible for assisting or troubleshooting with this. The CONCAT scalar function is similar to the concatenation operator. Create a connection to an Excel or text file using ODBC drivers: Information design tool 4. You want to create an ODBC connection to the Columbus Database (Firebird) to create custom queries. I tried again while logged in as admin but same issue. It's free to sign up and bid on jobs. An ODBC Data Source consists of a descriptive name that you provide and a Sage 300 CRE data folder path that it represents (among a handful of other settings). ODBC data source connector. Create a new connection inside The Report Viewer. Both function returns a connection handle as a positive integer greater than zero if a connection is made sucessfully. There are some tricks. I created the odbc connection and tested and it was successful, but when I go to connect a new database in Sage CRM and try to save it, I get a “unable to connect to database” message. Here we have accessed MS Access Database and have fetched results from it. I support an Access FE/SQL Server BE application which uses DSNless connections to link to the SQL Server tables. If you write data into the database using something like ODBC then you will likely corrupt the database and cause all sorts of problems down the road. Connection String Examples. This information is intended to assist those who design reports for Sage 50 using Crystal Reports. edu is a platform for academics to share research papers. This is useful, but you need to be careful. > I am trying to connect to Sage Line 50 data files through odbc So you will need the odbc connection string to the. One range (_range1) is selected. so if your file is named db. You can't pervasive oledb HTML pervasive oledb. It contains the following topics: "Connecting to Excel Spreadsheets Through ODBC" "Connecting to SQL Server Database Through ODBC". Hi, I need to set up an ODBC connection to a sage line100 database, so as I can interact with it through ASP. For Oracle database servers, install the 32bit database ODBC drivers. Create an ODBC Connection to a Microsoft Access Database in Windows XP. Failed When Accessing BIE in MAS 200 4. Example of using GPconnnet. Let’s go crazy – accessing Timberline / Pervasive Data from a SQL Linked Server you need to first create an ODBC Connection in your Server DSN, but that’s. The exact connection string I’m trying is:. The Client Server (CS) ODBC Driver allows workstations to print Crystal forms and reports using server-side ODBC processing. An ODBC Data Source consists of a descriptive name that you provide and a Sage 300 CRE data folder path that it represents (among a handful of other settings). Also make sure the user account that you're using for the ODBC connection exist on the SQL Database with the appropriate access rights. support ODBC connectivity. Hi, Neil, I have been trying to reproduce your situation on my own setup but have as yet been unable to get your exact situation. There is a box below this for the Connection String. so if your file is named db. Open() method is called. How do I set up an ODBC User DSN for Accounting and Management data? It is a DSN string but connection string none the less. All Connection Strings for Pervasive. To do so, follow these steps: Select Start, Settings, Control Panel, Administrative tools, Data. A list of ODBC DSN Connection Strings. It seems that people are used to databases which provide ODBC access natively (such as FOXPro, Access, etc. Thanks also for the connection string hint. Can someone tell me how to use VBA to set the ODBC connection string for queries? My workbook has 9 queries, all needing the same string. Remember you need a valid user id and password set up in sage itself…replace S and the location with whatever is correct for your setup. ; Under From Other Sources open From Microsoft Query. I can read the data using the same connection string in a VBScript using ADODB. INI, and highlight the ODBC. ODBC Driver. com The Document World. Using this driver, you can read your Sage 50 Accounts data files using other software such as Microsoft Excel, Microsoft Access and Microsoft Word. Sage ERP/CRM Integration and Synchronization with Office 365 and SharePoint. If that fails, I prompt the user, change the connection string to one that uses the userid/pwd and try again. ) in a file or the Windows Registry, you have plunked them into a connect string, which is then associated with some data object, like an Access linked table. (and the driver/db vendor is. DAT) files that are included in Sage 50. The login also contains the exact properties of the same login in my old server. QuickBooks Custom Reporting-ODBC Implementation Guide 3 | Page Process Overview There are several steps to create a custom report using ODBC. Define a data source name (DSN) by using either the ODBC Data Source Administrator to store the connection information in the registry or a DSN file, or a connect string in Microsoft Visual Basic code to pass the connection information directly to the ODBC Driver Manager. Bonjour, Je suis un débutant au développement avec WinDev et après chercher sans résultat, j'ai adressé à vous pour obtenir de l'aide. Some data sources need an ODBC connection for Excel to get the data you want. The ODBC connection that the Access Database is using fails even on the local machine. Si tu as 10 postes qui se connectent à ta base par ODBC, il faut installer le driver ODBC sur chacun des 10 postes (et donc, me semble-t-il avoir 10 licences odbc). Sachant que la base de SAGE ne contient pas de MDP ni d'utilisateur, j'ai su que je me suis trompé dans une de ces étapes précédentes. Create an ODBC Connection to a Microsoft Access Database in Windows XP. ODBC Driver. com? I often tap into different data sources for call and sales stats in applications like MS Access that I then link with. ps1 for testing a 64 bit ODBC connection on a 64 bit Windows or a 32 bit ODBC connection on a 32 bit Windows or. I am now trying to create an ODBC Data Source. What ports does MS SQL Server use for ODBC connections? Ask Question We can ping the server and create an odbc connection to the server: 1433 (ODBC) icmp netbios. Sage 200 will take over some of this; but we have Shipping and Inspection systems we've built that need to read data from Sage. Similarly, 64-bit Excel will only list data sources using 64-bit drivers. Excel vba create odbc connection keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. The exact connection string I’m trying is:. Open the worksheet you want to use to connect to your Sage data. Microsoft Excel can be a powerful tool to evaluate SQL data. In June 2016, ODBC said it was developing the newest version, 4. I dont know is there is a way to connect to the sage. Do the same if you are using Tableau server on the server. com, sageintelligence. You can use ODBC DSN connections to read named ranges in an Excel spreadsheet. Using SOTAMAS90 will result in the silent ODBC connection failing once Sage 100 ERP itself is started from. If the ODBC connections will be made manually on a 64-bit operating system, please read the Knowledge Base article, Windows 64-bit Operating System Considerations before proceeding. mdb and the username on your hosting account is ramon, the path would look something like Source=E:\hostingspaces\ramon\domain. net; MS Power BI ODBC Connection Pervasive; Pervasive OLEDB provider data source name issue; Pervasive ODBC connection string with user name and password; Articles read all » Formating Rules for Connection Strings; Connection Strings Explained; Store Connection String in Web. The system was designed to create the lowest person-hour schedule based on prison guard requirements and hours worked in a time. dwg and db files to another computer the connections are broken. Sage Customer Support is not responsible for assisting or troubleshooting with this. and even more occasionally, someone with an ODBC problem. Hi, I'm trying to programmatically connect to an RDS Postgres instance with SSL enabled, using the psqlodbc driver (Version:. Database connections via PsqlConnection, PervasiveOLEDB, OleDbConnection, Pervasive ODBC Client Interface and ODBC. Unlike the excel add-in which ships with Sage, the ODBC explorer allows you to see all the tables and view the data or even if you are competent with SQL write your own queries. I've managed to get a workaround, by linking the required Sage tables to an Access mdb and creating a linked server to that. Please contact your Sage swge partner, network administrator, or accountant for assistance. Failed When Accessing BIE in MAS 200 4. For descriptions of all the parameters, see ODBC Configuration and Connection Parameters. Also, the password you entered in the ODBC configuration does not get saved there either - it's used for testing the connection and making sure it can connect to a "valid" datasource. All Connection Strings for Pervasive. (I haven't even heard of sage or timberline. I successfully added an ODBC connection to. You can see now your DSN name in the DSN name List. odbc sql connection string | Documentine. support ODBC connectivity. What ports does MS SQL Server use for ODBC connections? Ask Question We can ping the server and create an odbc connection to the server: 1433 (ODBC) icmp netbios. BES Root Server service unable to connect to database Console unable to connect to server/database and startup; FillDB service unable to connect to the database (resulting in a backlog of client reports). Using this driver, you can read your Sage 50 Accounts data files using other software such as Microsoft Excel, Microsoft Access and Microsoft Word. Download & install PostgresQL ODBC driver. Here we have accessed MS Access Database and have fetched results from it. The ODBC driver supports additional parameters that are not displayed in the dialog. Which front-end program are you using? Password is typically NOT stored along with the DSN in Windows registry. For me it looks like the odbc driver for sage 100 is older (v2? It used to be DOS based solution) than the one used here. Generate connection string. NET Tutorial on Code Examples - Microsoft SQL Server. Open the worksheet you want to use to connect to your Sage data. Using ODBC in VBA (Excel) If this is your first visit, be sure to check out the FAQ by clicking the link above. With Regards Palani. so if your file is named db. Is there a best practise when having an ADO connection to speed up the process? Currently the method I am using below works fine but it's a little slow in getting the data. Connection String For Oracle (1 reply) Open Office (apache) Spreadsheets (3 replies) Odbc To Oracle (0 replies) Access Odbc Timeout On Linked SQL Server Views (3 replies) Connecting To Oracle Database (3 replies) Pass-through Queries With Dsn/tnsnames Less Connection String (1 reply) Db2 SQL - Return Last Order Date Information (4 replies). A server connection timeout means that a server is taking too long to reply to a data request made from another device. Select a table in the Current Data Source and one in the Replace With data source, and click the Update button. [DBNETLIB]SSL Security error[DBNETLIB]ConnectionOpen (SECDoClientHandshake()). Sage Socket Connection Failed Error Code 10061 The most common causes of socket error 10013 are a firewall or anti-virus Socket errors occur for a variety of reasons. za, support. txt) or read online for free. If the other service is not needed, delete it. com\wwwroot\db. Connecting to an External ODBC database e. I support an Access FE/SQL Server BE application which uses DSNless connections to link to the SQL Server tables. Net and sql serer 2005. ODBC data source connector. There are some tricks. ODBC Driver. You must register before you can post: click the register link above to proceed. In step 1 of the Data Connection Wizard, under What kind of data source do you want to connect to, click Other/Advanced, and then click Next. Sorry if there is something I have missed - please ask for any missing info in comments. SAP Analytics 28,960 views. The tool then prompts for the rest of your connection settings. The behavior of Connector/ODBC can be also modified by using special option parameters listed in Table 5. 2, Windows Server 2012 R2 64 bit. QuickBooks Custom Reporting-ODBC Implementation Guide 3 | Page Process Overview There are several steps to create a custom report using ODBC. I have spent fruitless hours looking at all security settings in IIS and the effected folders. Also Please send me the connection string for SAGE DB via SAGE driver. Not true, you can install the ODBC driver on any server , you just need to have the ODBC driver working on the IIS server you want to use. 0 ODBC Driver" from the driver list. When using Sage 100 (or Sage 200) data files, the PxPlus SQL ODBC Driver will prompt the user to enter a valid Company and User ID when invalid data is used during a database connection. If you open the ODBC connection that points to MAS90, it allows you to specify a default company, userID and password. The behavior of Connector/ODBC can be also modified by using special option parameters listed in Table 5. For Oracle database servers, install the 32bit database ODBC drivers. Get the connection string online. BES Root Server service unable to connect to database Console unable to connect to server/database and startup; FillDB service unable to connect to the database (resulting in a backlog of client reports). In this file I have a list of Male/Female mock-up customers. History of Open Database Connectivity. ODBC is a function. Enter "DRIVER={Splunk ODBC Driver};" in the string field, and click OK. Sage 50 Data Provider - RSBSAGE - Connection String Options: to the directory that contains the schema files defining tables, views, and stored procedures. DAT) files that are included in Sage 50. Definition > Connection string > if the string beginswith DSN=SageLine50vXX, where XX is your previous version of Sage 50 Accounts, replace this with your current version. Please run the following commands:. MS Access ODBC Connection. If it's successful, just copy and paste the connection string, if not, you have some work to do on it. Use the DataService to get the current connection string or a connection object:. ODBC data source connector. On the Application tab of the Oracle ODBC Driver Configuration window, un-check all checkboxes with the exception of Read-Only Connection (refer to Figure 1). However if I try to connect to the server via Query analyzer, odbc connection or my client software which uses ADO I get : "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist. We have created this example using LiveCode, MS Access 2003 and Windows XP, but you can use ODBC to connect to any database that supports it, from within LiveCode. AndreaVB Visual Basic and VB. Save this connection. Hi, I'm trying to programmatically connect to an RDS Postgres instance with SSL enabled, using the psqlodbc driver (Version:. I dont know is there is a way to connect to the sage. We have checked and re-checked and re-re-checked that his local workstation trusts the same root certificate authority (plus all intermediary issuing authorities) as does the SQL Server. If you want to connect to a Drill data source from an application that does not require a DSN, you can use an ODBC connection string. I forgot to add that the J_SOTAMAS90 drive is setup as a system DSN and it test good. Connection string issues. Select a table in the Current Data Source and one in the Replace With data source, and click the Update button. How can you determine the odbc associated with a MS Access database? You can try and look at the 'Linked Table' tool which shows you the ODBC path (which is normally the DSN reference). Connect to odbc- how do we know which database it is? Connect to odbc- how do we know which database it is? using would be to use a fully-defined connection. A list of ODBC DSN Connection Strings. I want to access the SAGE DB i have server name and password and all. Remote connection is not enabled for a SQL Server instance; To check remote connection is enabled or disabled, open SQL Server Management Studio-> Connect to SQL Server where it is installed using SQL Server Management Studio ->Go to SQL Server instance property and check Allow remote connection to this server. It is not the issue of the ODBC, as MS Excel can fetch data using the same ODBC. The non SQL database is on the same computer as this PowerShell script. This information is intended to assist those who design reports for Sage 50 using Crystal Reports. How do I set up an ODBC User DSN for Accounting and Management data? It is a DSN string but connection string none the less. Sorry if there is something I have missed - please ask for any missing info in comments. Introduction. Databases Sage ODBC - invalid username and password Hi,I have an ASP that talks to the Sage Line 50 ODBC drivers. INI, and highlight the ODBC. com and etc. Generate connection string. NET Framwork Data Provider for ODBC. Database connections via PsqlConnection, PervasiveOLEDB, OleDbConnection, Pervasive ODBC Client Interface and ODBC. Hope that helps. This uses Access linked tables and ODBC to create a copy of the sage database on SQL so you can query it for reports. When complete, the tool writes the connection string, as above. With this in mind, I then adopted a DSN less connection approach, using a connection string. After installation everything. On Configure RD Connection Broker for HA page, type in the DNS Round Robin name, Connection String and where you want to store the database. ADO Connection String Samples - Free download as PDF File (. It’s easy to join and it’s free. Certain programs, such as Microsoft Excel or Access, allow you to connect to your Sage 50 company data using ODBC. BES Root Server service unable to connect to database Console unable to connect to server/database and startup; FillDB service unable to connect to the database (resulting in a backlog of client reports). Select the name of the Banner/Oracle data source from the list. Thanks also for the connection string hint. Hi am developing a web site which required to connect to the sage Line 50 and get the order information. 1 Chapter 3, “Installing FileMaker ODBC client drivers,” explains how to install the driver files needed for accessing a FileMaker data source using ODBC. Hi, I'm trying to programmatically connect to an RDS Postgres instance with SSL enabled, using the psqlodbc driver (Version:. It was working fine in v8, but recently t, ID #17034307. The login also contains the exact properties of the same login in my old server. Can someone tell me how to use VBA to set the ODBC connection string for queries? My workbook has 9 queries, all needing the same string. 1: The content of this article is still relevant for JasperReports Server v5. Enter the connection information for the ODBC connection and click the Finish button. We'll start by choosing a connection type of Custom Connection, however, you can define a default ODBC Connection by going to Maintenance->ODBC Data Source->Add and setting up a connection that everyone would use. An ODBC Data Source consists of a descriptive name that you provide and a Sage 300 CRE data folder path that it represents (among a handful of other settings). Sage ERP MAS 90", I discussed how a connection can be defined in Sage CRM to the Sage ERP MAS database and individual tables. Type a left delimiter symbol and a right delimiter symbol. Select odbc. In this article, we will explain how to install the appropriate ODBC drivers for SQL Server, how to configure ODBC to connect to a SQL Server instance and how to create and configure a Linked Server using the ODBC driver and the MSDASQL provider to query tables on a SQL Server instance. The login also contains the exact properties of the same login in my old server. Programs that use Open Database Connectivity (ODBC) to connect to remote databases need a way to identify the type of database and the computer to which they are connecting. Select, Delete,Update Records set. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. The following table gives an overview of how to use ODBC and JDBC with FileMaker software. To read Sage Line 50 data just set up an ODBC connection using the driver that is installed with the Line 50 program and then link to the tables in Access (worth setting up a separate user in Sage and then saving the password when linking the tables, also note Sage is a bit case sensitive in some areas such as account refs, etc). To do so, follow these steps: Select Start, Settings, Control Panel, Administrative tools, Data. For remote connection, a stable network is required. But the can't because odbc connected on premise data cannot be connect in a easy way. The ODBC driver supports additional parameters that are not displayed in the dialog. As Sage is a accounting application I can not use any database connector. There is a box below this for the Connection String. Update for JasperReports Server v5. In this type of connection, you specify all necessary information (the driver, the server, the database name, and the user ID) in the connection string. Example of using GPconnnet. Thanks also for the connection string hint. A new Data Source must be created. I want to access the SAGE DB i have server name and password and all. Click the Finish button to continue. The driver may add additional attributes to your connection string. Sage 50 ODBC explorer allows you access to all of your Sage 50 data. Using this driver, you can read your Sage 50 Accounts data files using other software such as Microsoft Excel, Microsoft Access and Microsoft Word. I am using Asp. Scroll down to the "Select a DSN" option and double-click to select it. credentials hard-coded in the ODBC connection string. Databases Sage ODBC - invalid username and password Hi,I have an ASP that talks to the Sage Line 50 ODBC drivers. The DSN has been setup and is working. Ahh here we go. DAT) Files Available in Sage 50 for Crystal Reports, OLEDB, and ODBC. So what I am doing is setting up a "generic" user in MAS90 that is essentially only used to access information.