Search results for query: *

Hey Everyone, I'm trying to write a C# app that will show a list of all tables in MAS200. I know you can do it because, how else can Crystal Reports Query all the tables for a user to select when writing a report. I have a workign C# applications that connect and can read data, I'm having...

What SOTAMAS driver are you using? What version of MAS200? We are running 4.05 with provideX ver. 3.33 and some reports are slow.

We aren't on 4.XX we still are on 3.71 with hopes to move over to 4.05 by Feb 06.

I actually got this working with perl, my next venture will be with C#. From my googling I see it might be calling a stored procedure called SP_TABLES, but I have no idea at this point. Theres a function with the DBI module called "table_info()". I'm not sure what it does behind the scenes...

Thanks guys for the input. I don't think its a permissions error because I used to get this error when I tried to make a simple C# app that connected to MAS200 and view contents of a table. It turned out that it was VERY picky of the connection string. I will try the suggestions, but I have...

Not that you want to buy another module, but we use a module called "StarShip" that integrates FedEx, UPS, DHL and other vendors with MAS200.

Hey Everyone, I'm trying to write a mini Perl app that will show a list of all tables in MAS200. I have made lots of apps to grab data through the SOTAMAS90 ODBC driver (ver 3.21). Here's what I have tried as my SQL statement all I get is an error: DBD::ODBC::db prepare failed...

No problem, gkad to have helped. We are using perl right now for MAS200 things, but I wanted to see if there was a C# way.

I got it working, it was very picky about the connection string. I'm using ProvideX ver.3.22 Here's my string .. string connString = "Driver={ProvideX 32-Bit ODBC Driver};" + "Persist Security Info=False;DNS=XXXXX;" + "UID=XXXXX;" + "PWD=XXXX;" + "Directory=\\\\111.18.1.893\\best\\mas90;"+...

I also Just tried Version 3.22 and same error .. grrrrr

Hi Everyone, I'm glad I've found this board, hopefully someone will have some answers for me. First Off, I've searched the forum and I haven't had any luck with this problem. I want to write a simple C# application to grab some data from MAS200. I'm connecting fine, but when it comes time...