Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[A. Razzak Memon]

Mike,

Both technical documents mentioned below, explains it all, including 
examples to get you going.


Keep in mind that you will be required to install the ODBC connector, 
such as OTERROXE on all
workstations in a LAN/Workstation setup, or on Server in a Cloud 
(RDWeb), or TS environments.


Yes, make sure to have fun!

Razzak


At 02:09 PM 7/25/2017, mike.rams...@aksteel.com wrote:

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" 
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/>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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[mike . ramsour]

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 
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 
To: rbase-l 
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"  
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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[karentellef via RBASE-L]

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 
To: rbase-l 
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 havingto connect to mulitple Acce$$ databases.  
It was neat bit of code.

I'm thinking the DSN-less method lendsitself to creating a command file that 
uses passed parameters.

I'm going to go have some fun.  Mightlose 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"
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, sendan 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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[mike . ramsour]

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" 
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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[A. Razzak Memon]

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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[Albert Berry]

I had occasion to need to connect to multiple Access .mdb databases. I wrote an 
RMD file to do it. You should be able to do the same. 

Albert 


> On Jul 25, 2017, at 11:17 AM, mike.rams...@aksteel.com wrote:
> 
> Good afternoon: 
> 
> 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? 
> 
> Here's a sample registry entry for one of my database: 
> 
> [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ANNL3120] 
> "Driver"="C:\\Windows\\system32\\RBG95_64.DLL" 
> "DBQ"="D:\\RBASE\\AUTOMATION\\ANNL3120.RX1" 
> "Description"="#2 AP data in R:BASE 9.5 format" 
> 
> The "Driver" reference and "Description" are the only things that need 
> changed I believe.  Everything else would stay the same. 
> 
> Would simply doing a search and replace in the Windows registry work or would 
> that be too dangerous? 
> 
> Thanks in advance for any sample scripts or suggestions. 
> 
> 
> Mike Ramsour 
> AK Steel Coshocton Works 
> Quality Department 
> Phone:  740-829-4340 
> Cell:  740-502-1659 
> 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.

RE: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[Dan Goldberg]

You don’t use dsnless connections? If you did there is nothing you need to do.

If not, you can change the registry on one, test it, and export the registry 
keys. Then import on the other machines.

Dan Goldberg

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
mike.rams...@aksteel.com
Sent: Tuesday, July 25, 2017 10:18 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

Good afternoon:

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?

Here's a sample registry entry for one of my database:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ANNL3120]
"Driver"="C:\\Windows\\system32\\RBG95_64.DLL"
"DBQ"="D:\\RBASE\\AUTOMATION\\ANNL3120.RX1"
"Description"="#2 AP data in R:BASE 9.5 format"

The "Driver" reference and "Description" are the only things that need changed 
I believe.  Everything else would stay the same.

Would simply doing a search and replace in the Windows registry work or would 
that be too dangerous?

Thanks in advance for any sample scripts or suggestions.


Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659
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<mailto: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.

[RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[mike . ramsour]

Good afternoon:

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?

Here's a sample registry entry for one of my database:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ANNL3120]
"Driver"="C:\\Windows\\system32\\RBG95_64.DLL"
"DBQ"="D:\\RBASE\\AUTOMATION\\ANNL3120.RX1"
"Description"="#2 AP data in R:BASE 9.5 format"

The "Driver" reference and "Description" are the only things that need 
changed I believe.  Everything else would stay the same.

Would simply doing a search and replace in the Windows registry work or 
would that be too dangerous?

Thanks in advance for any sample scripts or suggestions.


Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659

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.