We are attempting to access a Progress DB via ODBC. On our client's server, the DSN has been successfully setup (previously, by our client) and the connection tests successfully from within the ODBC administrator. We can also connect to the Progress DB via ODBC and read data from within Crystal Reports as well as from within MS Access. The ODBC administrator describes this ODBC driver as: "DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E".
The problem comes when trying to access this ODBC DSN from an ASP.NET-based application called Dbnetgrid. I have installed the Microsoft ODBC .NET data provider which supposedly provides ODBC connectivity to the .NET environment.
Within Dbnetgrid, the connection string looks like the following:
"Provider=ODBCprovider;Dbmsname=??;DSN=Progress;UID=xxx;PWD=yyy;"
where the correct DSN name is actually "Progress". But I don't know the correct Dbmsname for the Progress database. I have made many guesses without success. I can connect to other (non-Progress) databases via ODBC with, for example, a connection string such as: "Provider=ODBCProvider; DBMSName=Microsoft SQL Server; DSN=testdb; UID=xxx; PWD=yyy;"
If I take out the "DBMSName=" attribute, I get an error message that a
DBMSName must be supplied. If I try "DBMSName=Progress" I get a
message stating that the DBMSName is not recognized. I've also tried ODBC connection strings which specify a Driver and a Database, rather than a DSN, but I still get the message that a DBMSName must be provided.
Can anyone help by providing the correct DBMSName for a Progress
database using the "DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E" ODBC
driver? If not, could someone please direct me to another source for
help/support on this issue?
Thank you.
John Zappe
infoSpectrum
170 Ocean St.
South Portland, ME 04106
207.799.0100
The problem comes when trying to access this ODBC DSN from an ASP.NET-based application called Dbnetgrid. I have installed the Microsoft ODBC .NET data provider which supposedly provides ODBC connectivity to the .NET environment.
Within Dbnetgrid, the connection string looks like the following:
"Provider=ODBCprovider;Dbmsname=??;DSN=Progress;UID=xxx;PWD=yyy;"
where the correct DSN name is actually "Progress". But I don't know the correct Dbmsname for the Progress database. I have made many guesses without success. I can connect to other (non-Progress) databases via ODBC with, for example, a connection string such as: "Provider=ODBCProvider; DBMSName=Microsoft SQL Server; DSN=testdb; UID=xxx; PWD=yyy;"
If I take out the "DBMSName=" attribute, I get an error message that a
DBMSName must be supplied. If I try "DBMSName=Progress" I get a
message stating that the DBMSName is not recognized. I've also tried ODBC connection strings which specify a Driver and a Database, rather than a DSN, but I still get the message that a DBMSName must be provided.
Can anyone help by providing the correct DBMSName for a Progress
database using the "DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E" ODBC
driver? If not, could someone please direct me to another source for
help/support on this issue?
Thank you.
John Zappe
infoSpectrum
170 Ocean St.
South Portland, ME 04106
207.799.0100