ODBC Connection error

Posted in 2000

Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

Colin Mackay — Fri, 21 Apr 2000 17:13:57 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi there, We have an Informix SE 7.2 installation running on a Sun OS. I have set all the services running on the Unix box ok and it seems to connect but when i try to run the ODBC drivers with valid usernames and passwords i get the following error: SQL Error State:S1000, Native Error Code: FFFFFEB7, ODBC Error: [Informix][Informix ODBC Driver][Informix]Database not found or no system permission. sqlerrm(systables) Im pretty sure the database name is correct as i can see it using isql on the Unix box. Does anyone have any ideas why this might be happening? Thanks, Colin

↪ replying to Colin Mackay

Watawinona — 25 Apr 2000 20:45:09 GMT — source: Informix-list mailing list archive (1991-1998)

>ubject: ODBC Connection error >From: "Colin Mackay" colin.mackay@altor.co.uk >Date: 21.04.00 18:13 W. Europe Daylight Time >Message-id: <8dpv13$ifc$1@phys-pa.sol.co.uk> > >Hi there, > >We have an Informix SE 7.2 installation running on a Sun OS. I have set all >the services running on the Unix box ok and it seems to connect but when i >try to run the ODBC drivers with valid usernames and passwords i get the >following error: > >SQL Error State:S1000, Native Error Code: FFFFFEB7, ODBC Error: >[Informix][Informix ODBC Driver][Informix]Database not found or no system >permission. sqlerrm(systables) > >Im pretty sure the database name is correct as i can see it using isql on >the Unix box. Does anyone have any ideas why this might be happening? > >Thanks, > >Colin > > > check that the SE is started with the root account. check the permissions of the directory holding the SE. you will have to open it up to other. Nona