R:azzak, First, thank you for the information.
>>> 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. <<< I had been working on this application for several weeks, and I had posted a couple of questions to the List in this regard. The other application (Fuel Management System) is/was based on an Access database and last week the vendor talked them into upgrading to the MS SQL Server Express version. I already had designed and tested the whole interface and data interchange based on the Access database and was ready to go live this Monday. Fortunately, the only change needed is modifying the "SCONNECT" command; everything else should be exactly the same (Thanks R:Base!!!) As I run a compiled application, I needed to figure out the DNS-less command; this is why I was trying to determine what the parameters for the SCONNECT command were. Are you planning a class in Kansas City any time soon? You know we have the best Barbeque in the land... Again, thanks for the pointers; I will have a busy weekend. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, April 08, 2011 7:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help accessing a MS SQL database 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. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
