Razzak My best hero 01. I have checked the database using ODBC Administrator. 03. I use the latest and greatest even if I wonder do I need patch 5 before 7.0? 02. That is what I am trying to avoid, since I have maybe 200 identical (almost) databases (for different clients) I am looking for a dynamic entry (in Excel ) and in rbase; In rbase the syntax I am looking for is something like:
sconnect ODBC;DSN=Redovisning;DBQ=t:\db65\kontema\accounts\0055\GL.RB1;UID=;PW= Or 'ODBC;DSN=Redovisning;DBQ=t:\db65\kontema\accounts\0055\GL.RB1;UID=;PW=' Or "ODBC;DSN=Redovisning;DBQ=t:\db65\kontema\accounts\0055\GL.RB1;UID=;PW=" since I am still confused sometimes around no quotes double quote and single quote In 6.5++ dos I do sconnect t:\db65\kontema\accounts\0055\GL.RB1 But can not the same in win where 0055 in the string happens to be a client number that I in rbase programmatically want to control Some release back I was prompted in EXCEL for dsn entry and my user got used to change the client number in the dsn entry. But nowdays they can not, So for time being I have done a workaround that works but I am not happy about And I am still looking for a way out on this whithout having to learn VB since after COBOL SQL is the only language I want to need The old Dinosaur from Sweden Gunnar Ekblad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: den 18 mars 2003 16:50 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ODBC in XP - Razzak's Reply Gunnar, 01. Check the correct database name and the path associated with your System DSN using ODBC Administrator 02. If you would like to use different databases, you'll need to create a separate DSN for each different database with a different DSN name. 03. Using the latest version of R:BASE 6.5++ for Windows, and the updated R:BASE ODBC Driver bundled with the latest installers (Build:1.864xRT03) and higher, if your database has the Owner Password, it will prompt you for the ODBC Dialog, otherwise it will not. Hope that helps! Very Best Regards, Razzak. At 03:56 PM 3/18/2003 +0100, you wrote: >Hi again. > >I run XP and ODBC but I am 6.5++ 1.864 and it works fine so maybe the >solution is to upgrade to the latest > >But I can add a question: > >I run Excel (please forgive me) and do an ODBC- query to import data from >my RBASE. > >Previously when I refreshed my data I was asked with odbc-box to confirm >the database and add user name password (blank in my case) . > >Now I am not prompted any longer instead it uses previus database, which >sometimes is convenient but sometimes when I want to do the same query on >a different database it is not good at all. > >Has this behaviour anything to with version 1.864? > >I know I can start query in Excel and modify the query, but I have not >found where I can qualify the database. > >Can any one give me some light on this so I do not have to learn VB >scripting in excel > >Gunnar Ekblad
