Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Calendar
  New Posts New Posts RSS Feed - Connection
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Connection

 Post Reply Post Reply
Author
Message
rgracie View Drop Down
Groupie
Groupie


Joined: 12 November 2006
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote rgracie Quote  Post ReplyReply Direct Link To This Post Topic: Connection
    Posted: 18 November 2006 at 7:48pm
From within MS Access 2002
Front End / Back End Design
User Level Security Active Through non system .mdw "SXPDEVSECV3.mdw"

How does one connect the data provider?

I have tried

Application.ADOConnectString
CurrentDb.Name

The odd thing is that even if I enter the wrong connection string in the Access container that works,

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Program Files\ServiceXp\servicexpv3.mdb;PERSIST SECURITY INFO=FALSE;Jet OLEDB:System database=C:\Program Files\ServiceXp\SXPDEVSECV3.mdw

it still finds the correctly linked tables in..

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Documents and Settings\Robert\Desktop\AccessSample.mdb;PERSIST SECURITY INFO=FALSE;Jet OLEDB:System database=C:\Documents and Settings\Robert\Application Data\Microsoft\Access\System.mdw

?????

Robert

Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2006 at 2:25pm
Hi,

Have you looked into Calendar Access sample? ToolkitPro\Samples\ActiveX\Calendar\Access\AccessSample.mdb

It connects using:

Me.CalendarControl1.SetDataProvider Application.ADOConnectString


--
WBR,
Serge
Back to Top
rgracie View Drop Down
Groupie
Groupie


Joined: 12 November 2006
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote rgracie Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2006 at 2:28pm
Indeed, but it does not work when I use it in a user secured setup..

Robert
Back to Top
rgracie View Drop Down
Groupie
Groupie


Joined: 12 November 2006
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote rgracie Quote  Post ReplyReply Direct Link To This Post Posted: 19 November 2006 at 3:03pm

I'm not sure how the control is interpreting the string that is passed, but it must be relying on the default system.mdw security file and permissions ??


Is there an error object somewhere hidden, as I don’t see any.

 

I tested this control fairly well (actually built 95% of my equipments)  in the default sample container, even splitting the table out from the container. I would have never guessed that security would be the problem that it has become…

 

I hope we can find a resolution quickly, as I’m due to release first week on Dec.

 
Thanks

Robert

Back to Top
rgracie View Drop Down
Groupie
Groupie


Joined: 12 November 2006
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote rgracie Quote  Post ReplyReply Direct Link To This Post Posted: 21 November 2006 at 8:12pm
Can someone post an example of a working connection string used to make connection to a user secured MS Access database, that includes username and password?

Robert
Back to Top
rgracie View Drop Down
Groupie
Groupie


Joined: 12 November 2006
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote rgracie Quote  Post ReplyReply Direct Link To This Post Posted: 25 November 2006 at 9:55am
For those who may need to connect to a user secured Access db, here is the correct connection string to allow for this...

Special Thanks To Sergey in Technical..

";User ID=xxx;Password=yyy;"

.SetDataProvider CStr(Application.ADOConnectString + ";User ID=administrator;Password=adminpassword;")

OR 

 .SetDataProvider CStr(Application.ADOConnectString & ";User ID=administrator;Password=adminpassword;")

Robert


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.141 seconds.