informix connection

[rippa]

Hi everybody,

I would like to connect to an informix db. I've installed an informix odbc connect driver and configured a dsn entry, but I don't know how to connect to this db. I've read that this is possible with connection strings, but is there not an easier way using the dsn entry ?

Thanks !

[ptrex]

@rippa

Something like this :

; Informix

$objConn = ObjCreate("ADODB.Connection")

$objConn.Open ("Dsn=myDsn;" & _
           "Host=myHostname;" & _
           "Server=myServerName;" & _
           "Service=myServiceName;" & _
           "Protocol=onsoctcp;" & _
           "Database=myDbName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword")

$rsCustomers = $objConn.Execute("SELECT * FROM Customers")
With $rsCustomers
    While Not .EOF
        ConsoleWrite(.Fields("CustomerID").Value & " - " & .Fields("CompanyName").Value & @LF)
        .MoveNext
    WEnd
    .Close
EndWith

$objConn.Close

regards

ptrex

Edited October 14, 2007 by ptrex

[DonChunior]

Has anybody ever managed to connect to a Informix database with AutoIt?

I configured a User-DSN with the ODBC Data Source admin tool and tried following code:

$objConn = ObjCreate("ADODB.Connection")

$objConn.Open("Dsn=Informixtest;" & _
    "Host=myHost;" & _
    "Server=myServer;" & _
    "Service=myService;" & _
    "Protocol=onsoctcp;" & _
    "Database=myDatabase;" & _
    "Uid=myUsername;" & _
    "Pwd=myPassword")

$objConn.Close

But SciTE shows following error:

informixtest.au3" (3) : ==> The requested action with this object has failed.:
$objConn.Open("Dsn=Informixtest;" & "Host=myHost;" & "Server=myServer;" & "Service=myService;" & "Protocol=onsoctcp;" & "Database=myDatabase;" & "Uid=myUsername;" & "Pwd=myPassword")
$objConn^ ERROR

[mLipok]

try my ADO.au3 UDF  

edit:

and do not forget to use COM ErrorHandler

Here is example:

 

Edited November 16, 2018 by mLipok

[mLipok]

I think you have problem with connection string.

Did you read this examples:
https://www.connectionstrings.com/informix/

?

[DonChunior]

On ‎16‎.‎11‎.‎2018 at 9:32 AM, mLipok said:

try my ADO.au3 UDF

Actually, I was able to connect the database with your ADO.au3 UDF!