Greetings,
I hope someone can help me with the following questions.
Our financial software will run on Progress (obviously), DBII and Oracle. We now want to run it on SQL server.
I am using Progress version 91c. For test purposes, I have installed a local version of SQL Server 2000 (MSDE). I created an empty SQL database and ran the DataServer utility "Progress DB to MS SQL Server" which created and updated the tables in SQL Server.
The code page used for the schema holder is ISO8859-1.
To connect to SQL server I am using the MS SQL Server driver (sqlsrv32.dll version 2000.80.380).
Generally speaking, the data was imported properly and the apps run OK on SQL Server but there are some differences between Progress & SQL with which I need help:
1. According to the Progress DataServer documentation, SQL does not support descending indexes. So I initially created ascending indexes and from SQL Server Admin. I changed the indexes to descending - so descending indexes are allowed. The DataServer, though, still sees a difference between the schema holder and the SQL database. Does anybody know why?
2. Case-sensitivity. By default SQL is case-INsensitive. For the most part, so is our Progress database. But the DataServer utilities say that the SQL fields are case-sensitive when they are not. The default "collation method" for SQL varchar fields is "Latin1_General_CI_AS". This is case-INsensitive. Why does this happen?
3. When creating the SQL tables, fields which should be case-sensitive are created using the SQL default - which is case-INsensitive. According to the DataServer utilities, the fields are the same. Again why?
4. To connect to the SQL database from the schema holder I can also use the Progress 91c SQL Server Dirver (p1msss16.dll version 3.70). Does it matter which ODBC driver I use?
Thanks for the help.
Sean Conlon
I hope someone can help me with the following questions.
Our financial software will run on Progress (obviously), DBII and Oracle. We now want to run it on SQL server.
I am using Progress version 91c. For test purposes, I have installed a local version of SQL Server 2000 (MSDE). I created an empty SQL database and ran the DataServer utility "Progress DB to MS SQL Server" which created and updated the tables in SQL Server.
The code page used for the schema holder is ISO8859-1.
To connect to SQL server I am using the MS SQL Server driver (sqlsrv32.dll version 2000.80.380).
Generally speaking, the data was imported properly and the apps run OK on SQL Server but there are some differences between Progress & SQL with which I need help:
1. According to the Progress DataServer documentation, SQL does not support descending indexes. So I initially created ascending indexes and from SQL Server Admin. I changed the indexes to descending - so descending indexes are allowed. The DataServer, though, still sees a difference between the schema holder and the SQL database. Does anybody know why?
2. Case-sensitivity. By default SQL is case-INsensitive. For the most part, so is our Progress database. But the DataServer utilities say that the SQL fields are case-sensitive when they are not. The default "collation method" for SQL varchar fields is "Latin1_General_CI_AS". This is case-INsensitive. Why does this happen?
3. When creating the SQL tables, fields which should be case-sensitive are created using the SQL default - which is case-INsensitive. According to the DataServer utilities, the fields are the same. Again why?
4. To connect to the SQL database from the schema holder I can also use the Progress 91c SQL Server Dirver (p1msss16.dll version 3.70). Does it matter which ODBC driver I use?
Thanks for the help.
Sean Conlon