August 2, 2010 at 4:18 pm
Hi,
I'm using CA Erwin r7.3 version and i got sql server 2008.
Now when i'm trying to forward engineer the data model that i designed to a sql server database i'm getting the following error
""CREATE TYPE geography
EXTERNAL NAME Microsoft.SqlServer.Types.[Microsoft.SqlServer.Types.SqlGeography]
[Microsoft][SQL Server Native Client 10.0]Communication link failure
Execution Failed!""
could you please help me out with that. Thank you...
August 2, 2010 at 11:20 pm
Since you are using Erwin data modeller check if your id has "Public" privileges on the database. If yes, then check if you are able to connect to the SQL Server Instance through SSMS.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 6:54 am
Why are you trying to create an alias of the geography data type with the same name? Just use it as is.
Also, if you try running that script, as defined, you'll get an error. The syntax is off.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply