ASP Dsn-less connection error

[Gameface]

Can anybody figure out what I have done wrong with this file that is used to
connect the database -
http://i.1asphost.com/gavk/shop_laptop.asp

Kind Thanks

[Steven Burn]

Thats simple...... you've got a character out of place ;o)

The ; should be inside the quotes, not outside.

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Gameface" <ma**@INVALID.mail.com.INVALID> wrote in message
news:40***********************@news.dial.pipex.com ...

Can anybody figure out what I have done wrong with this file that is used to connect the database -
http://i.1asphost.com/gavk/shop_laptop.asp

Kind Thanks

[Ray at]

Your problem isn't the connection. It's the fact that you have characters
after the end of your string value. It's the same as if you had a line of
code like this:

x = "something"kjaslkjfao;9sduf8asijdf

The kjaslkjfao;9sduf8asijdf characters cannot appear outside of the quotes
like that.

A few other things:
1. Don't use an ODBC connection. Use an OLEDB connection string for your
Access database by modeling your string around this sample from
www.connectionstrings.com
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"

2. Get your database OUT OF THE WWW AREA OF YOUR SITE. I just downloaded
your database (and deleted it...). Anyone in the world can download it,
espeically now that you told the world where it is!

Ray at work
"Gameface" <ma**@INVALID.mail.com.INVALID> wrote in message
news:40***********************@news.dial.pipex.com ...

Can anybody figure out what I have done wrong with this file that is used to connect the database -
http://i.1asphost.com/gavk/shop_laptop.asp

Kind Thanks