Upsized Access DB not playing friendly

Report · Nov 20, 2008

have a small applicaiton that used ms access as a backend and builds
a simple repeating table. I used the data objects from the gui in
dreamweaver to build and connect to the db (DW CS3, .asp vb). The
repeating table has 8 columns and has simple values like Name, dept,
id, etc....They wanted to upsize the db to SQL. We did the upsize, I
did a few connection tests with no problems (read and write).
Established the new dsn. Now, back to my repeating table app. My
thought was to just change the dw connection file (that currently
points to Access) and point to the new dsn (SQL). Did this and
everhitng worked great. No errors. Except the repeating table only
returns 4 of the 8 fields in the table. Meaning, the table is intact
but for some reason it will only pull 4 of the 8 bindings from the
recordset. (????). It doesnt matter which 4 they are, just the first
4 from left to righ in the repeating table. Again, no errors to work
off of. The other cells in the tables are empty.

-I run the select statmenet in query analyzer and everything returns
perfectly
- dreamweaver crashes now if I try to work with the application panel
and the database

Anyone experience such a thing?

Report · Nov 21, 2008

HCSG wrote:
> have a small applicaiton that used ms access as a backend and builds
> a simple repeating table. I used the data objects from the gui in
> dreamweaver to build and connect to the db (DW CS3, .asp vb). The
> repeating table has 8 columns and has simple values like Name, dept,
> id, etc....They wanted to upsize the db to SQL. We did the upsize, I
> did a few connection tests with no problems (read and write).
> Established the new dsn. Now, back to my repeating table app. My
> thought was to just change the dw connection file (that currently
> points to Access) and point to the new dsn (SQL). Did this and
> everhitng worked great. No errors. Except the repeating table only
> returns 4 of the 8 fields in the table. Meaning, the table is intact
> but for some reason it will only pull 4 of the 8 bindings from the
> recordset. (????). It doesnt matter which 4 they are, just the first
> 4 from left to righ in the repeating table. Again, no errors to work
> off of. The other cells in the tables are empty.
>
> -I run the select statmenet in query analyzer and everything returns
> perfectly
> - dreamweaver crashes now if I try to work with the application panel
> and the database
>
>
> Anyone experience such a thing?

Have you double checked all your datatypes in the tables in MSSQL?
Upsizing doesn't always get it right.

Dooza