dsn-less connection error

[slexow]

I created a dsn-less connection using custom connection string from the
database tab. I am attempting to do some datashaping
([url]http://www.dwfaq.com/Tutorials/Dynamic/datashape.asp[/url]), thus the provider
=MSDataShape My string = 'Provider=MSDataShape;Data
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &
Server.MapPath('/bbnc/db/CharonCart3.mdb') & ';' I create the custom conn
string and hit test and receive 'connection made successfully'. Then I go to
the bindings tab and try to create a new record set, when I choose the
connection (the one from above) I get the following error: 'Uanble to retrieve
tables from this connection, click on the 'Define....' button and test this
connection.' It again tests successfully. What could be causing this? Thanks,
Stan

[BillB]

Did you define a Data Source Name variable. If not do to "Application" and
under "Bindings" click the + button and at the bottom select Data Source
Name Variable.

That's the only thing I can think of. If you have further trouble though you
might have better luck over at the Cartweaver support group.
[url]news://support.cartweaver.com[/url]
Bill"slexow" <webforumsuser@macromedia.com> wrote in message
news:d0qhip$b9j$1@forums.macromedia.com...

>I created a dsn-less connection using custom connection string from the
> database tab. I am attempting to do some datashaping
> ([url]http://www.dwfaq.com/Tutorials/Dynamic/datashape.asp[/url]), thus the provider
> =MSDataShape My string = 'Provider=MSDataShape;Data
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &amp;
> Server.MapPath('/bbnc/db/CharonCart3.mdb') &amp; ';' I create the custom
> conn
> string and hit test and receive 'connection made successfully'. Then I
> go to
> the bindings tab and try to create a new record set, when I choose the
> connection (the one from above) I get the following error: 'Uanble to
> retrieve
> tables from this connection, click on the 'Define....' button and test
> this
> connection.' It again tests successfully. What could be causing this?
> Thanks,
> Stan
>