Comments (8)
I had similar problems with the connection string. A cs like this worked for me:
"ACCOUNT=XXXXXX;HOST=XXXXXX.east-us-2.azure.snowflakecomputing.com;USER=[email protected];PASSWORD=ggg";
So the region information in this context does not belong to the account but to explicitly defined host.
from snowflake-connector-net.
I had a similar problem with the documentation being a bit wonky. The documentation suggests that everything before '.snowflakecomputing.com' is part of the account, but this is not always true. The appropriate pattern for us is:
host=account_name_here.east-us-2.azure.snowflakecomputing.com;
account=account_name_here;
from snowflake-connector-net.
I'm having the same issue, but I think that the issue could be caused because our username is an email address and seems that the connector doesnt support the @.
from snowflake-connector-net.
Hi all,
I'm facing same problems... Not able to use the nuget package, as a workaround by the moment Im using the ODBC connector.
from snowflake-connector-net.
@rshenton @josefarinna Do you use Okta or SSO for authentication? If yes, then this is expected since SSO is not supported for now.
from snowflake-connector-net.
Hi @howryu we are using the connection like that:
using (IDbConnection conn = new SnowflakeDbConnection())
{
conn.ConnectionString = "ACCOUNT=XXXXXX.east-us-2.azure;USER=[email protected];PASSWORD=ggg";
conn.Open();
conn.Close();
}
And we are getting the error of "Incorrect username or password was specified", we are not using SSO neighter Okta. We are using the same credentials for accessing to the web interface and it's working fine.
Thanks.
from snowflake-connector-net.
@ikudjoi It worked!!! Thanks so much for your comment 👍
from snowflake-connector-net.
Thanks everyone for the response. I will update the doc to explicitly indicate that account name should not include region or cloud provider info.
from snowflake-connector-net.
Related Issues (20)
- SNOW-1272506: AcquireTokenByUsernamePassword failing to get OAuth token for Snowflake HOT 4
- SNOW-1276398: OpenAsync does not throw an exception in case of timeout HOT 12
- SNOW-1279620: Error: Could not read private key with value passed in connection string. \n Error : incorrect private key value or private key format HOT 2
- SNOW-1307794: This is a test issue
- SNOW-1333163: Add support for default proxy configuration HOT 11
- SNOW-1337012: `ExecuteNonQuery` deadlocks when called from a ThreadPool thread HOT 4
- SNOW-1346563: Authorization issue (Method not found: Void Microsoft.IdentityModel.Tokens.InternalValidators.ValidateLifetimeAndIssuerAfterSignatureNotValidatedSaml) HOT 7
- SNOW-1433638: Symbol -- cannot be treated as a string. HOT 6
- SNOW-1462365: ERRPR : PAD BLOCK CORRUPTED => works locally, but not when deployed to k8s pod. HOT 3
- SNOW-1463590: BouncyCastle.Cryptography Issue HOT 8
- SNOW-1463600: Snowflake.Net is an option in the list of SSIS/SSAS connections and working HOT 6
- SNOW-1468887: Question - Support array binding other than SQL INSERT HOT 5
- SNOW-1472918: ADO.NET Driver Security Disclosure Issue HOT 1
- SNOW-1479655: VECTOR datatype is not supported HOT 2
- SNOW-1493353: Connector does not work inside of Snowpark Containers HOT 6
- SNOW-1499157: Error: Snowflake Internal Error: Unable to connect. One or more errors occurred. SqlState: 08006, VendorCode: 270001, QueryId: HOT 1
- SNOW-1502317: Nonrecoverable HttpRequestExceptions are retried in HttpUtil.cs HOT 1
- SNOW-1503425: Can't bind array properly - filtering IN or ARRAY_CONTAINS doesn't work HOT 2
- SNOW-1524454: Too many dependencies in Snowflake.Data nuget package HOT 1
- SNOW-1545648: PUT command error if file path contains spaces HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from snowflake-connector-net.