active-x replication controls and slow link

Hi
Have a client who has a slow dialup connection. Synchronisation keeps
failing because of this.
I''m using the active-x controls. Are there any parameters/properties I can
set to tell it to hang on and be patient, and generally be more reliable ?
Thanks
Bruce
Bruce,
try increasing the logintimeout and querytimeout properties.
HTH,
Paul Ibison
sql

access-SQL ODBC link

> Hello,
> I am using trusted windows user connection to SQL
server.
> I created an ODBC link from Access to SQL server. I am
> able to modify data in tables through SQL Enterprise
> Manager however I am not able to modify them in Access.
> What is missing?You need to create a primary key or unique index on any SQLS tables
you want to modify from Access.
--mary
On Sat, 17 Apr 2004 13:34:26 -0700, "JIM.H."
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>server.|||Why do I have to do that? And if my primary key is based
on many columns will that cuse any problem?
>--Original Message--
>You need to create a primary key or unique index on any
SQLS tables
>you want to modify from Access.
>--mary
>On Sat, 17 Apr 2004 13:34:26 -0700, "JIM.H."
><anonymous@.discussions.microsoft.com> wrote:
>
Access.[vbcol=seagreen]
>.
>|||Why? because it won't work if you don't. Access can't locate the row
on the server, update it, and guarantee data integrity if the table
doesn't have a PK. If your PK is based on too many columns, then you
should consider a surrogate PK. A good starting point would be
"Database Design for Mere Mortals: A Hands-On Guide to Relational
Database Design" by Mike Hernandez.
--Mary
On Sun, 18 Apr 2004 17:58:46 -0700, "JIM.H."
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Why do I have to do that? And if my primary key is based
>on many columns will that cuse any problem?
>SQLS tables
>Access.

access-SQL ODBC link

> Hello,
> I am using trusted windows user connection to SQL
server.
> I created an ODBC link from Access to SQL server. I am
> able to modify data in tables through SQL Enterprise
> Manager however I am not able to modify them in Access.
> What is missing?
You need to create a primary key or unique index on any SQLS tables
you want to modify from Access.
--mary
On Sat, 17 Apr 2004 13:34:26 -0700, "JIM.H."
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>server.
|||Why do I have to do that? And if my primary key is based
on many columns will that cuse any problem?
>--Original Message--
>You need to create a primary key or unique index on any
SQLS tables[vbcol=seagreen]
>you want to modify from Access.
>--mary
>On Sat, 17 Apr 2004 13:34:26 -0700, "JIM.H."
><anonymous@.discussions.microsoft.com> wrote:
Access.
>.
>
|||Why? because it won't work if you don't. Access can't locate the row
on the server, update it, and guarantee data integrity if the table
doesn't have a PK. If your PK is based on too many columns, then you
should consider a surrogate PK. A good starting point would be
"Database Design for Mere Mortals: A Hands-On Guide to Relational
Database Design" by Mike Hernandez.
--Mary
On Sun, 18 Apr 2004 17:58:46 -0700, "JIM.H."
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Why do I have to do that? And if my primary key is based
>on many columns will that cuse any problem?
>SQLS tables
>Access.

Accessing Users & Members in Active Directory via Linked Server

Hi,

I'm trying to extract all the users and their membership to groups, and the membership of groups to groups from active directory though a link to server.

I can get the users. I can get the groups.... individually.

I can't get the info of what user is a member of or who are members of a group.

Anyone know how to do this or am I going to have to right a vb app? (Anyone already got the code...)

I want to load this data into tables for reporting in my Data Warehouse.

Cheers

Chris

Take a look at the following API:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/netmgmt/netmgmt/netgroupgetusers.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/netmgmt/netmgmt/netlocalgroupgetmembers.asp

Follow the links from the bottom of the articles for other related API.

Hope this helps.

Laurentiu

accessing two database in sql server 2k5 express

hi guys. can you please provide tutorial/link how to access two database in one view. i was thinking about LINK TABLE like what i do in ms access but i find solution in sql server.

thnx.

I hope u need to get the result of two table from two database . You can create a view with three part qualified name.

Create view yourviewname

as

Select *from Databasename1.owner.tablename where ......

Union /Join

Select *from Databasename2.owner.tablename where ......

basically you need to give fully qualifed tablename . The user accessing this view should have permission in both the dbs

Madhu

|||thanks. its up and running...

accessing reports securely through ASP

Hej
I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
I've created the reports and have been using a URL link in my ASP site to
ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
reports. When the reports are accessed outside the server, the browser
requires username and password. This isn't desired.
Whats the best way to handle this? If I switch to VS 2005 does the
ReportViewer control handle this? Is it possible/safe to change the user
rights for ReportViewer.aspx? Its important not to allow users access to the
Report Manager, but can the rights to viewing individual reports be handled
through there?
I appreciate any advise on the matter.On Mar 14, 2:27 pm, jknurek <jknu...@.discussions.microsoft.com> wrote:
> Hej
> I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
> I've created the reports and have been using a URL link in my ASP site to
> ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
> reports. When the reports are accessed outside the server, the browser
> requires username and password. This isn't desired.
> Whats the best way to handle this? If I switch to VS 2005 does the
> ReportViewer control handle this? Is it possible/safe to change the user
> rights for ReportViewer.aspx? Its important not to allow users access to the
> Report Manager, but can the rights to viewing individual reports be handled
> through there?
> I appreciate any advise on the matter.
I believe that there is a way to control (minimally) access to reports
in the Report Manager interface (check the top right-hand side of the
main page). Also you can control user access through the application
(as far as, not showing the user a link to the Report Server, etc).
Sometimes the login is required when the user accesses the Report
Server from Mozilla or Firefox (whereas, w/Internet WExplorer, it may
not happen). Also, you can check the Directory Security for the
Reports and Report Server Virtual Directories in IIS to check for
Windows Authentication, anonymous access, etc (via right-clicking My
Computer, select 'Manage' and go to Services and Applications ->
Internet Information Services -> Web Sites -> Default Web and right-
clicking the Reports or ReportServer Virtual Directory and selecting
Properties and the 'Directory Security' tab). Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer