I am having an issue with the ODBC connect statement:
I am connecting to different DB on dev and prod and they have different names and credentials on dev and prod. The prod setup only has a server enviroment (no desktop) so I need to script the connection string on dev and push the app to prod.
How can I get the prod connection string in my script without having to actually connect to the prod DB.
If both databases are the same then you just need to change the names. If you have scramble connect user credentials in the settings enabled , disable it so that you can directly enter the username and password. In any case, the DB admin should be able to provide you with the connections string.