John Simmer
|
Posted: 10/15/2003, 12:28 PM |
|
If anyone can help me with this one I would be most appreciative. I run
WinXP Pro. The first symptom is when accessing a database within CCS such as
when reviewing data from an sql query, my hard disk churns forever before
turning up a result. And then when I try to preview a page in any
programming language I get an error message such as this one generated by a
PHP page:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not use
'(unknown)'; file already in use., SQL state S1000 in SQLConnect in
c:\inetpub\wwwroot\CFDOCS\MyFusion\CODEcharge\mnfathPHPdt1\db_odbc.php on
line 52
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
NOTE: if I select preview live in browser I get the same error message, but
if I quit CCS then refresh the browser page it works. Consequently the only
way I can preview any work is to send a page to my browser, then close CCS
and refresh the page. This makes development extremely difficult.
I have already tried the CCS tip in changing security settings and that does
nothing to solve this problem. This problem occurs on my laptop with WinXP
Pro, fortunately, I can also develop CCS applications at home on my Win2k
computer which has none of these problems.
Thank you in advance for any insight you may be able to offer.
|
|
|
DonB
|
Posted: 10/15/2003, 4:07 PM |
|
If you are not using the OLEDB provider for Access but reather the ODBC
Driver, then try OLEDB. I have found it worked better for my apps.
The "churning" is reminiscent of my having turned on the ODBC driver-level
logging to a disk file once upon a time. This may be the explanation for
that. It might even be the file that's "already in use" Look for a
(probably very large) ODBC.LOG on your C drive.
Then again, it may be as simple as the application demanding a lock that it
can't obtain, hence the fact it seems to work after you close the CCS IDE.
Does the Access database have any linked tables - to another Access
database, especially?
--
DonB
http://www.gotodon.com/ccbth
"John Simmer" <info@webatisan.biz> wrote in message
news:bmk747$sl6$1@news.codecharge.com...
> If anyone can help me with this one I would be most appreciative. I run
> WinXP Pro. The first symptom is when accessing a database within CCS such
as
> when reviewing data from an sql query, my hard disk churns forever before
> turning up a result. And then when I try to preview a page in any
> programming language I get an error message such as this one generated by
a
> PHP page:
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
use
> '(unknown)'; file already in use., SQL state S1000 in SQLConnect in
> c:\inetpub\wwwroot\CFDOCS\MyFusion\CODEcharge\mnfathPHPdt1\db_odbc.php on
> line 52
> Database error: Link-ID == false, odbc_pconnect failed
> ODBC Error: 0 ()
> Session halted.
>
> NOTE: if I select preview live in browser I get the same error message,
but
> if I quit CCS then refresh the browser page it works. Consequently the
only
> way I can preview any work is to send a page to my browser, then close CCS
> and refresh the page. This makes development extremely difficult.
>
> I have already tried the CCS tip in changing security settings and that
does
> nothing to solve this problem. This problem occurs on my laptop with WinXP
> Pro, fortunately, I can also develop CCS applications at home on my Win2k
> computer which has none of these problems.
>
> Thank you in advance for any insight you may be able to offer.
>
>
|
|
|
DonB
|
Posted: 10/16/2003, 6:33 AM |
|
Hmmm, I wonder if there was something changed in V2.2 of CCS? I noticed
that if I opened CCS first, then the database - that the database opens
read-only. CCS apparently took a lock on the database when it opened my
project. This is NOT the behavior I saw with previous versions.
I think this is what you've experienced, John.
--
DonB
http://www.gotodon.com/ccbth
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bmkjuk$m63$1@news.codecharge.com...
> If you are not using the OLEDB provider for Access but reather the ODBC
> Driver, then try OLEDB. I have found it worked better for my apps.
>
> The "churning" is reminiscent of my having turned on the ODBC driver-level
> logging to a disk file once upon a time. This may be the explanation for
> that. It might even be the file that's "already in use" Look for a
> (probably very large) ODBC.LOG on your C drive.
>
> Then again, it may be as simple as the application demanding a lock that
it
> can't obtain, hence the fact it seems to work after you close the CCS IDE.
> Does the Access database have any linked tables - to another Access
> database, especially?
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "John Simmer" <info@webatisan.biz> wrote in message
>news:bmk747$sl6$1@news.codecharge.com...
> > If anyone can help me with this one I would be most appreciative. I run
> > WinXP Pro. The first symptom is when accessing a database within CCS
such
> as
> > when reviewing data from an sql query, my hard disk churns forever
before
> > turning up a result. And then when I try to preview a page in any
> > programming language I get an error message such as this one generated
by
> a
> > PHP page:
> >
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
> use
> > '(unknown)'; file already in use., SQL state S1000 in SQLConnect in
> > c:\inetpub\wwwroot\CFDOCS\MyFusion\CODEcharge\mnfathPHPdt1\db_odbc.php
on
> > line 52
> > Database error: Link-ID == false, odbc_pconnect failed
> > ODBC Error: 0 ()
> > Session halted.
> >
> > NOTE: if I select preview live in browser I get the same error message,
> but
> > if I quit CCS then refresh the browser page it works. Consequently the
> only
> > way I can preview any work is to send a page to my browser, then close
CCS
> > and refresh the page. This makes development extremely difficult.
> >
> > I have already tried the CCS tip in changing security settings and that
> does
> > nothing to solve this problem. This problem occurs on my laptop with
WinXP
> > Pro, fortunately, I can also develop CCS applications at home on my
Win2k
> > computer which has none of these problems.
> >
> > Thank you in advance for any insight you may be able to offer.
> >
> >
>
>
|
|
|
John Simmer
|
Posted: 10/16/2003, 8:04 AM |
|
Don,
Thanks for your insights. I turned off ODBC tracing and that eliminated the
hard drive churning althogether. My databases aren't linked so that's not an
issue. I am still getting the "file already in use error message" and I'll
try again to see if I can figure something out on that via an internet
search. Interestingly enough, even with ColdFusion, I get this file in use
error, but I do not get that error with ColdFusion files when working in
DreamWeaverMX. So there is something going on with CCS.
Again, non of these problems occur on my Win2k machine - only my WinXP Pro
laptop. But I suspect it's not a windows issue, though I could be wrong.
Thanks,
John S.
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bmkjuk$m63$1@news.codecharge.com...
> If you are not using the OLEDB provider for Access but reather the ODBC
> Driver, then try OLEDB. I have found it worked better for my apps.
>
> The "churning" is reminiscent of my having turned on the ODBC driver-level
> logging to a disk file once upon a time. This may be the explanation for
> that. It might even be the file that's "already in use" Look for a
> (probably very large) ODBC.LOG on your C drive.
>
> Then again, it may be as simple as the application demanding a lock that
it
> can't obtain, hence the fact it seems to work after you close the CCS IDE.
> Does the Access database have any linked tables - to another Access
> database, especially?
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "John Simmer" <info@webatisan.biz> wrote in message
>news:bmk747$sl6$1@news.codecharge.com...
> > If anyone can help me with this one I would be most appreciative. I run
> > WinXP Pro. The first symptom is when accessing a database within CCS
such
> as
> > when reviewing data from an sql query, my hard disk churns forever
before
> > turning up a result. And then when I try to preview a page in any
> > programming language I get an error message such as this one generated
by
> a
> > PHP page:
> >
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
> use
> > '(unknown)'; file already in use., SQL state S1000 in SQLConnect in
> > c:\inetpub\wwwroot\CFDOCS\MyFusion\CODEcharge\mnfathPHPdt1\db_odbc.php
on
> > line 52
> > Database error: Link-ID == false, odbc_pconnect failed
> > ODBC Error: 0 ()
> > Session halted.
> >
> > NOTE: if I select preview live in browser I get the same error message,
> but
> > if I quit CCS then refresh the browser page it works. Consequently the
> only
> > way I can preview any work is to send a page to my browser, then close
CCS
> > and refresh the page. This makes development extremely difficult.
> >
> > I have already tried the CCS tip in changing security settings and that
> does
> > nothing to solve this problem. This problem occurs on my laptop with
WinXP
> > Pro, fortunately, I can also develop CCS applications at home on my
Win2k
> > computer which has none of these problems.
> >
> > Thank you in advance for any insight you may be able to offer.
> >
> >
>
>
|
|
|
|
|