Sotamas90 odbc driver download

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Who owns this outage? Building intelligent escalation chains for modern SRE. Podcast Who is building clouds for the independent developer?

Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer. Related 0. There you have it. Access to MAS90 data in 17 lines of code. The VBS extension is very important. You can run the script in 1 of 2 ways. Use Windows Explorer to browse to where you saved the file and click on it.

A message box will be displayed, one for each record. VBS A list will be displayed on the console. Some additional bits. Some of you may recognize this example as ADO access. You are correct. Ask a related question. Author Commented: As far as I am concerned, please delete this article. I will take my business elsewhere.

Sure, lets give it a try. Get Access. See also Installing the macOS driver. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Click on File, New and choose Blank Database. Save the database on a local drive or in a location of your choice. Open Crystal and start a new report 3. Pull into the detail section all fields you want 5. Go to Database on the menu 6. Highlight and copy the entire SQL statement.

Open your Access application 9. Go to Queries Create New Query Close table box that opens. Change Query type to SQL specific When edit window opens paste in SQL statement from Crystal Go to View on menu Go to Properties The rest will be based on your system.

Note there is a between the user ID and the company code. It is critcial to omit these options in the connection string.

You now have a working pass-through query with auto-login. This method returns data faster than a linked table and allows you to connect to MAS without having to create a silent DSN. First: A quick hello to BigLouie I don't expect mpemberton to still be researching this but I'll add this into the post anyway. I remember wrestling with this and it was not apparent what format to use. Red Flag This Post Please let us know here why this post is inappropriate.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members!

Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free.