|
 |
asp_database_setup thread: Failure to access the SQL Database with ASP
Message #1 by sorp@n... on Thu, 1 Nov 2001 17:25:38
|
|
I don't know why I can't access the database that the books provides.
Actually, I don't know how to setup the MSDE as the procedures are not
mentioned in the book.
When I try to compile the source code in P.475,
Dim strDatabaseType
'Choose one of the folowing two lines, and comment out the other
'strDatabaseType = "Access"
strDatabaseType = "MSDE"
---> objConn.Open "Provider=SQLOLEDB;Persist Securtiy Info=False;" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Initial File Name=C:\MSSQL7\Data\MovieMSDE.mdf"
Errror is promote to --->.
Would you anyone tell me how to fix the problems? I am looking forward to
your solution.
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 2 Nov 2001 11:17:12 +1100
|
|
<sigh>
What is the error you are getting?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <sorp@n...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Thursday, November 01, 2001 5:25 PM
Subject: [asp_database_setup] Failure to access the SQL Database with ASP
: I don't know why I can't access the database that the books provides.
: Actually, I don't know how to setup the MSDE as the procedures are not
: mentioned in the book.
:
: When I try to compile the source code in P.475,
:
: Dim strDatabaseType
: 'Choose one of the folowing two lines, and comment out the other
: 'strDatabaseType = "Access"
:
: strDatabaseType = "MSDE"
:
: ---> objConn.Open "Provider=SQLOLEDB;Persist Securtiy Info=False;" & _
: "User ID=sa;Initial Catalog=Movie;" & _
: "Initial File Name=C:\MSSQL7\Data\MovieMSDE.mdf"
:
: Errror is promote to --->.
:
: Would you anyone tell me how to fix the problems? I am looking forward to
: your solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Tim Genge" <madfish@b...> on Tue, 20 Nov 2001 15:55:31
|
|
Theres a type in your connection string - should read SECURITY. Also, your
missing a PW (password) section. You also don't need to define the actual
file. Here's the fixed connection string;
"Provider=SQLOLEDB;Persist Security Info=False;" & _
"UID=sa;PW=;Database=Movie;Server=;"
Need to fill in Server name and password, if applicable. This is assuming
your connecting to SQL server, of course.
> <sigh>
>
> What is the error you are getting?
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: <sorp@n...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Thursday, November 01, 2001 5:25 PM
> Subject: [asp_database_setup] Failure to access the SQL Database with ASP
>
>
> : I don't know why I can't access the database that the books provides.
> : Actually, I don't know how to setup the MSDE as the procedures are not
> : mentioned in the book.
> :
> : When I try to compile the source code in P.475,
> :
> : Dim strDatabaseType
> : 'Choose one of the folowing two lines, and comment out the other
> : 'strDatabaseType = "Access"
> :
> : strDatabaseType = "MSDE"
> :
> : ---> objConn.Open "Provider=SQLOLEDB;Persist Securtiy Info=False;" & _
> : "User ID=sa;Initial Catalog=Movie;" & _
> : "Initial File Name=C:\MSSQL7\Data\MovieMSDE.mdf"
> :
> : Errror is promote to --->.
> :
> : Would you anyone tell me how to fix the problems? I am looking forward
to
> : your solution.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
|
|
|
View Cart
