AutoCAD Map 3D PostgreSQL(PostGIS) connection problem

[Anonymous]

Hello,

currently I am writing my MSc thesis about using PostgreSQL with PostGIS extension as spatial database server for road design purposes. I wanted to connect to this database from AutoCAD software (AutoCAD Civil 3D/ Map 3D) but I am struggling with database connection.

I've found Help for this here:

https://knowledge.autodesk.com/support/autocad-map-3d/learn-explore/caas/CloudHelp/cloudhelp/2016/EN...

but I am unable to complete steps 4 and 5.

I have rewritten my postgresql database service name and provided username and password for database:

And I am constantly getting message about authentication not being correct or dataprovider connection problem.

I tried with different users - both with superuser and non-superuser rights.

Can anyone have any idea what I am doing wrong?

Also I have a question regarding this PostgreSQL connection -

since we have to provide "Service Name" and not the host name and port number what is the point of using database which is accesible only from one workstation (the one we want connect to)? And how is it possible to access database remotely for example from LAN/WAN network?

Looking forward to getting a helping hand.

Cheers,

Jakub

[O_Eckmann]

Hi,

The most recent version of Postegre/PostGis supported by MAP 3D 2019 is : PostgreSQL 9.5 + PostGIS 2.2

For other version of MAP 3D, you'll find spécifications here :

https://knowledge.autodesk.com/support/autocad-map-3d/troubleshooting/caas/sfdcarticles/sfdcarticles...

Olivier

[Anonymous]

Thank you for reply Olivier,

so the version 10 is not yet supported yes?

It is sad that 2019 version of AutoCAD software supports only outdated 2015 PostgreSQL instances...

EDIT:

I've just checked with postgresql 9.5 with postgis 2.2 - I am still getting same error message as with pgsql ver. 10. I am still looking for a solution.

[O_Eckmann · Accepted solution]

Hi,

Here is a screencast I've made to connect Civil 2019 with Postgres 9.5 and PostGis 2.2

From pgAdmiIII, I've created an empty database and added PostGis extension to this database, then populated it with ShapeFile and DBF Loader

Olivier

[kajar · Accepted solution]

Dont use any service name, just fill this field with your Postres server name and port: server.name:5432.

Its also working without port.

Map 2019 have also some bug, which you need to fix:

https://knowledge.autodesk.com/support/autocad-map-3d/troubleshooting/caas/sfdcarticles/sfdcarticles...

Kajar

[Anonymous]

So that was my problem!

I mistook "service name" for name of Windows service... Now it works like a charm! 🙂 

Thank you Olivier.

Kajar I've already done that, because I thought that caused my problem, however thank you for reminding.

Cheers.

PS. I would suggest changing the Knowledge Network's page (https://knowledge.autodesk.com/support/autocad-map-3d/learn-explore/caas/CloudHelp/cloudhelp/2016/EN...) to literally writting host:port, because term "service name" could be misleading.