Technical and Installation Discussions

[aldo]

Hello,

I just introduced two new computers to our network and I am finding that the string below:

     ODBC;DSN=MAS90_OURCOMPANY;Directory=k:\mas90\;Company=OURACOMPANY;SERVER=NotTheServer;TABLE=

which works great on our old WinMe computers no longer appears to work on the new Windows 7 computers, but generates an ODBC failure notice.

We are using MAS90 3.71 and MSAccess 2000. Our server is a Win2000 machine.

1. Is there another updated string that can be used?
2. Can I link to the tables manually from Access using the 'Get External Data/Link Tables'?

Thanks,

Aldo

[connex]

The new link string looks like this:

ODBC;DSN=MAS90_DSN;UID=uuu|ccc;PWD=ppp; Directory=M:\MAS90;CacheSize=4;DirtyReads=1;BurstMode=1;SERVER=NotTheServer;TABLE=

 where uuu = the MAS user id, ccc = company code and ppp = password.

Yes you can link from Access. You will need to use the check box to remember credentials and use a silent DSN to avoid login prompts. Also, unlike a Pass Through Query, you will need to delete and relink your links if you change your MAS location. You can edit the parameters of a Pass Through Query.

[BigLouie]

Welcome to the Sage Community Aldo. You will notice that using SQL specific pass through queries works best and works better than linking.

[aldo]

Hello connex,

It took me awhile to break down the access code that was overiding the new string, but I finally got it done.

I still receive the error message stating that this "is not a valid path or table."

ODBC;DSN=MAS90_DSN;UID=uuu|ccc;PWD=ppp; Directory=M:\MAS90;CacheSize=4;DirtyReads=1;BurstMode=1;SERVER=NotTheServer;TABLE=

I substituted my user ID for uuu

Company code for ccc

user password for ppp

and even replaced your M:\MAS90 with the appropriate K:\MAS90, but to no avail.

With Windows 7 I do get a security warning whenever I openup MAS90, which says, "The publisher could not be verified. Are you sure you want to run this software?" Yet I can log in to the application just fine. Could my problems somehow be linked to my version of MAS90 not having a valid signature?

-aldo