ID Manager Database Connection

[john w]

This just started, when I go to publish my app, I get a Connnection error from the ID Manager. The connections test fine in the IDE, and in other DB apps. However, when I go to publish I get the error in the image. I have deleted and rebuilt the connection in the IDE manager several times but it fails to connect.

Do I need to use the dataase portion of the ID Manager to publish my application? It really does nothing for me other than the publish. I push the compiled version of the app to the site using FTP.

Can I use Visual Studio to publish instead of ID Manager?

ScrnCapt_2025.03.20 (1).png (69.48 KiB) Viewed 161 times

ScrnCapt_2025.03.20.png (60.68 KiB) Viewed 161 times

[d.pierangeli]

Unfortunately, I don't know what the problem might be with the IDManager server; it seems like a timeout in the connection to the DB server. Maybe there was a Windows or a driver update?

The database management portion cannot be skipped. IDManager needs to know the current state of the database to communicate it to the IDE so it can write the necessary SQL instructions to ensure the schema is in the wanted status.

If you're not interested in IDManager's database management (maybe you do it yourself) or can't solve the issue, you can publish manually:

- Set the production DB connection strings in the IDE.
- Compile without debugging.
- On the server, back up the folder and then delete the Bin and App_Code folders.
- Copy the output folder to the server.

The only difference is that IDManager compiles the application into a precompiled DLL in the Bin folder, while the IDE creates the sources in the App_Code folder, and IIS compiles them on the first access to the site.

Let me know if you'd like further clarification

[john w]

Thank you for the response. I really never use ID Manager except when I publish.It sits on my local machine. I just use it to compile the app, create a local .zip file, unzip that file and FTP the unzipped contents to site. I manage all the db matter myself on the db side.

I did just find an old thread where a possible solution was to Release the Ownership of the db tables. I did that it published. I then used my process to push the app to the server site.

Its good to know I can I publish without ID Manager. I will study your instructions and try it going forward.

J