L
LostBrain
I have created a multipage visio 2003 document with all shapes linked to my
test database (sql server 2000). The link is to a view. I right click on the
shape and select the record I want to populate that shape. The record key is
a twelve to fifteen character long field. This has been working with no
problems.
Now I need to move it to my production server which is also SQL Server 2000.
I simply changed the server path in the connection string and the name of the
new database. The view in the new database has the same name as the view in
the test database and provides the same information using alias naming.
The problem? Now when I go to select the database record I can only see the
first eight characters of the key field. I even created a new visio document,
added a shape, and ran the database wizard to the new server database and had
the same result, but if I connect excel to the same view in the new database
it sees and loads all of the records with out a problem.
Has anyone else run into this? The problem does not seem to be in the server.
test database (sql server 2000). The link is to a view. I right click on the
shape and select the record I want to populate that shape. The record key is
a twelve to fifteen character long field. This has been working with no
problems.
Now I need to move it to my production server which is also SQL Server 2000.
I simply changed the server path in the connection string and the name of the
new database. The view in the new database has the same name as the view in
the test database and provides the same information using alias naming.
The problem? Now when I go to select the database record I can only see the
first eight characters of the key field. I even created a new visio document,
added a shape, and ran the database wizard to the new server database and had
the same result, but if I connect excel to the same view in the new database
it sees and loads all of the records with out a problem.
Has anyone else run into this? The problem does not seem to be in the server.