Progress 8.3B18 Merant 3.5 Syteline 4.02.10 NT4
Hello all,
I know my environment does not fit the criteria for this list exactly but possibly someone has done what I am trying.
I would like to run MS SQL 7 distributed queries against our Syteline/Progress production database. To do this I would like to create a SQL 7 linked server through the Merant ODBC driver.
I already successfully connect and query the database from MS Access through the Merant driver. In this case, the ODBC connects via the symixoib broker service. I believe all permissions are handled through the broker. We don't use any Progress logins--everything is through Syteline permissions. When I link a table from Access I don't need to supply a user id or password.
When I set up the linked server I just supply the machine data source DSN name, the same one that I use to link to tables through Access. When I try to run a simple distributed query from SQL 7 query analyzer I have to kill the query after 3 minutes. If I run the same query through Access the query takes about 1 sec.
Any suggestions???
Thanks!
Hello all,
I know my environment does not fit the criteria for this list exactly but possibly someone has done what I am trying.
I would like to run MS SQL 7 distributed queries against our Syteline/Progress production database. To do this I would like to create a SQL 7 linked server through the Merant ODBC driver.
I already successfully connect and query the database from MS Access through the Merant driver. In this case, the ODBC connects via the symixoib broker service. I believe all permissions are handled through the broker. We don't use any Progress logins--everything is through Syteline permissions. When I link a table from Access I don't need to supply a user id or password.
When I set up the linked server I just supply the machine data source DSN name, the same one that I use to link to tables through Access. When I try to run a simple distributed query from SQL 7 query analyzer I have to kill the query after 3 minutes. If I run the same query through Access the query takes about 1 sec.
Any suggestions???
Thanks!
