Search results for query: *

I'm not quite sure what type of connection you are using. If you are using a DSN, then why are you also specifying the server name? Try using an ODBC connection with the connection string I posted back on April 12. Let me know of your progress.

Are there any products out on the market that allow multiple colors/sizes/etc to be assigned to an item number? If not, has anyone come across this issue, and maybe have a creative work-around / solution? Thanks in advance.

Hi dgprog, Couple of things to note: 1. Make sure the company code in the connection string is in upper case letters. 2. Impersonation: The tag in the web config file also needs the username and password of who to impersonate. Try it first with your own username and password (the one you use...

Hi RyanSpeakman, Sorry about the delay. I haven't tried the connection to MAS90 via a DSN, but I think you are missing the UID and PWD parameters in your connection string. FYI - DSN connections are slower compared to an ODBC connection. DSN-less connections are also easier to maintain as you...

RyanSpeakman, The 'table not accessible' error is truly frustrating. I had spent weeks trying to get around it by trying to address the permissions issue to no avail. The best way, and only one that I know of, is to use Identity Impersonation in ASP.NET. (<identity impersonate="true"...

Don't use the datareader. With a datareader you only read one record at a time, forcing you to go back to MAS90 ... well 7000 times!!! Try the DataAdapter / DataSet approach. Worked for me.

Ok. Have written ASP.NET/VB.NET app that accesses MAS90. Utilizes identity impersonation & Odbc. If anybody needs code, just ask. BUT the problem.... when I deploy to our production server, the page hangs right at the point where I open the actual connection. "connMAS90.Open()". This works...

Hello All, First of all thanks to all, all ur prior woes have provided me with the info i needed. If anyone is still having the 'Table not accessible' problem, and has tried alcor001's solution regarding user permissions..... if your network has ntfs security enabled, u must enable windows...