Piyush.
|
| Posted: 02/27/2002, 4:38 AM |
|
Hi,
I'm a newbie when it comes to ASP & database interactivity. I've downloaded the bookstore application from here & must I say I was very, VERY, V E R Y impressed with the work that the developers put in it, Kudos to them.
I was actually needing a "classifieds" application for my friend's bookstore site. Neither she nor me have money to spend on buying all those fancy applications & all of a sudden I came across this website, which almost got me all alive & kicking back again. Well, As I earlier mentioned I'm a newbie, I'm using a free host to get this website started & as things progress if she has money, we might get ourselves a paid web-host.
But untill then, we can't afford to pay hosts for setting up our DSN, is there any way that can be avoided?I've heard about DSN-less connectivity too. Is it possible with this application? If so please let me know at super_piy79@yahoo.com
here's the code of that DSN connectivity as it appears in common.asp
Set cn = Server.CreateObject("ADODB.Connection")
'Database connection string
strConn = "Provider=MSDASQL.1;Persist Security Info=False;User ID=;Data Source=bookstore"
strLogin = ""
strPassword = ""
cn.open strConn, strLogin, strPassword
I hope it helps.
|
|
|
|
Tom
|
| Posted: 02/27/2002, 6:12 AM |
|
Hello,
you may use JET connection if you work with Access db. Upload db to server as well as asp scripts. Connection string would be like:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("BookStore_MSAccess.mdb") & ";Persist Security Info=False"
|
|
|
|
Piyush.
|
| Posted: 02/27/2002, 6:36 PM |
|
First of all, Tom, thanks for helping me out there.
I tried using that string you provided me with, but when I upload common.asp on that stupid brinkster server it gives me "The improper use of 'on error resume next' was noted. Comment out the 'on error...' directive of the offending file and reupload it." message.
I tried searching for the word "on error" in my common.asp, I found out "on error resume next" in a couple of functions, I suppose server wants me to change it to "on error Go To 0" is that okay?
Anyways, I just noticed, it won't let me upload common.asp.. so without that file, there's no way I can check out if your connectvity string is compatible with this application  (
|
|
|
|
Sam Moses
|
| Posted: 02/28/2002, 6:52 AM |
|
Dude,
You're telling him to create a DSN for access, when he's obviously using MSsql of some sort or another. Most everyone seems to be under the misconception that Dsnless connections to SQL are simply not possible. But they are wrong.
Here's how I would do it:
For MsSQL:
Driver={MSDASQL.1};Server=servername;Database=bookstore;Uid=Sam;Pwd=Moses;
For SQL Server:
Driver={SQL Server};Server=servername;Database=bookstore;Uid=Sam;Pwd=Moses;
You would of course need to replace the username and password, but that should work.
Cheers,
Sam
|
|
|
|
Piyush.
|
| Posted: 02/28/2002, 10:49 AM |
|
As I earlier mentioned in my posted messages, I've downloaded Bookstore without templates. when I tried changing the database connectivity string & upload common.asp on my server(brinkster.com) the bot won't let me do it, giving me errors regarding 'on error resume next' statement. when I searched for the string "on error" in my common.asp, I replaced my 'on error resume next'by 'on error Go To 0' it worked fine then.
Although site is working properly, I'm not aware what is the function of those 'on error' string.
Can anyone please explain that to me?
|
|
|
|
|
|
