Results 1 to 7 of 7

Thread: ODBC (2000)

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC (2000)

    Hi,

    I have a Access database and I have to do monthly download some data from our SQL server by using ODBC connection. I have to enter the User name and Password in Microsoft SQL Server Login screen when I try to download the data.

    I am wondering if there's a way to either put the User name and password inside the code or some way to avoid the login screen every time.

    Thanks

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ODBC (2000)

    Do you already have code to connect to the SQL Server database? If so, what does it look like? (Replace the real name of the server etc. by dummy names)

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC (2000)

    Hi Hans,

    Currently I don't have any code to connect to the SQL database. I am manually enter the user name & password.

    Thanks

    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ODBC (2000)

    See for example the thread starting at <post:=139,315>post 139,315</post:>.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC (2000)

    Hi Hans,

    Thank you for all your help.

    I did look at the example the thread at post 139927 and I have the following questions for ODBC;DSN=MyDSN;Description=MyDSN;UID=MyUser;PWD=My PWD;DATABASE=MyDB;AutoTranslate=No;TABLE=tblAnyTab le:

    1) DATABASE = The name of the local access database?
    2) tblAnyTable = any table in the local access database?

    Thanks

    Regards

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ODBC (2000)

    No, the names of the SQL Server database and table.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC (2000)

    Thanks, Hans.

Posting Permissions

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