Ado.net ODBC problem connecting to Progress database
-
Hello, I am developing an vb.net application and trying to connect to a 9.1B Progress database (I already have read how Progress is not an easy database to connect to.) I have the Merant driver installed on the client and server for connecting to Progress. When I try to connect to Progress through the system admin using Merant ODBC and the system DSN, it connects fine. (Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC)->System DSN->Configure) (on the Advanced tab in Configure, the Security Required is NOT selected) So far, all the forum postings(multiple websites) I have seen for the error message ERROR HY000 MERANT ODBC Progress driver insufficient information to connect to the data source recommend the same fix yet I have tried the recommended fix and still get the error. My connection string is DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=" "; PWD=" "; database=ourdatabase; The forums say the error is from not having a UID and PWD parameter in the connection string. However, I DO have each of these. I read that the ASP-engine will(incorrectly) not pass on the UID/PWD parameters when the UID/PWD variable values are emtpy. Workaround: pass on a non-empty UID/PWD string filled with blanks. So I changed my original connectionstring from UID=; to UID=" "; and from PWD=; to PWD=" "; No improvement. anybody know the connection string for Progress database in .net using Merant 3.70 driver or how I can further determine what the insufficent information is referring to? Thanks
-
Hello, I am developing an vb.net application and trying to connect to a 9.1B Progress database (I already have read how Progress is not an easy database to connect to.) I have the Merant driver installed on the client and server for connecting to Progress. When I try to connect to Progress through the system admin using Merant ODBC and the system DSN, it connects fine. (Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC)->System DSN->Configure) (on the Advanced tab in Configure, the Security Required is NOT selected) So far, all the forum postings(multiple websites) I have seen for the error message ERROR HY000 MERANT ODBC Progress driver insufficient information to connect to the data source recommend the same fix yet I have tried the recommended fix and still get the error. My connection string is DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=" "; PWD=" "; database=ourdatabase; The forums say the error is from not having a UID and PWD parameter in the connection string. However, I DO have each of these. I read that the ASP-engine will(incorrectly) not pass on the UID/PWD parameters when the UID/PWD variable values are emtpy. Workaround: pass on a non-empty UID/PWD string filled with blanks. So I changed my original connectionstring from UID=; to UID=" "; and from PWD=; to PWD=" "; No improvement. anybody know the connection string for Progress database in .net using Merant 3.70 driver or how I can further determine what the insufficent information is referring to? Thanks
Youb have written correct string but if you have SQL server name (e.g.'sa' PWD='' or PWD='sa' ) whatever u have given at the inststallation time that must be matched. Then u can easily connect to ur database. I think there's no need to write 'DRIVER={MERANT 3.70 32-BIT PROGRESS};' But I m not sure about this so check it. Without that it is working but don't give null string to the UID or PWD field but gie as below. DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=; PWD=; database=ourdatabase; Bye, Jesal Rana OK
-
Youb have written correct string but if you have SQL server name (e.g.'sa' PWD='' or PWD='sa' ) whatever u have given at the inststallation time that must be matched. Then u can easily connect to ur database. I think there's no need to write 'DRIVER={MERANT 3.70 32-BIT PROGRESS};' But I m not sure about this so check it. Without that it is working but don't give null string to the UID or PWD field but gie as below. DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=; PWD=; database=ourdatabase; Bye, Jesal Rana OK
Jesal, thank you so much for a response. I have posted this question on four different websites, including "the" Progress database defacto website with no responses. It is saturday morning and I am at home. I will follow up on your recommendations on Monday and respond. By the way, have you had this same experience? do you have much experience with Progress databases? thanks!
-
Youb have written correct string but if you have SQL server name (e.g.'sa' PWD='' or PWD='sa' ) whatever u have given at the inststallation time that must be matched. Then u can easily connect to ur database. I think there's no need to write 'DRIVER={MERANT 3.70 32-BIT PROGRESS};' But I m not sure about this so check it. Without that it is working but don't give null string to the UID or PWD field but gie as below. DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=; PWD=; database=ourdatabase; Bye, Jesal Rana OK
Jesal, I am trying to connect to a Progress database within a vb.net or asp.net (either one will work for me) application. There is no Microsoft SQL Server involved. If I don't have Driver={MERANT 3.70 32-Bit Progress}; within the connection string, the error messages are: Found ObcException type error - ERROR [HYC00][MERANT] [ODBC PROGRESS driver]Optional feature not implemented ERROR [HY000][MERANT] [ODBC PROGRESS driver] msgOpen: Unable to open message file: PROMSGS ERROR [IM006][MERANT] [ODBC PROGRESS driver] SQLSetConnectAttr failed. So clearly, I will get less messages if the connection string contains Driver={MERANT 3.70 32-Bit Progress};