topic Re: dbconnect manager does not work in AutoCAD Plant 3D Forum

dbconnect manager does not work

Anonymous — Mon, 10 May 2021 12:44:01 GMT

Hi everyone

Trying to connect to the SQL database (https://www.youtube.com/watch?v=aCDVQHcHEMI) does not work on my version of plant 3D (2021)
It can not find the SQL so I have to type it manually and then when I connect to the database it takes up to half an hour to load the piping dcf file.

See screenshots

There are no subfolders as shown in the youtube vid

The sql is local on the same laptop as Plant is installed so no firewall issues or other network related stuff. Local is local right?

So why can I make a SQL project without issues but can not use dbconnect?

Please help to fix this thank you

Re: dbconnect manager does not work

Anonymous — Mon, 10 May 2021 13:01:16 GMT

Betreff: dbconnect manager does not work

h_eger — Mon, 10 May 2021 18:13:01 GMT

Please check whether the current driver for SQL Server is installed.

Microsoft ODBC Driver 17.7.2 for SQL Server (x64):

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

Betreff: dbconnect manager does not work

Anonymous — Tue, 11 May 2021 06:43:13 GMT

Hi @h_eger

It is installed and repaired it just now. Issues still there 😞

Betreff: dbconnect manager does not work

Anonymous — Tue, 11 May 2021 12:13:03 GMT

Anyone from Autodesk who knows this?
I cant be the only one facing this issue?

Betreff: dbconnect manager does not work

h_eger — Tue, 11 May 2021 14:20:52 GMT

It will be the case that you work with this antiquated technology like dbconnect in Plant 3d.
We use the PLANTXDBMANAGER to communicate with external databases.

Open a support case at Autodesk and you will surely get an answer.

Betreff: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 09:40:25 GMT

I dont know who accepted this as solution but not me.
Anyway I tried this command and still same. Not working

Re: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 09:43:40 GMT

Where do you open support case? They only have forum....

Re: dbconnect manager does not work

George.Endrulat — Wed, 12 May 2021 09:56:15 GMT

We use a combination of SQL database --> Excel --> Plant 3D --> data linked table and plantxdbmanager (for live db connected properties). Can I ask what you're trying to do with the dbconnect manager? There might be a different approach.

Re: dbconnect manager does not work

h_eger — Wed, 12 May 2021 11:51:29 GMT

Dear @Anonymous ,

I don't know your configuration, but the XDBMANAGER works perfectly for me as shown in the picture.

Re: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 12:09:32 GMT

@h_eger @George.Endrulat

I want to see the SQL project database (DCF files of SQLite project) See the video on my first post.
The DCF files contains info of the project but since we use SQL the DCF files are empty.
See the video he shows how to see the data from the DCF files in the SQL server

https://youtu.be/aCDVQHcHEMI?t=1125

Re: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 12:10:36 GMT

@h_eger @George.Endrulat

Here a vid of what I am doing

Re: dbconnect manager does not work

h_eger — Wed, 12 May 2021 13:37:30 GMT

Dear @Anonymous ,

One of us should check his SQL Server and the access rights: It's not me!

I have recreated your scenario and it works fine for me!

Re: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 14:44:08 GMT

Thats awkward....

I can make a project without problems like i showed in the vid..
What needs to be changed to get access to an local SQL instance?
SQL and Plant3D is installed on this pc..... No network nor internet is needed.....

Betreff: dbconnect manager does not work

h_eger — Wed, 12 May 2021 15:19:40 GMT

Unfortunately, I am not the administrator of your computer.
I am missing the general information about your installation and configuration.
Which version of the SQL Server Managemat Studio do you use?
I am using version v18.6

Betreff: dbconnect manager does not work

Anonymous — Wed, 12 May 2021 15:26:49 GMT

I am using 18.9.1 (latest version) standard installation no settings changed. (SQL server 2019 on WIN10 Home)

Server roles standard as well as access rights.

I can make an new project (SQL based) without issues.

If you want I can make a screencast showing all the settings.

Please note!!
SQL is installed on the same pc as Plant3D

I did not changed anything in the projects (there are 3 test projects as you can see

Betreff: dbconnect manager does not work

Anonymous — Thu, 13 May 2021 09:55:15 GMT

Anyone who can help me pls? My deadline is coming and it still does not work proper.....
I used the Autodesk PDF about SQL server setup and did everything listed in it.. Even remote connection using TCP.

| Checked the roles and login.... I can make new projects without issues but can not use the DBCONNECT command.....

Betreff: dbconnect manager does not work

George.Endrulat — Thu, 13 May 2021 10:01:06 GMT

I'm not sure about your problem, but a simple solution to getting your work done might be using management studio to export to excel, cleaning up the excel workbook, then using that data as a data linked table. This is very one directional, but it does work.

Betreff: dbconnect manager does not work

Anonymous — Thu, 13 May 2021 10:05:49 GMT

@George.Endrulat

My work here is to get the command up and running and not export from ssms... ALl needs to be done straight from within Plant3D and as @h_eger showed it works for him.. SO what settings needs to be changed that are NOT mentioned in the PDF from Autodesk about SQL???

Again why can I make a new project without issues. Open the project and work in it, But am unable to access the database using DBCONNECT.....

Betreff: dbconnect manager does not work

Anonymous — Thu, 13 May 2021 11:38:00 GMT

Anyone from Autodesk willing to help with this issue?