CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Connection Problems. Unable to connect to any database with CC.

Print topic Send  topic

Author Message
phantom
Posted: 02/08/2001, 2:13 AM

Can some help me... I am get an connection error when I'm trying to connect
the product database. I have no luck in getting to work.!!!
I currnetly host inga internal webserver running on Win200 and ASP as a
configuration.

I have also tried changed drives and locations.. but it just doesn't want to
work!
This error was genberated when I served the page, using the Access Data ODBC
connection option.

Microsoft VBScript compilation error '800a0401'
Expected end of statement

/specs/Common.asp, line 11

strConn = "Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DBQ=W:\wb\specs\product.mdb;DefaultDir=W:\wb\specs;Driver={Drive
r do Microsoft Access (*.mdb)};DriverId=25;FIL=MS
Access;FILEDSN=W:\wb\specs\product.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;
PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;""
----------------------------------------------------------------------------
---^




CodeCharge
Posted: 02/08/2001, 3:10 AM

Please try changing your Server Connection String to:

strConn = "Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties=""DBQ=W:\wb\specs\product.mdb;DefaultDir=W:\wb\specs;Driver={Driv
e
r do Microsoft Access (*.mdb)};DriverId=25;FIL=MS
Access;FILEDSN=W:\wb\specs\product.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;
PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;"""

(notice additional Quote before DBQ and at the end of the string)

phantom <phantom@phantom.com> wrote in message
news:95trg4$m5q$1@news.codecharge.com...
> Can some help me... I am get an connection error when I'm trying to
connect
> the product database. I have no luck in getting to work.!!!
> I currnetly host inga internal webserver running on Win200 and ASP as a
> configuration.
>
> I have also tried changed drives and locations.. but it just doesn't want
to
> work!
> This error was genberated when I served the page, using the Access Data
ODBC
> connection option.
>
> Microsoft VBScript compilation error '800a0401'
> Expected end of statement
>
> /specs/Common.asp, line 11
>
> strConn = "Provider=MSDASQL.1;Persist Security Info=False;Extended
>
Properties="DBQ=W:\wb\specs\product.mdb;DefaultDir=W:\wb\specs;Driver={Drive
> r do Microsoft Access (*.mdb)};DriverId=25;FIL=MS
>
Access;FILEDSN=W:\wb\specs\product.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;
> PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;""
> --------------------------------------------------------------------------
--
> ---^
>
>
>
>
>


   


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.