RE: Linking Bentley elements properties to SQL database table [OpenCities Map Forum]

Question

Configuring the &ldquo;classic&rdquo; database connection with a SQL Server database via the Database node in the XFM schema. 
 It uses the Mscatalog table and mslink column in the property tables. With this option the properties are stored in an external database instead of in the DGN file. 
 In the online help file , go to the following pages to have more information: 
 
 OpenCities Geospatial Administrator > OpenCities Geospatial Administrator Features > Defining Feature Properties > DGN Resident Versus Database Properties. 
 OpenCities Geospatial Administrator > Database.

Some remarks: 
 
 As an example, use the attached SQL script MScatalog and Feature tables.sql to create Mscatalog table and two Feature Property tables in the SQL Server database. 
 Create an ODBC datasource name that makes a connection with an SQL server database e.g. LucaraBotswana , see screenshots. 
 In the Geospatial Administrator, make a connection (note that Windows Authentication is not available here). 
 If the connection is successful, in the Overview tab, tables are listed that can be used for database properties. 
 Next create features, and add database properties.

From: Kabo Makhwe Subject: Linking Bentley elements properties to SQL database table [OpenCities Map Forum]

Update from Bentley Communities

Kabo Makhwe

Gooday 
 
 How do i link my MS SQL server database tables with my GSA schema. When i update my Database in GSA i have no tables. I have attached my database and my schema file. 
 View online 
 If you encounter issues clicking "View online", check here .

You received this notification because you are subscribed to the forum. To stop receiving updates from only this thread, go here . To unsubscribe from a forum, please see this note . 
 Flag this post as spam/abuse.