Re: Lots of frustration w/ Informix logins

In article <01bcf08f$253437e0$559689cf@frances.frances>, frances_corazza@nospams.goldminesw.com says... > >In evaluating most of the major sql servers, I am tripping over Informix. >I understand that I can log into any of my informix databases through the >database explorer with any of my NT users with Informix Admin group. >However, I need to connect to these databases through the Borland Database >Engine. I can connect to my databases fine if I use the the Informix user, >but receive errors with any other user. From a workstation, I get the >error of: > >General SQL error >No connect permission >ISAM error: no record found> >If I attempt to connect from the server, I get an error that it can't open >the sql.iem file, but only if I attempt to log in w/ a username other than >the Informix user. This is thoroughly starting to drive me nuts. I can't >find anything in Answers Online or the online help in regards to logins or >even granting connect privileges to databases. Someone please help . . . > >Frances Frances, Your problem probably stems from not setting up I-net with the Borland setup. You need Inet working correctly with the BDE in order for the whole thing to work. There are actually two set-up panels available to get it straight, one in the SQL Explorer, another for just setting up ODBC et al. Most of the time if you see messages referring to Informix, you can almost bet you forgot about Inet. Be sure to check that an Informix ODBC driver exists and can be seen by the BDE or the Borland ODBC Setup. This is also required in order to work with Informix. Aliases you set up with ODBC can get corrupted. You should set up Inet first, then create an alias with the BDE. For your situation, delete the Borland alias(es), create the Inet connection, then go and create your BDE aliases. I work with this daily, and you are not alone in trying to get this right. It's an interesting set-up, and even experienced users get this cobbed up rather quickly. :-) Tim