Yes, I can connect to other databases but not that one. There are no errors on the database and I can connect using the 6.5 odbc driver.
I think it might have something to do with the ansi setting. I have mine off on that particular database(cause I have a couple of column names that will not work with it on.). All the other settings look okay. What I found that is working is to use the 6.5 dsn to connect. Then I delete that dsn, create a 7.0 dsn with the same name, and then it works okay. Dan Goldberg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Emmitt Dove Sent: Sunday, July 11, 2004 9:24 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Access Violation error when attaching to aforeign data source Have you CONNECTed the other database with 7.x at all? Directly - not through a DSN? >I am having a problem attaching to another R:Base database. I am using a >system dsn with R:Base 7.0 database driver. > >When I try to attach to a table it gives me the error: > >Access violation at address 036F8873 in module 'RB70_32.DLL' Write of >address 565B6975 > >Then it gets really mad and I have to exit R:Base. > >If I use the 6.5 odbc driver it works okay but the 7.0 does not. I can use >the 7.0 with the concomp database and also have no problems. Since I could >not replicate this on the concomp database, I can not report it. > >Has anybody experienced this before?? If so, what was the cause?? > >Thanks > >Dan Goldberg >
