Kbase P34284: Connecting VB.NET: ERROR [4200][MERANT][ODBC PROGRESS DRIVER]
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/26/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Having trouble connecting to the Progress database from VB.NET
The connection string is m_strBizConnStr="DSN=Vantage51;UID=sysprogress;Password=sysprogress;
Dim cnBiz As OdbcConnection = New OdbcConnection(m_strBizConnStr)
Error connecting to Vantage: ERROR [4200][MERANT][ODBC PROGRESS DRIVER]
[PROGRESS]Syntax error(7587)
CAUSE:
Syntax error: quoted string not ended.
FIX:
Add closed quote to end of DSN string.
m_strBizConnStr="DSN=Vantage51;UID=sysprogress;Password=sysprogress";
Dim cnBiz As OdbcConnection = New OdbcConnection(m_strBizConnStr)