Scripting

We need a connection string to MAS for an asp page with a sql connection to print labels from BarTender. We've tried the following (and I'm no way an asp person so my aplogies for being less than bright on this one.) Set Connection = Server.CreateObject(""ADODB.Connection"") Set Recordset = Server.CreateObject(""ADODB.Recordset"")' 'here's the last one ConnString = ""DSN=SOTAMAS90; UID=silent;Company=XXX;PWD=xxxxxxx;Directory=C:\Sage\Sage100\Version4\MAS90; Prefix=C:\Sage\Sage100\Version4\MAS90\SY\, C:\Sage\Sage100\Version4\MAS90\==\; ViewDLL=C:\Sage\Sage100\Version4\MAS90\HOME; LogFile=\PVXODBC.LOG; CacheSize=4; DirtyReads=1; BurstMode=1; StripTrailingSpaces=1; SERVER=NotTheServer"" 'here's one from before 'ConnString = ""DRIVER={MAS 90 4.0 ODBC Driver};SERVER=NotTheServer;UID=silent;Company=XXX;PWD=xxxxxxx;Directory=\\Sage1\Sage100\Version4\MAS90\"" also tried this first which I use without issue in ptq in Access ODBC;DSN=SOTAMAS_LABELS;UID=silent|XXX;PWD=xxxxxxx;Directory=\\Sage1\Sage100\Version4\MAS90\;SERVER=NotTheServer Connection.Open ConnString We get an error when any of these run - can't connect to the data.

I wrote up an article a while back about this. See if it helps you any http://www.mbabsi.com/ASP-Web-Applications-accessing-MAS-90.html

@ToddMartin - thank you that looks like what we need. I very much appreciate your writing the article and providing too. Very much appreciated you've saved me hours!

Ultimately the issue was resolved with both @ToddMartin article and also, changing the advanced settings in the application pool of the site to ""Enable 32-Bit Applications"" to true, in case anyone runs into this issue.

Glad to see that it worked out for you. The running as 32 bit app is one thing most forget about. You have to have it set to true for eBusiness as well to run the masisapi.ini otherwise you might get a permissions error.