Accpac session connection

[dichetdi]

Hello,

Can someone please clear a few things up for me when we're converting vba to .NET on how to handle/log in Accpac? Here's the setup. Accpac is install on APP_SERVER1 and a backup APP_SERVER2, the data is on SQL_SERVER and back a on SQL_SERVER2, and 10 users are connected via RDP to terminal server to run Accpac. The the server APP_SERVER1 has two DNS that Accpac could use to log into SQL_SERVER1 and SQL_SERVER2. When I successfully connected to Accpac via my custom .NET app running on APP_SERVER1 to get a few viewId. Later on, which sql server (SQL_SERVER1 or SQL_SERVER2) will Accpac log on? Which DNS will it use as both of my sql box has the same user name, password, and database schema. I use session.Open("USER1", "ACCPAC", "DSDAT", System.DateTime.Now, 0)

Thanks.

 

[Jay Converse]

There should be only one SQL server.

 

[dichetdi]

Yes, but if I recall correctly. Accpac uses DNS to log into SQL Server. My setup has multiple companies that have two DNS one DNS for each company. So when I pass in the my database name DSDAT. Which DNS will Accpac use to connect to SQL Server? Maybe I am not asking the right question. But my goal is to create a .NET tool for users to create batches. When the user launch the tool. How do I capture the user's current session so that I can use to create batches?

Thanks.

 

[Jay Converse]

that have two DNS one DNS for each company". Huh??? There can only be one DNS.

 

[dichetdi]

Ok, I figured it out. We actually passing in the accpac database id to the COM. Thanks tuba2007 again for my newbie questions. As you can see. I am really new at Accpac. Your help is greatly appreciated!

Thanks.