Hello all. I'm looking for some assistance or guidance in setting up a Snowflake ODBC connection for Stata 17.
To cut to the chase, I am receiving the following error when attempting to query a connection:
Some details about my connection:
The server includes multiple databases, with underlying schemas and then tables.
The connection requires a username and password which I do believe are working at this point due to some modifications to registry info for the ODBC driver
I am wondering if the issue is in the fact that Stata is trying to use the server link with the double https://https://[server link]. I am unsure as to why the double https:// is being generated as this does not show up in the ODBC driver configuration. Removing all https:// from the driver configuration does not resolve the issue. I am curious if anyone has encountered this before and how they have resolved it?
To cut to the chase, I am receiving the following error when attempting to query a connection:
The ODBC driver reported the following diagnostics
[Snowflake][Snowflake] (4)
REST request for URL
https://https://REDACTED/:443/session/v1/login-request?requestId=6ef68a52
> -e754-41cd-a2b6-1f8ecc67393d&request_guid=8703a37c-e7d3-4134-8459-efea1bf01d0f&databaseName=MASTERING&schemaNa
> me=BIOLOGY&warehouse=ER_WAREHOUSE failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't
resolve host name'.
SQLSTATE=HY000
[Snowflake][Snowflake] (4)
REST request for URL
https://https://REDACTED/:443/session/v1/login-request?requestId=6ef68a52
> -e754-41cd-a2b6-1f8ecc67393d&request_guid=8703a37c-e7d3-4134-8459-efea1bf01d0f&databaseName=MASTERING&schemaNa
> me=BIOLOGY&warehouse=ER_WAREHOUSE failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't
resolve host name'.
SQLSTATE=HY000
The server includes multiple databases, with underlying schemas and then tables.
The connection requires a username and password which I do believe are working at this point due to some modifications to registry info for the ODBC driver
I am wondering if the issue is in the fact that Stata is trying to use the server link with the double https://https://[server link]. I am unsure as to why the double https:// is being generated as this does not show up in the ODBC driver configuration. Removing all https:// from the driver configuration does not resolve the issue. I am curious if anyone has encountered this before and how they have resolved it?
