Informix Error 13059
to connect to an Informix database. Connection is ok but when I try to open a table, error happened: ------ BDE error: 13059 Server: -1811 General SQL error. Implicit connection not allowed after an explicit connection. ------ It happed in my program as well as SQL Explorer and Database Desktop. Any suggestion? Thanks. Michael Other Threads 1. BDE error: 13059 (General SQL error) 2. BDE error 13059 General SQL error 3. Error 13059: General SQL Error 4. General SQL error 13059 - while connecting to the SQL database 5. General SQL Error. 13059 6. General SQL Error 13059 [$33] [$ 3] 7. BDE error 13059, MSSQL error 241 8. ARRRGH! Sys error 1157 BDE error 13059 9. Gerenal SQL error 13059 (SQL Server v 7) 10. BDE error 13059 on SELECT statement - BDE Bug??
with Delphi and I have the following error: [Microsoft][ODBC Driver Manager] Information type out of range Could you help me, I really appreciate. Thank Top Error 13059 [$33][$ 3] with Database Engine by Jasper St » Mon, 20 Jan 1997 04:00:00 > Hello, > I need help with ODBC. I'm trying to access Oracle with Delphi http://www.delphigroups.info/2/ed/31524.html and I have > the following error: > [Microsoft][ODBC Driver Manager] Information type out of range It's a bug, finally solved in BDE 3.5, according to the specs. Didn't try it out, though, as I use SQL Links. Jasper Top 1. BDE error: 13059 (General SQL error) http://www.verycomputer.com/158_ca0df28623407168_1.htm Hi ,all: I'm using Windows2000, Delphi 5, BDE 5.11 native Informix driver to connect to an Informix database. Connection is ok but when I try to open a table, error happened: ------ BDE error: 13059 Server: -1811 General SQL error. Implicit connection not allowed after an explicit connection. ------ It happed in my program as well as SQL Explorer and Database Desktop. Any suggestion? Thanks. Michael 2. DBlookupcombo ? 3. Savepoint error "BODAPI"? ORA 13059 4. REWARD FOR SOLUTION - SERIOUSLY 5. Delphi, SQL7 and 13059 ERROR 6. Informix driver for Delphi Client/Server 2.0? 7. Error 13059 - SQL7 and Delphi 8. Fact table and Dimension table from distinct database??? 9. ODBC MYSQL ERROR 13059 10. 13059 ERROR 11. BDE Error 13059 12. SIMMS 8/16/32MB - $33/$62/$126 http:/www.intol.com 2 post • Page:1 of 1 All times are UTC Board index Spam Report
(FAQ) This document applies only to the following language version(s): English Question When client connections try to reach the Informix instance, the error -951 (User username is not http://www-01.ibm.com/support/docview.wss?uid=swg21588239 known on the database server/User is not known on remote host) is raised, avoiding http://www.dbforums.com/showthread.php?1216529-BDE-Connection-via-ODBC-to-MS-SQL-Server-fails clients to connect. Cause You see errors like this in the online.log file: 13:14:57 Get Shadow Password for user [username] failed! 13:14:57 Check for password aging/account lock-out. 13:14:57 listener-thread: err = -951: oserr = 0: errstr = username@::ffff:10.10.10.31[server.host.net]: Incorrect password or user username@::ffff:10.10.10.31[server.host.net] is not known on the database server. Several symptoms can cause such behaviour: informix error SQLHOSTS file mispelled entries; DBSERVERNAME or DBSERVERALIASES onconfig parameters have no related entries in the SQLHOSTS file; NIS or LDAP servers misconfiguration or maintenance; INFORMIXDIR filesystem and/or its subdirectories have wrong permissions or ownership; User is locked or expired; oninit binary is somehow damaged or have wrong permissions. Answer Here's a list of things to check when facing such a problem: 1) Double-check the SQLHOSTS file for missing or mispelled informix error 13059 entries regarding the DBSERVERNAME and DBSERVERALIASES onconfig parameter values; 2) Validate with the OS staff changes in the LDAP or NIS servers; If none of the above were causing the issue, check the INFORMIXDIR filesystem for proper permissions and/or ownership: 1) Collect an ls -ltrR output from the INFORMIXDIR filesystem and compare its contents with the $INFORMIXDIR/etc/IIFfiles file; 2) Check for onwership too; If the contents of the ls -ltrR diverges from the $INFORMIXDIR/etc/IIFfiles file, consider doing one of following: 1) Fix manually the missing permissions or ownership of every file/subdirectory; 2) Copy the INFORMIXDIR filesystem from another validated non-productive host; 3) Restore this filesystem from backup; 4) Re-install the Informix Server binaries. In any of the options above, make proper backups of critical files like the onconfig, sqlhosts and ixbar files. Important: these are just a few probable causes for this problem, if this document didn't solve your issue, consider calling IBM Informix Technical Support for assistance. Related information INFORMIXDIR /opt/informix is not owned by user with id Script to check permission and ownerships of Informix p User gets error -951 when connecting to the database se Document information More support for: Informix Servers Informix Internet Foundation Software version: 11.1, 11.5, 11.70, 12.1 Operating system(s): AIX, HP-UX, Linux
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: BDE Connection via ODBC to MS SQL Server fails Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-04-06,12:29 #1 Sanyi_Albert View Profile View Forum Posts Registered User Join Date May 2006 Posts 2 Unanswered: BDE Connection via ODBC to MS SQL Server fails Hi, I have a strange problem accessing a MS SQL Database from my network. I'm using an application that is based on BDE which uses ODBC to connect to a MS SQL DB. When I tried to connect from the network with BDE,I got this error message: BDE Error : 13059 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). On the server side I'm using W2003 EE ,MS SQL 2000 Standard with SP4, BDE5.11. On the client side it's an XP SP2 with MS SQL Client installed, same BDE 5.11 When I create an alias using ODBC and mapping to my server, it connects and the communication with the Database Server succeds: TESTS COMPLETED SUCCESSFULLY! When I'm trying to connect using BDE Admin and double clicking on the + sign of the alias I created usind ODBC admin I get the message I listed above. Any help would be appreciated, Thanks. Reply With Quote 05-04-06,15:38 #2 Satya View Profile View Forum Posts Visit Homepage Grand Poobah Join Date Aug 2002 Location Scotland Posts 1,578 May check this http://support.plato.com/kb/tip.asp?psid=23252 link fyi. --Satya SKJ Microsoft