Retrieve accpac SQL Server Name ADODB - DOT NET

[71001]

Hi,

Currently doing development in C# dot net to query the Accpac ERPv5.5 application. The accpac application uses a MSSQL server database as its back end system.

Is it possible to retrieve the MSSQL server name from the ACCPAC.Advantage.dll so we can create a connection using ABODB in dotnet.

Currently we are able to access the company ids and names from the Organization list in the Session class.

Once the user has selected a company and supplied the username, password we would like setup the connection details so we are able to do a ado/ odbc connection.

This information is stored and accessed via the ‘Database Setup’ program (a4wsetup) and we were wondering if we could access it from dotnet?

thanks

 

[Jay Converse]

Take a look at the ASORGS view (AS0020).

 

[SLICan]

How many ACCPAC database you have in MSSQL? To me, since we have only one (in Pervasive) we just simply hardcode in in web.config.