Hello, help with connection string?

[swong]

Hello, I unfortunately do not speak French, so I hope my answer can still be resolved here

I want to connect to the Acomba database (full version, not demo) using the trial ODBC. I want to use a 3rd-party application to connect to the database using ODBC, but I don't know what the parameters for the connection string should be.

The documentation is in French, but I skimmed through it anyway, and couldn't find anything.

For example, something like:

Code:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

What “keys” does Acomba use? For example, the “keys” in the above example are: “Data Source”, “Initial Catalog”, “User Id”, and “Password”.

I haven’t been able to find any sample connection strings to connect to the Acomba database.

Any help would be great! Thanks in advance!

[PlanteG]

Hi,

my first suggestion is to read this other post on the forum. It is in French, regarding how to connect in PHP. Maybe you can get the essential from the thread.

My second suggestion is to create a DSN from the control panel icon or from within Acomba. This will tell you what is expected for a connection to Acomba. Once the DSN is created, you may refer to it in your code, and/or "browse" it in order to know how the connections should be constructed.

Hope that helps.

[swong]

hadt, thank you very much for your help!

That post does help, so I'll take in from what is in there. And your 2nd suggestion sounds like a great idea.

Thanks again!

[Contenu sponsorisé]