OLE DB

[frankhdata]

This is what i am trying to make.

http://www.webthang.co.uk/tuts/tuts_dmx04/gallery/demo/default.asp

the instructions are here

http://www.webthang.co.uk/tuts/tuts_dmx04/gallery/gallery3.asp

This page is not working
this is the error message i am getting


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/TEST/ASP/gallery/default.asp, line 8
Thanks

 

[Sheco]

ok, on that page where you have the instructions... on step two there is a box for configuring the Recordset... the second textbox is labeled "connection" and in the example it shows "conGallery".

Now for the purposes of this example conGallery is a Data Source Name (DSN) that was already created... probably with that button labeled "Define."

My guess is that you need to define your own DSN and then put its name in that textbox.

 

[frankhdata]

Hi Sheco !

I dont know if you use dreamweaver
But this is what I did
I opened record set query.
The program asks to select a connection.
That is where I get stuck.
If you can be more clear about this
I would appreciate that.
Thanks

 

[frankhdata]

Hi Sheco !


I just created a Data Source Name (DSN)
Still not working
This is what i am getting
///////////////////
Active Server Pages error 'ASP 0126'

Include file not found

/1audwebpres/TEST/ASP/gallery/default.asp, line 3

The include file '../../../Connections/gallery.asp' was not found.

 

[Sheco]

I don't know anything about dreamweaver but it sounds like you fixed the DNS error.

That new error sounds like line 3 of your default.asp file is referencing a file named gallery.asp but that the gallery.asp file does not exist or is not where line 3 says it should be.

 

[frankhdata]

Hi Sheco !
Thanks for your help
I am going to plat around with this
I will keep you posted if there are improvemnets