Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Establishing an ODBC / ADO connection to MAS 90
The ODBC driver you're using likely doesn't support the asterisk to specify all columns. Try explicitly stating each column name in the query.- Arnell
- Post #8
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Establishing an ODBC / ADO connection to MAS 90
ABJ, I'm not an ASP expert but there should be no difference between the VB I provided and VBScript. Just ensure that you properly create an ADO connection object. However, if you are not using a Providex ODBC driver your connection string might require different parameters. Hopefully this...- Arnell
- Post #4
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Establishing an ODBC / ADO connection to MAS 90
One more thing. You can find the name of the ODBC driver in the ODBC Data Source Administrator dialog. This is the same place you create DSNs (get there from the Control Panel). Just click on the Drivers tab and find the name of the driver you need in the Name column. Enclose the driver name...- Arnell
- Post #2
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Establishing an ODBC / ADO connection to MAS 90
This seems to be an issue for some so I thought I'd post my solution. We are using the ProvideX ODBC driver (version 3.2.2) to connect to MAS90 remotely. I have a VB application and am connecting via ADO to the MAS90 database without using a DSN. Here's the VB code with the connection string...- Arnell
- Thread
- Replies: 49
- Forum: Sage 100 ERP (fka Mas90/Mas200)
