ODBC login
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: ODBC login

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm using MS Query to connect to an ODBC database (MAS90 for those who might know what this is) and I would like to know if I can program my macro to pass along the company, userid and password to the ODBC login so I don't have to enter this info everytime I want to run the app.

    [ This Message was edited by: 2077delta on 2002-03-26 11:42 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    You should be able to simply edit your connection string and then remove the prompt or login dialog?

    Tom



    [ This Message was edited by: TsTom on 2002-03-26 12:02 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Looks like the post i made has GONE!

    ermmmm
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry that last post went ????

    Poss linked incorrectly

    OK MAS90 is SAGE yes so will be cool in ODBC

    If ODBC is new drivers then login once will allow repeat access via ODBC on network without re enter PW.

    IF not speak with Administrater as poss old drivers in use or the way licence is set up. i couild be that must login each time.

    I recall the Script will allow for auto enter PW as refresh takes place.

    Does this help...

    BTW Of cause if needs by Sage helpLine will solve this and will be a part of the maintaince service package you have bought as MAS90 is current...

    Sage helpline is really very good in UK or so i have found, should be price yopu pay for software and stationary is aweful!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sorry that last post went ????

    Poss linked incorrectly

    OK MAS90 is SAGE yes so will be cool in ODBC

    If ODBC is new drivers then login once will allow repeat access via ODBC on network without re enter PW.

    IF not speak with Administrater as poss old drivers in use or the way licence is set up. i couild be that must login each time.

    I recall the Script will allow for auto enter PW as refresh takes place.

    Does this help...

    BTW Of cause if needs by Sage helpLine will solve this and will be a part of the maintaince service package you have bought as MAS90 is current...

    Sage helpline is really very good in UK or so i have found, should be price yopu pay for software and stationary is aweful!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com