Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2011
    Posts
    3

    Unanswered: Connec tot database using "Adaptive Server IQ 12" drivers

    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!

  2. #2
    Join Date
    Jan 2011
    Posts
    3

    Solved

    got answer thanks

  3. #3
    Join Date
    Feb 2011
    Posts
    5
    bso, please, could you put your solution here? I had the same problem and I have to use ASE instead.

  4. #4
    Join Date
    Jan 2011
    Posts
    3
    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?

  5. #5
    Join Date
    Feb 2011
    Posts
    5
    Well, no . What's the ODBC configuration? This is what fails to me.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •