[mapguide-users] Pulling up Database resouces in Studio

[Dave Wilson]

Sorry for any confusion.
 
The Access database should be on the server for the best performance. If
you are uploading it from Studio and using a connection string rather
than a DSN it will reside on the server. Personally I would set up using
a DSN on the server and keep the database in a local data folder
somewhere. Trying to access an Access database across a network involves
getting permissions and user rights correct which can be annoying to
resolve.
 
Studio can be on any machine. 
 
Dave

  _____  

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 10:01 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio



Dave:

 

Thanks for the response.   So you think it's best to run Studio directly
on the server?   Yeah, I'm going through a proxy on my laptop.  I don't
go through one on my PC, so I'll give this a try and see if it speeds
things up.

 

Thanks.

 

- Juan

 

  _____  

From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Tuesday, June 20, 2006 11:59 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

 

In general an Access database works VERY fast when it is stored locally,
remotely it's much slower. If you are on an external server do you have
a firewall and/or proxy server to contend with? This will also slow
things down.

 

Dave

 

  _____  

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 9:44 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] Pulling up Database resouces in Studio

I've moved my MGOS stuff to our external server and when trying to pull
up my Access database resources in Studio, it takes a very, very, long
time.  I'm just trying to make sure the connections are valid and
working.    Is anyone else experiencing this?   It's fine when I do
everything local.   Is this a known issue when trying to connect to a
remote server?    

 

FYI.  Using IIS/.NET implementation.

 

- Juan

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20060620/4f7740d3/attachment.html