[RBASE-L] - RE: File DSN problem

[Gunnar Ekblad]

Karen I have it working with both File and system DSN, But I know Razzak favours SYSTEM so I stick to that from now on..   My setup is like this on the network drive I have maybe 400 databases called GL (General Ledger) Each database is for different Clients. Since I do not want 400 DSN entrys on each workstation as a compromise each time a user exist a database I make local copy called ODBCGL on the localdrive. That way the last accessed database can always be read from Excel with ODBC. It not perfect but it works.   Be aware that 1.866 for ODBC you need the second 1.866 version if your running windows Gunnar     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: den 18 juni 2003 15:26 To: RBASE-L Mailing List Subject: [RBASE-L] - File DSN problem   At a client's yesterday, I wanted to set up a File DSN to a Win6.5++ database so that it can be accessed by Excel. Used the ODBC installation from the original RBase CD. I can set up a File DSN to a copy of the database located on her hard drive (comes into Excel without a problem), but creating an identical File DSN to the networked copy of the database produces this error when configuring the DSN:    "A connection could not be made using the file data source     parameters entered." Same database (just copied to the hard drive for the other File DSN).  They're running a legal multi-user installation. Tried it on another workstation and same thing -- it reads a local copy but cannot read a networked copy.  Is there something I missed? Karen