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;""
> --------------------------------------------------------------------------
--
> ---^
>
>
>
>
>
|
|
|
|