Razzak,
I hope I've not misled you but when my system re-booted this morning after
the latest updates were installed from Microsoft I noticed that I should
have said "Vista Home BASIC" and not "standard" - please accept my apologies
for this error on my part.
Regards,
Alastair.
----- Original Message -----
From: "Alastair Burr" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, October 29, 2008 12:15 AM
Subject: [RBASE-L] - Re: Using DSN-Less Connection (was Re: Import & Export
note field)
Thanks for your response, Razzak.
I'll give you the answers to your questions quickly and then digest your
solutions in due course:
1) 32 bit
2) RB76_32.DLL & RB76_INS.DLL:
both indicate created 14/11/2007 08:31 & modified 19/09/2008 06:56
version 7.6.7.30919 (in C:\Windows\System32 only).
3) Assuming you mean the only the R:Base bit:
APILevel - 2
Connectfunctions - YYY
Driver - C:\Windows\System32\RB76_32.DLL
DriverODBCVer - 03.00
FileExtns - *.rb1
FileUsage - 2
Setup - C:\Windows\System32\RB76_INS.DLL
SQLLevel - 1
UsageCount - 1
Also in the "ODBC Drivers" the R:Base Database Driver is shown as
"Installed"
Thanks & regards,
Alastair.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, October 28, 2008 10:34 PM
Subject: [RBASE-L] - Using DSN-Less Connection (was Re: Import & Export
note
field)
At 04:45 PM 10/28/2008, Alastair Burr wrote:
In v7.6 I get the following error message with this command:
SCONNECT ';Driver=R:BASE 7.6 Database Driver
(*.rb1);dbq=d:\dbfiles\general\general'
Error message from server:
Specified driver could not be loaded due to system error 126 +
(R:BASE 7.6 Database Driver (*.rb1)).
In my ODBC Data Source Administrator applet (Vista Home Standard) the
only entry for R:Base is on the Drivers' tab where it shows the version
as 7.06.04.30919.
I assume that it is here that I have done or not done something as I
should have.
Good evening Alastair,
A few questions and then a detailed explanation if running R:BASE on
64-bit OS.
01. Is your Vista Home Standard a 32-bit or 64-bit system?
02. What is the date and time of following files in \Windows\Systems32
folder?
. RB76_32.DLL
. RB76_INS.DLL
Use the right-click | properties for more detailed information
03. What items are listed under ODBCINST.INI section of ODBC tab under
registry?
Start|Run|RegEdit|HKEY_LOCAL_MACHINE|SOFTWARE|ODBC|ODBCINST.INI
Now, if you are running R:BASE 7.6 for Windows on Vista 64, you may need
to tweak the registry settings for Vista 64 to recognize R:BASE 7.6 ODBC
settings and installed drivers.
Typically, using the full installer, after a successful installation
of R:BASE 7.6, you would expect the R:BASE ODBC drives to be listed
under the Drivers for ODBC Data Source Administrator panel. Well, by
default, on Windows XP 64, Vista 64 and Windows Server 2003 R2 x 64
with Service Pack 2 machines, the installed ODBC Drivers list is empty.
There are no drivers listed even for Microsoft's own default drivers
(can you believe that?).
Figure 01
http://www.rbase.com/rbg76/ODBC/ODBCDataSourceAdministrator01.jpg
The reason the installed drivers are not listed is the way Windowsx64
editions operate with the ODBC drivers. On Windows x64 editions, all
ODBC drivers are installed in the "%SystemRoot%\SysWOW64" folder.
However, the default ODBC Data Source Administrator that is available
through the Administrative Tools or Control Panel in Windows x64
Editions is located in the "%SystemRoot%\system32" folder, and only
searches this folder for ODBC drivers.
To fix this behavior on Windows x64 editions, you should update the
target information for shortcut properties of the ODBC Data Source
Administrator tool to reflect "%SystemRoot%\SysWOW64\odbcad32.exe".
This will correctly locate and list all installed ODBC drivers as
well as enable you to create a System DSN or should be recognized
when using the DSN-Less connection.
Figure 02 (Default Properties for ODBC Data Source Administrator)
http://www.rbase.com/rbg76/ODBC/ODBCDataSourceAdministrator02.jpg
Figure 03 (Modified Properties for ODBC Data Source Administrator)
http://www.rbase.com/rbg76/ODBC/ODBCDataSourceAdministrator03.jpg
Figure 04 (Installed ODBC Drivers on Server 2003 R2x64 SP2 machines)
http://www.rbase.com/rbg76/ODBC/ODBCDataSourceAdministrator04.jpg
Have fun running R:BASE 7.6, R:BASE Turbo V-8, and Oterro 3.5,
4.0, or 8.0 on Windows XP 64, Vista 64 and Windows Server 2003
R2 x64 with Service Pack 2 operating systems!
Hope that gives you some blue's clues ...
Very Best R:egards,
Razzak.
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.4/1752 - Release Date: 28/10/2008
10:04
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.4/1752 - Release Date: 28/10/2008
10:04
--- 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.
================================================
