Thanks for the example, Karen. I'm anxious to get to the task. Your example got me a little more stoked.
Thanks again. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: karentellef via RBASE-L <rbase-l@googlegroups.com> To: rbase-l@googlegroups.com, Date: 07/25/2017 02:18 PM Subject: Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries Do you have an example of the code? This is a simple statement to connect to another RBase database. SCONNECT ';driver=Oterro X Enterprise Database Driver (*.RX1);dbq=x:\freight' The last example I had of an Acce$$ command was this, but it's old: SCONNECT';driver=Microsoft Access Driver (*.mdb);dbq=T:\consult.mdb' And yeah, just create variables and concatenate into the sconnect string and then do an &vCommand to run the statement. Karen -----Original Message----- From: mike.ramsour <mike.rams...@aksteel.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Tue, Jul 25, 2017 1:09 pm Subject: Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries Thank you, Razzak, and others that responded. I will pursue the DSN-less route. I have used this technique when having to connect to mulitple Acce$$ databases. It was neat bit of code. I'm thinking the DSN-less method lends itself to creating a command file that uses passed parameters. I'm going to go have some fun. Might lose a sock or two in the process :-) Have a wonderful afternoon everyone! Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: "A. Razzak Memon" <raz...@rbase.com> To: rbase-l@googlegroups.com, Date: 07/25/2017 01:55 PM Subject: Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries Sent by: rbase-l@googlegroups.com Mike, Did you know that you can achieve your goal by using the DSN-Less connection(s)? For complete details and examples, take a close look at the technical articles on From The Edge ... >From The Edge: http://www.razzak.com/fte/ Article Title: 01. Using SQL Data Sources in R:BASE X and R:BASE X Enterprise (Version 10) 06/06/2017 02. Using DSN-Less Connections in R:BASE X Enterprise (Version 10) 05/10/2016 Have fun! Very Best R:egards, Razzak At 01:17 PM 7/25/2017, mike.rams...@aksteel.com wrote: >I'm about to make the upgrade to R:BASE X Enterprise and need to >create a couple of dozen ODBC data sources using the ODBC driver for >R:BASE X Enterprise. > >Essentially the question is what's the easiest way to do >this? Having to manually create that many new entries will be >pretty time-consuming. > >Can this be done with a script? -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
