CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Cannot Solve - [ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use., - PROBLEM

Print topic Send  topic

Author Message
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.
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.