# SQL Database Connector connection issues **URL:** \ **Category:** Plugins\ **Created:** [November 4, 2022, 3:34pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197 "2022-11-04T15:34:29Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 4, 2022, 3:34pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/1 "2022-11-04T15:34:29Z")
SQL Database Connector connection issues If you specify the OFFSET parameter in the request, then the request works [http://joxi.ru/v291dZEf4EllO2](http://joxi.ru/v291dZEf4EllO2). But if you change the OFFSET parameter to dynamic [http://joxi.ru/VrwwWOLToBY3dr](http://joxi.ru/VrwwWOLToBY3dr), then the request stops working and returns an error [http://joxi.ru/82QapdgI8PvW72](http://joxi.ru/82QapdgI8PvW72) Has anyone solved this problem? ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 4, 2022, 4:06pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/2 "2022-11-04T16:06:52Z")
You could give our plugin a try, we built it to solve issues we ran into with free connector: [SQL Database Connector Pro Plugin | Bubble](https://bubble.io/plugin/sql-database-connector-pro-1659728184544x363497584834641900) ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 4, 2022, 4:10pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/3 "2022-11-04T16:10:31Z")
Does your plugin support the OFFSET statement? ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 4, 2022, 4:16pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/4 "2022-11-04T16:16:02Z")
Yes. All valid SQL statements are supported. However I haven’t specifically tested offset. If you find there is an issue and it isn’t working properly, I can fix it right away for you. The documentation is here if you want to look it over first: [Introduction - SQL Database Connector Pro](https://build-it-branding.gitbook.io/mssql-sql-database-connector/guide/introduction) ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 4, 2022, 4:23pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/5 "2022-11-04T16:23:43Z")
I have read your documentation. I need to use OFFSET statement in Get data from external API. And from your documentation it follows that only the Action is available in your plugin. ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 4, 2022, 4:37pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/6 "2022-11-04T16:37:48Z")
Try using OFFSET $1 and not OFFSET ? ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 4, 2022, 5:57pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/7 "2022-11-04T17:57:05Z")
still an error [http://joxi.ru/ZrJ5OD1TQJzVPA](http://joxi.ru/ZrJ5OD1TQJzVPA) [http://joxi.ru/YmEj1EOTGnz4E2](http://joxi.ru/YmEj1EOTGnz4E2) ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 4, 2022, 9:57pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/8 "2022-11-04T21:57:52Z")
@emmanuel Can you make corrections to the plugin? ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 5, 2022, 1:21am UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/9 "2022-11-05T01:21:34Z")
I think something might be wrong on your query somewhere. I just had a chance to test the OFFSET $1/number syntax as you have in your recent query and it worked with no problem (through their connector). ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 5, 2022, 7:50am UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/10 "2022-11-05T07:50:35Z")
Did you do a test for MySQL? If not, try making a test for MySQL. It’s not just me that has this problem. Thanks to. ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 5, 2022, 8:57am UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/11 "2022-11-05T08:57:01Z")
Variables $1 do not work for me in any request. Works requests only with variables? ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 7, 2022, 5:29pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/12 "2022-11-07T17:29:42Z")
I decided to not be lazy this morning and setup and test this syntax on a MySQL DB. You are correct that there is an issue with the offset variable. Also as a note your original ? mark syntax is correct for MySql variable replacement, however when putting the variable in the offset it does incorrectly add quotes around the number which causes the error. I know these Bubble errors can really hold up a project so I banged my head against the wall trying a number of different syntax formats to find a solution for you, none of which worked. Your best option is to email support and let them know you have a confirmed bug and ask them to make a fix. Alternatively, if there is a way for your app to set a state variable rather than get data from API you could look into the plugin I mentioned (it is for reasons just like this one that we created it in the first place). Sorry I can’t be of more help. ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 7, 2022, 7:30pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/13 "2022-11-07T19:30:47Z")
Thanks, you confirmed my guess. I already wrote to the support service, waiting for a response. ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [November 14, 2022, 8:15pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/14 "2022-11-14T20:15:09Z")
I’m posting a Bubble support response here. To not waste time in vain. ![feb2b05f6a](https://us1.discourse-cdn.com/bubble/original/3X/b/e/be7409e280b48faa8ee42512a5eb6f35a8b7aa0d.jpeg) ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [November 14, 2022, 8:22pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/15 "2022-11-14T20:22:39Z")
Thanks for circling back around on this for the benefit of others. That response really doesn’t make any sense to me, but as I previously mentioned, it’s for exactly that kind of reason that we built our plugin and made it available for others. ---
**Author:** ![borjaobeso1](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/borjaobeso1/32/156576_2.png) [@borjaobeso1](https://forum.bubble.io/u/borjaobeso1)\ **Post date:** [March 28, 2023, 7:09pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/16 "2023-03-28T19:09:37Z")
Did you find a solution? I’m currently having the same issue. I need to use dynamic offset for pagination. Thanks! ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [March 28, 2023, 8:07pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/17 "2023-03-28T20:07:01Z")
@borjaobeso1 The only solution that I am aware of is to use our paid plugin (linked above). The official Bubble response was that they don’t support the OFFSET statement. ---
**Author:** ![wwweb2401](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/wwweb2401/32/79435_2.png) [@wwweb2401](https://forum.bubble.io/u/wwweb2401)\ **Post date:** [March 28, 2023, 8:07pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/18 "2023-03-28T20:07:51Z")
plugin does not support dynamic offset. I enlisted the help of a programmer who wrote a SQL query handler. The SQL Database Connector plugin is not suitable for the work done, it has many limitations. ---
**Author:** ![ben13](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@ben13](https://forum.bubble.io/u/ben13)\ **Post date:** [March 28, 2023, 8:10pm UTC](https://forum.bubble.io/t/sql-database-connector-connection-issues/231197/19 "2023-03-28T20:10:38Z")
@wwweb2401 or use our plugin noted above which does support dynamic offset.