Solved

SQL LINKS

Posted on 1997-03-29
6
249 Views
Last Modified: 2010-04-06
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

0
Comment
Question by:macedo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 

Expert Comment

by:wizzard
ID: 1335043
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.
0
 

Author Comment

by:macedo
ID: 1335044
Okey!
I am going to install again SQL LINKS and after that I shall send you the results.



0
 

Author Comment

by:macedo
ID: 1335045
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

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:macedo
ID: 1335046
Adjusted points to 195
0
 

Accepted Solution

by:
wizzard earned 190 total points
ID: 1335047
Perhaps I should try to answer... ;)
 If I got you right, after reinstalling LINKS as I advised you, you had a 'lil "less" problems... So, now to your NEWBorn problem! When you got that 'lil window with the password prompt, you thought that you were to enter your DataBase's PWD... Alas! You were wrong... :( I had just the same problem some time ago! So, the password it asks you for is the Informix ADMIN's password!!! Doesn't this sound a bit frastrating? :-| IMO, you'd better not use that INFORMIX... Use DBF (windows DBase) or DB (paradox DBases) formats! After testing Informix&others I came to an idea that DBF&DB are truly the best for "friendly" maintenance&use!
  If you still wish to use INFORMIX DataBases, ask me and I'll tell you how to override that nasty password prompt...

     Regards,
          [WizzarD].


0
 

Author Comment

by:macedo
ID: 1335048
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



 

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month6 days, 17 hours left to enroll

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question