Link to home
Start Free TrialLog in
Avatar of macedo
macedo

asked on

SQL LINKS

I am trying to install SQL LINKS version 3.5 with Windows95
and a TCP/IP LAN with a Unix server. This Unix has Informix
version 4.10.
I configured SQL LINKS with SERVER NAME like \\133.0.0.99\/mario/gas/gasgest.dbs where 133.0.0.99 is the internet address and mario/gas the Database path name. The database name is gasgest.dbs which is at the same time the
directory of all Informix tables.
Everything else is configured like Borland advised.
When I try to open the database with Database Desktop, I get the message "cannot load an IDAPI service library. File :SQLINF32.DLL".
So, I don´t know where the problem is.
Please let me have some help.
Best regards,
Mario

Avatar of wizzard
wizzard

Err... :-| Perhaps you should check if all the files were correctly transferred/unpacked during the installation process...
Try this out and pls tell me if you'll solve the problem.
Avatar of macedo

ASKER

Okey!
I am going to install again SQL LINKS and after that I shall send you the results.



Avatar of macedo

ASKER

I have installed SQL LINKS again. I do not have anymore the first error message. However I can’t access Informix database from Delphi environment.
I did the following experience:

1.  I created a new application and a new form.
2.  I inserted in the form a table object and a Data set object.
3.  I configured the table object with a database alias witch is     an alias to Informix database server.
4.  I inserted a DBedit field.

When I made a run command the BDE asked a login name and a password.I used the login and password of Unix database. I got an error message  saying that the database couldn’t be open.

I noticed that the SQL LINKS manual and BDE Help files don’t have an example of Informix driver configuration as they have for Interbase and Oracle. I am wondering if I misunderstood any detail.Please send me a check list of driver configuration fields supposing I have an Unix Server with Informix, a TCP/IP network protocol and Pcs running Windows95 with BDE.

Best regards ,
Mario

Avatar of macedo

ASKER

Adjusted points to 195
ASKER CERTIFIED SOLUTION
Avatar of wizzard
wizzard

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of macedo

ASKER

Thanks a lot for your answer!
I think you are right about INFORMIX. It is a bit difficult to setup.
However, let me tell you that the password I meant was the UNIX administration password.
I am only using INFORMIX SE. Shouldn’t I be using INFORMIX NET?
I shall appreciate your help concerning the programing trucks you talked about.
At the moment,I must use INFORMIX because I have some huge databases running INFORMIX in Unix servers.
In a near future I shall switch to another database. What is the database you advise me?
I work with financial applications that have tables with some hundred thousands records.These applications, most of the time, have about 50 tables. The server operating systems are Unix or Windows NT  and the clients are Windows95.
I would like to have your personal Email.
Mine is mariomacedo@mail.telepac.pt
Best regards,
Mario