Chuck It might depend on the installer what the DSN-Less name should be. Mine was installed by 7.0 so my name in c:\Windows\ODBC.INI is: R:BASE 7.0 Database Driver (*.rb1) still even if the driver is the latest one. So that might be worth checking for!
Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: den 5 april 2005 08:33 To: RBG7-L Mailing List Subject: [RBG7-L] - Syntax for Sconnect to another RBase database Just when I get smug with my 'fine' RBase programming skills, another issue jumps up and hits me on the head! With help from you good folks, I have the Microsoft DSN-less connection working just fine. When I try to use scconect to another RBase database I get the 'Data Source Not found and No default driver specified' (thanks for the descriptive error codes 'Bill'). Both Databases reside in the same directory (E:/SKJII). The database I want is called 'Leads'. If I attach using the DSN it works fine. Here is my code: (We use " instead of ') SCONNECT ";driver=R:BASE 7.1 Database Driver (*.rb1);dbq=e:/skjii/Leads" How much more idiot-proof can you get than copping sample code and changing the path and filename? Do any of you smart people have an idea of what I am doing wrong? P.S. this is the third time I typed this because it was pointed out to me that I was using rich text and not everyone could read my posts. Now if I had only known that the 'Notes' spell checker would blow out the whole document because it didn't like the other /. Third time is a charm!
