Access connect to database Informix

[Kleverson]

Hi,

I have a report that I export from Access to Excel. Before I do that I need to generate a query in Access that have a connection with an Informix database. When I ask to run the query a pop up ask for login/password.
How can I automate this?
Or how can I create a string connection so when I run the query the connection with the server is already stabilish?

Thank you!

Kleverson

 

[bobhc]

Can you give the forum the answers you received from the Access forums you have posted this question on.

 

[Kleverson]

Hi bobhc,

I'll do that as soon as I have a reply.

Att,

 

[David Evans]

Hi,

I have a report that I export from Access to Excel. Before I do that I need to generate a query in Access that have a connection with an Informix database. When I ask to run the query a pop up ask for login/password.
How can I automate this?
Or how can I create a string connection so when I run the query the connection with the server is already stabilish?

Thank you!

Kleverson

Have you been able to identify your connection string; if so, it will give you some clues as to how to automate it, if my memory serves me correctly.

It should look something like this

Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\mydb.mdb;Jet OLEDB:DatabasePassword=password;

 

[Kleverson]

Hi David,

I tried this:

Private Sub testConection()
Dim cn As New ADODB.Connection

DoCmd.SetWarnings False


Set cn = New ADODB.Connection


cn.ConnectionString = "DRIVER={OpenLink Generic 32 Bit Driver v4.0};DNS=CMS;_ServerType=Informix 2000;Host=10.187.0.24;Port=5000;Database=;FetchBufferSize=30;NoLoginBox=No;Protocol=TCP/IP;ReadOnly=No;ServerOptions=;DeferLongFetch=Yes;TABLE=root_hsplit;Uid=***user***;PASSWORD=***password***"
cn.Open

DoCmd.OpenQuery "01 - Criar base skill", acViewNormal, acRead

cn.Close

End Sub

The Access file open without password, the password is asked when I call the query.

Thanks for the reply!