Thursday, March 22, 2012

Can't set varbinary(MAX) in Visio 2005

Why can't I use the new types in Visio 2005? When ever I type in MAX - it complains that MAX is not an integer?You need to do the following ( I will assume that you are creating a database model diagram):
1. Create new database model diagram
2. Go to Database -> Options -> Drivers
3. Select "Microsoft SQL Server" in the default driver for Visio
4. Click Setup
5. Pick "SQL Native Client" for ODBC drivers to use
6. Go to preferred settings tab and select 2005 in the preferred version drop-down under DDL script generation
7. Now when you create an entity and create a new column will see varchar(MAX), nvarchar(MAX), varbinary(MAX) and xml as data type options.|||Many thanks for that Umachandar!

No comments:

Post a Comment