|Syntactic Confectionery Delight
What is the proper data structure for CAP::DBH?by bradcathey (Prior)
|on Jan 18, 2023 at 02:15 UTC
bradcathey has asked for the wisdom of the Perl Monks concerning the following question:
I am moving websites to Pair.com from a dedicated server where local is the implied database host. So, I have never had to declare it and connections using CGI::Application::Plugin::DBH have looked like this and worked fine:
However, Pair requires a host name. It might look like: vdb25b.pair.com and the database: 1945667_w
The docs for CGI::Application::Plugin::DBH give this for the data source
And DBI docs suggest this format for the data structure
So, I have set up the connection to look like this:
There is no error, it just hangs and I have to manually kill it.
In a straight up connection using DBI, this works fine:
Question: What is the data source look like when the host must be named when using CAP::DBH?
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot