Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Gagnon
  Where is Mike Gagnon?
 Pointe Claire
 Canada
 Mike Gagnon
 To: Alex Grima
  
 Malta
 
 Alex Grima
 Tags
Subject: RE: Connectivity Error SQL Connection
Thread ID: 288766 Message ID: 288822 # Views: 23 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Friday, December 24, 2010 12:41:25 PM         
   


> > I have a DBC with a connection to the SQL server. In the DBC is a view which I call on the SQL box and it downloads some records into the view so i can use them in Fox. I put it on the client's machine, created an ODBC connection in windows and all was well.
> >
> > They then wanted to give someone else the ability to run the program. I went through the same steps, created the exact ODBC connection on the computer but when they get to the line of code that access the view they get:
> >
> > Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denided on the object 'v_EbayOrders', database "MMM", schema 'dbo'.
> >
> > I checked to make sure the user had full rights to the folder the DBC is in and they do.
> >
> > Why can one computer successfully use the view and the other cannot?
> >
> > Thanks!
> >
> > Jill Lindgren
>
> Hi Jill,
>
> It seems to me that it is an SQL security problem.
>
> Did you check the security settings in MSSQL for the database you are accessing ?
> You can try authenticating using SQL Server authentication (rather than windows) with user sa and see if the problem goes away. If it does, it would confirm that it is a permissions problem.
>
> regards,
>
> Alex Grima
> Progressive Consulting & Information Systems Ltd
> http:\\<a target='_blank' href='http://www.progressive.com.mt/' rel='nofollow'>www.progressive.com.mt

Alex,
You may want to fix your signature. There is a least a closing tag "< / a >" missing.

Mike Gagnon
Refox XI +(English version)

ENTIRE THREAD

Connectivity Error SQL Connection Posted by Jill Lindgren @ 12/23/2010 8:55:46 PM
RE: Connectivity Error SQL Connection Posted by Alex Grima @ 12/23/2010 10:03:44 PM
RE: Connectivity Error SQL Connection Posted by Mike Gagnon @ 12/24/2010 12:41:25 PM
RE: Connectivity Error SQL Connection Posted by Cetin Basoz @ 12/24/2010 4:26:46 PM