odbc_connect(): SQL error: [unixODBC][DataDirect][ODBC 20101 driver]

Tierra

New Member
This is my first post;
I was trying to connect Progress 9 1 E on Linux ( OpenSuse 10 32 bits) with PostgresSql on Linux (OpenSuse 12.1) through ODBC and php script and the following error message popped up:
PHP Warning: odbc_connect(): SQL error: [unixODBC][DataDirect][ODBC 20101 driver][20101]Database not started, SQL state 60 in SQLConnect in /sipap/01_mig_apla_cctsocio.php on line 14
the data bases are working properly. I would really appreciate if you could help me with this.
Thank you very much
Esteban Spessot
 
Could you tell me where I set it up?
I configured the odbc.ini file

[ODBC Data Sources]
prg_apla = Progress_SQL92_Driver
prg_pausa = Progress_SQL92_Driver
prg_planauto = Progress_SQL92_Driver

[prg_apla]
QEWSD = 39634
Driver = / usr/dlc/odbc/lib/pgpro918.so
DatabaseName = BDG
Portnumber = 21001
Hostname = localhost
LogonID = sysprogress
Password = sysprogress
APILevel = 1
ConnectFunctions = yyn
CPTimeout = 60
DriverODBCVer = 04.10
FileUsage = 0
SQLLevel = 0
UsageCount = 1
Arraysize = 50
DefaultIsolationLevel = REPEATABLE READ
StaticCursorLongColBuffLen = 4096

[prg_pausa]
QEWSD = 39634
Driver = / usr/dlc/odbc/lib/pgpro918.so
DatabaseName = BDG
Portnumber = 25005
Hostname = localhost
LogonID = sysprogress
Password = sysprogress
APILevel = 1
ConnectFunctions = yyn
CPTimeout = 60
DriverODBCVer = 04.10
FileUsage = 0
SQLLevel = 0
UsageCount = 1
Arraysize = 50
DefaultIsolationLevel = REPEATABLE READ
StaticCursorLongColBuffLen = 4096

[prg_planauto]
QEWSD = 39634
Driver = / usr/dlc/odbc/lib/pgpro918.so
DatabaseName = BDG
Portnumber = 2500
Hostname = localhost
LogonID = sysprogress
Password = sysprogress
APILevel = 1
ConnectFunctions = yyn
CPTimeout = 60
DriverODBCVer = 04.10
FileUsage = 0
SQLLevel = 0
UsageCount = 1
Arraysize = 50
DefaultIsolationLevel = REPEATABLE READ
StaticCursorLongColBuffLen = 4096

[ODBC]
InstallDir = / usr / dlc / odbc
Trace = 0
TraceFile = / usr / dlc / odbc / odbctrace.out
TraceDll = / usr / dlc / odbc / lib / odbctrac.so
UseCursorLib = 0








Did you configure the SQL access on the Progress database?

Heavy Regards, RealHeavyDude.
 
The Progress database is not an SQL database in the first place. That means that out-of-the-box it might not work as it expect it to, therefore you need to configure the SQL engine on the Progress database - which should not be confused with the configuration of the driver.

You need to
  • Configure the security: Out-of-the-box the SQL engine only accepts logins with user credentials under which the database was created in the OS or the SYSPROGRESS user created manually in the data administration tool. Both of which will have DBA rights granted. From there you need to go on and CREATE users and GRANT them privileges on the SQL engine (with SQL statements).
  • Make sure that the broker accepts SQL connections - better yet configure a secondary login broker dedicated to SQL clients.


Heavy Regards, RealHeavyDude.
 
Back
Top