Hello All,

I am trying to connect to a database using the Adaptive Server IQ 12 drivers through VBA. I have connected through a package called WinSQL but can't seem to connect though VBA.

Through the WinSQL connection I had the following fields:

Host, Server, DB, Port.

Can anyone help? What is the format of the connection string?

I'm not particularly an IT guy, so please keep the answer in simple language pls!

got answer thanks

bso, please, could you put your solution here? I had the same problem and I have to use ASE instead.

It was quite easy in the end. Just set up the connection in the ODBC Data Source and then used this connection string:

"DSN=Data_Source_Name;DatabaseName=Name;UID=myuid; PWD=mypass;"

What I was getting wrong was failure to insert the "Data Source Name" from the ODBC Data Source manager in there

Does that help?

Well, no . What's the ODBC configuration? This is what fails to me.