Creating ODBC Data Source automatically?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jozef
    #1

    Creating ODBC Data Source automatically?

    Hello,

    Is there any way to automatically create an ODBC data source if it doesn't
    already exist?

    I'd like to deploy this program on workstations that I may not have access
    to, and don't want to rely on the user for any technical expertise. Is
    there any way to do that?

    Thanks!


    Tags: None
    • polite person
      #2
      Re: Creating ODBC Data Source automatically?

      How To Create and Remove a DSN in Visual Basic
      Error - Office.com - Microsoft Support
      http://support.microsoft.com/kb/q171146/



        Comment

        • Steve Jorgensen
          #3
          Re: Creating ODBC Data Source automatically?

          On Tue, 30 Aug 2005 14:34:34 GMT, "Jozef" <SPAM_O_NATOR@t elus.net> wrote:
          [color=blue]
          >Hello,
          >
          >Is there any way to automatically create an ODBC data source if it doesn't
          >already exist?
          >
          >I'd like to deploy this program on workstations that I may not have access
          >to, and don't want to rely on the user for any technical expertise. Is
          >there any way to do that?
          >
          >Thanks!
          >[/color]

          Although you can do that, perhaps, you should use DSNless connections instead.

            Comment

            • Salad
              #4
              Re: Creating ODBC Data Source automatically?

              Steve Jorgensen wrote:
              [color=blue]
              > On Tue, 30 Aug 2005 14:34:34 GMT, "Jozef" <SPAM_O_NATOR@t elus.net> wrote:
              >
              >[color=green]
              >>Hello,
              >>
              >>Is there any way to automatically create an ODBC data source if it doesn't
              >>already exist?
              >>
              >>I'd like to deploy this program on workstations that I may not have access
              >>to, and don't want to rely on the user for any technical expertise. Is
              >>there any way to do that?
              >>
              >>Thanks!
              >>[/color]
              >
              >
              > Although you can do that, perhaps, you should use DSNless connections instead.[/color]

              Can you describe a DSNless connection, Steve? Is that still ODBC? I
              ask because I have a Foxpro DOS table that is SLOW, SLOW, SLOWER than
              mollasses if I attempt to link to it via ODBC. In fact, I gave up on
              ODBC and FoxPro DOS because it was so terrible. I would have thought
              since FoxPro was a MS product, MS could make some of their products work
              together....esp ecially a simple database like FoxPro.

                Comment

                • pietlinden@hotmail.com
                  #5
                  Re: Creating ODBC Data Source automatically?

                  Salad,
                  Carl Prothman has examples of just about every connection string
                  (DSN-less too) that you can think of. And if one's missing, you could
                  probably e-mail him...
                  https://www.able-consulting.com

                  there's a whole section on connection strings. a BIG one.

                    Comment

                    • Steve Jorgensen
                      #6
                      Re: Creating ODBC Data Source automatically?

                      On Tue, 30 Aug 2005 16:28:04 GMT, Salad <oil@vinegar.co m> wrote:
                      [color=blue]
                      >Steve Jorgensen wrote:
                      >[color=green]
                      >> On Tue, 30 Aug 2005 14:34:34 GMT, "Jozef" <SPAM_O_NATOR@t elus.net> wrote:
                      >>
                      >>[color=darkred]
                      >>>Hello,
                      >>>
                      >>>Is there any way to automatically create an ODBC data source if it doesn't
                      >>>already exist?
                      >>>
                      >>>I'd like to deploy this program on workstations that I may not have access
                      >>>to, and don't want to rely on the user for any technical expertise. Is
                      >>>there any way to do that?
                      >>>
                      >>>Thanks!
                      >>>[/color]
                      >>
                      >>
                      >> Although you can do that, perhaps, you should use DSNless connections instead.[/color]
                      >
                      >Can you describe a DSNless connection, Steve? Is that still ODBC? I
                      >ask because I have a Foxpro DOS table that is SLOW, SLOW, SLOWER than
                      >mollasses if I attempt to link to it via ODBC. In fact, I gave up on
                      >ODBC and FoxPro DOS because it was so terrible. I would have thought
                      >since FoxPro was a MS product, MS could make some of their products work
                      >together....es pecially a simple database like FoxPro.[/color]

                      All a DSNless connectino means is that you use a conneciton string that
                      includes all teh options explicitly in the string rather than storing them in
                      a DSN, and referencing the DSN. You're still using the same libraries and
                      layers, so unfortunately this will not help with your performance issue at
                      all.

                        Comment

                        • Salad
                          #7
                          Re: Creating ODBC Data Source automatically?

                          Steve Jorgensen wrote:
                          [color=blue]
                          > On Tue, 30 Aug 2005 16:28:04 GMT, Salad <oil@vinegar.co m> wrote:
                          >
                          >[color=green]
                          >>Steve Jorgensen wrote:
                          >>
                          >>[color=darkred]
                          >>>On Tue, 30 Aug 2005 14:34:34 GMT, "Jozef" <SPAM_O_NATOR@t elus.net> wrote:
                          >>>
                          >>>
                          >>>
                          >>>>Hello,
                          >>>>
                          >>>>Is there any way to automatically create an ODBC data source if it doesn't
                          >>>>already exist?
                          >>>>
                          >>>>I'd like to deploy this program on workstations that I may not have access
                          >>>>to, and don't want to rely on the user for any technical expertise. Is
                          >>>>there any way to do that?
                          >>>>
                          >>>>Thanks!
                          >>>>
                          >>>
                          >>>
                          >>>Although you can do that, perhaps, you should use DSNless connections instead.[/color]
                          >>
                          >>Can you describe a DSNless connection, Steve? Is that still ODBC? I
                          >>ask because I have a Foxpro DOS table that is SLOW, SLOW, SLOWER than
                          >>mollasses if I attempt to link to it via ODBC. In fact, I gave up on
                          >>ODBC and FoxPro DOS because it was so terrible. I would have thought
                          >>since FoxPro was a MS product, MS could make some of their products work
                          >>together....e specially a simple database like FoxPro.[/color]
                          >
                          >
                          > All a DSNless connectino means is that you use a conneciton string that
                          > includes all teh options explicitly in the string rather than storing them in
                          > a DSN, and referencing the DSN. You're still using the same libraries and
                          > layers, so unfortunately this will not help with your performance issue at
                          > all.[/color]

                          Gotcha.

                            Comment

                            Previous template Next
                            Working...