Please make sure that the "Domain\AOSSever$" user, i.e. the under which the AOS is running, has permissions to read the data you want to read.
Regards, Palle --- In [email protected], "branjema" <[EMAIL PROTECTED]> wrote: > > Thank You. But I still get an error. > > when the class is set to 'server' I get this error: > > [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for > user 'Domain\AOSSever$'. > > and if I set the class to 'client': > > ODBC operation failed. > LoginProperty must be instantiated on same tier as OdbcConnection. > > Do I need to set permissions? > > thanks > > Brian > > > > --- In [email protected], "palleagermark" > <palle@> wrote: > > > > In 4.0 no client is supposed to access the database directly. Only > > the AOS can do that, and as such code like this will have to access > > the database in the security context of the user which the AOS runs. > > > > Following code will work: > > ODBCConnection connection; > > SqlSystem sqlSystem = new SqlSystem(); > > LoginProperty loginProperty = > > sqlSystem.createLoginProperty(); > > Statement statement; > > ResultSet resultSet; > > SqlStatementExecutePermission sqlStatementExecutePermission; > > str sqlStatement; > > ; > > > > loginProperty = sqlSystem.createLoginProperty(); > > loginProperty.setServer('MyServer'); > > loginProperty.setDatabase('MyDatabase'); > > > > connection = new ODBCConnection(loginProperty); > > > > statement = connection.createStatement(); > > > > sqlStatement = "select * from MyTable"; > > sqlStatementExecutePermission = new SqlStatementExecutePermission > > (sqlStatement); > > > > sqlStatementExecutePermission.assert(); > > > > resultSet = statement.executeQuery(sqlStatement); > > > > > > Regards, > > Palle Agermark > > > > --- In [email protected], "branjema" <branjema@> > > wrote: > > > > > > Hi I have a problem with the following code below. I tried > > creating > > > the DSN on the server and setting the class to runon = 'server' > > > > > > but it cannot find the DSN. > > > > > > question 1: must I set up the DSN on all client machines? > > > > > > > > > > > > also I tried these lines of code: > > > > > > > > > //loginProperty.setUsername(""); // user name > > > //loginProperty.setDatabase(''); // database name > > > //loginProperty.setServer(""); // SERVER name > > > > > > > > > but i get an error message stating that these properties are no > > > longer supported. > > > > > > the problem is I need to retrieve data from another server to run > a > > > report. > > > > > > can anyone help? > > > > > > Thanks in advance > > > > > > b > > > > > > > > > > > > ODBCConnection oDBCConnection; > > > LoginProperty loginProperty; > > > Statement statement; > > > ResultSet r; > > > str strTest; > > > > > > > > > ; > > > > > > > > > > > > > > > // Initialize Connection > > > loginProperty = new LoginProperty(); > > > loginProperty.setDSN('test'); // DSN Name > > > > > > > > > > > > //loginProperty.setUsername(""); // user name > > > //loginProperty.setDatabase(''); // database name > > > //loginProperty.setServer(""); // SERVER name > > > > > > //loginProperty.setPassword(""); // password > > > > > > // Create Connection Object > > > > > > ODBCConnection = new ODBCConnection(loginProperty); > > > statement = oDBCConnection.createStatement(); > > > > > > // Execute update Query > > > r = statement.executeQuery("SELECT * from table); // > > > > > > while (r.next()) > > > > > > strTest = r.getString(2) ; > > > > > > > > > return r.getString(1); > > > > > >
