[thelist] Access, Jet, ODBC and DSNLess connections

[Scott Dexter]

> -----Original Message-----
> From: Nicole Parrot [mailto:nicole at parrot.ca]

> 1. they need a better sysadmin ;-)

yep =)

> 2. the ODBC connection is the cause of the server becoming a sloth

depends on the details of the connection string, you got it so we can look
at?

> 3. switching to a FileDSN is helping with the slow server, 
> but the site can
> no longer be browsed by two persons. Could it be that the 
> FileDSN cannot be
> shared ? How do I fix that?

Should use a system DSN --you're right, a FileDSN can cause problems

> 4. I am now trying to go with a DSNLess connection, but it 
> seems the keyword
> "AS" is not recognised by the JET engine as a valid SQL word, 
> and that kills
> 90% of my already existing pages.

Let's see the SQL that breaks (Access2k should know 'AS' --its pretty
standard SQL)


--You don't have a connection or recordset object in a Session variable do
ya?


sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> Anyone with words of advice?
> Thank you
> 
> Nicole
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>