Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Error Connecting Through DSN

Error Connecting Through DSN

enargins
Visitor
2 0 0

I'm trying to connect to Shopify through a 32-bit DSN in Windows 10, using the Devart ODBC driver for Shopify. The owner of the site created a custom app and gave it all permissions, and got an Admin API Access Token, which he shared with me.

 

The Devart driver requires the URL in the format: "https://storename.myshopify.com" and the Access Token, both of which I entered into the DSN configuration. 

 

However, when I test connection, I get the error:

 

"Invalid API key or access token (unrecognized login or wrong password)"

 

Any ideas of what might be going on?

 

Thanks!

Replies 2 (2)

PageFly-Richard
Shopify Partner
4801 1084 1751

Hi,

This is Richard at PageFly - Shopify Advanced Page Builder app.

 

There are a couple of possibilities for the "Invalid API key or access token" error you're encountering when connecting to Shopify through a 32-bit DSN:

1. Access Token Issues:

  • Validity: Double-check the Admin API Access Token provided by the store owner. Ensure it's still valid and hasn't been revoked.
  • Permissions: Verify that the custom app has been granted the necessary permissions to access the data you're trying to retrieve.
  • Scope: Make sure the access token's scope covers the specific actions you're trying to perform. For example, reading product data might require the "read_products" scope.

2. DSN Configuration Issues:

  • URL format: Ensure the URL in the DSN configuration is entered correctly as "https://storename.myshopify.com". Double-check for any typos or extra spaces.
  • Driver Compatibility: While Devart offers a Shopify ODBC driver, confirm its compatibility with 32-bit systems on Windows 10. Some drivers might have specific system requirements.
  • Token Placement: Consult the Devart driver documentation for specific instructions on where to place the access token within the DSN configuration. It might be a separate field or part of the URL itself.

 

Hoping my solution helps you solve your problem.

Best regards,

Richard | PageFly

Please let me know if it works by giving it a Like or marking it as a solution!


➜ Optimize your Shopify store with PageFly Page Builder (Free plan available) 


All features are available from Free plan. Live Chat Support is available 24/7.

enargins
Visitor
2 0 0

Hi, Richard. Thanks for the reply.

 

Yes, I believe all those bases were covered. The error happened literally minutes after creating the custom app. And the owner checked every box, giving it all scope permissions. And I believe all the points in the second note are done correctly.

 

However, I do have a question about this:

 


Permissions: Verify that the custom app has been granted the necessary permissions to access the data you're trying to retrieve.

When the custom app was created there was no step done to grant any permissions (nor was there any in the instructions). The person who created the app was the owner of the site, so presumably he had full permissions.

Was there another step needed to explicitly grant the custom app permissions, apart from checking the boxes to specify the scope?

 

Thanks!

 

Neil