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

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" <mail@INVALID.mail.com.INVALID> wrote in message
news:40966b68$0$15745$cc9e4d1f@news.dial.pipex.com ...[color=blue]
> Can anybody figure out what I have done wrong with this file that is used[/color]
to[color=blue]
> connect the database -
> http://i.1asphost.com/gavk/shop_laptop.asp
>
> Kind Thanks
>
>[/color]

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" <mail@INVALID.mail.com.INVALID> wrote in message
news:40966b68$0$15745$cc9e4d1f@news.dial.pipex.com ...[color=blue]
> Can anybody figure out what I have done wrong with this file that is used[/color]
to[color=blue]
> connect the database -
> http://i.1asphost.com/gavk/shop_laptop.asp
>
> Kind Thanks
>
>[/color]