At 05:47 PM 4/8/2011, Javier Valencia wrote:
R:azzak,
I just need information on how to connect to a MS SQL database.
Is there a write-up somewhere with instruction on how to do this?
Is there a way to get just the "Integrating RBASE with ODBC
Compliant Databases" application from the SAT package? I need
to resolve this issue by Monday, since they are planning to
bring the other application by that date.
Thanks in advance for your help.
Javier,
Wow! You need to resolve this issue (BTW who's issue is that?)
by Monday and you are just starting now? <g>
You should have come and joined me a week ago. I would have shown
you how to do this (hands-on) and create an R:BASE eXtreme 9.1 (64)
application that manages MS SQL Server 2008 R2.
Note:
The latest enhancements in R:BASE eXtreme 9.1 (64) are a result
of such first-hand experience and customer requests.
In any case ...
Setting up a connection from R:BASE eXtreme 9.1 to MS SQL Server
is fairly easy, using the command prompt or built-in utilities.
Once the database systems are in place (R:BASE eXtreme 9.1 (64)
and MS SQL Server for this example), it becomes a fairly simple
matter (well, almost).
Keeping the MS SQL Server defined DSN (Data Source Name) and
User Permissions in mind, for your own learning purpose, try
the simple approach first.
Here's how:
First things first. Make sure that you are using the latest update
and build of R:BASE eXtreme 9.1 (64). http://www.rupdates.com/
01. Start R:BASE eXtreme 9.1 (64) - Build: 9.1.2.10317 or higher
(I am using 9.1.3.10408)
02. First CONNECT to your R:BASE database
03. CONNECT to SQL Data Source
Database Explorer | Main Menu | Utilities ...
Select "Connect SQL Data Source ..."
Click on [Machine Data Source]
Click on appropriate Data Source Name
Enter User Name and Password, when prompted.
04. Attach SQL Database Table(s)
Database Explorer | Main Menu | Utilities ...
Select "Attach SQL Database Table ..."
Highlight appropriate table from the list of "Tables" and
click on [Attach] button.
You may attach this table as "Alias" and/or "Temporary".
Make sure to click on appropriate CheckBox prior to clicking
on [Attach] button if you wish to attach the table as "Alias"
and/or "Temporary".
Checking the "Alias" box will prompt for Alias Name.
05. Once all tables are attached successfully, click on [Close]
button to close Attach Table(s) window.
06. While in Database Explorer | Tables ...
Notice the SATTACHed tables with a slightly different icon
with "SERVER" for column labeled as "Rows".
Double-Clicking on the appropriate server table will open
Data Browser/Editor.
07. You may turn these SATTACHed server table(s) as native R:BASE
table(s) by using the Copy option from the Database Explorer
or using the PROJECT command at the R> prompt.
08. Now you may design Forms, Reports, Labels, and more ... based
on these server table(s), just like you would do anything with
R:BASE tables.
09. You may automate the whole process using the SCONNECT and
SATTACH commands.
For complete details, please type the following at the R>:
HELP SCONNECT
HELP SATTACH
HELP SDETACH
HELP SDISCONNECT
That is your quick 5 minute tutorial and step-by-step instructions
to get started.
Good luck!
Very Best R:egards,
Razzak.
P.S.
Nothing is impossible when you are using the right tools, such as
R:BASE eXtreme 9.1 (64). Thanks to R:BASE Technologies, Inc., for
designing great products to provide us all with such opportunities!
P.P.S.
R:BASE eXtreme 9.1 (64) is the only R:BASE version that supports
and smoothly interacts with MS SQL Server and Oracle supporting
BIGNUM and BSTR data types.
