# Connectivity Issue **URL:** \ **Category:** CData Drivers\ **Tags:** question\ **Created:** [July 3, 2023, 7:49am UTC](https://community.cdata.com/t/connectivity-issue/233 "2023-07-03T07:49:00Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 3, 2023, 7:49am UTC](https://community.cdata.com/t/connectivity-issue/233/1 "2023-07-03T07:49:01Z")
I am trying to connect my Neo4j Data with SQL server. I found that there are 2 options: 1. CData Connect  2. CData ODBC But for both I cannot connect my Neo4j Data. The following message is being shown: “Test connection failed. Error: Testing connection failed. Inner Error: Test Connection: Connection closed.” ---
**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\ **Post date:** [July 3, 2023, 7:51pm UTC](https://community.cdata.com/t/connectivity-issue/233/2 "2023-07-03T19:51:59Z")
@mamoonsaleem Thank you for reaching out. To confirm, have you been able to configure a connection to Neo4j as described in the link below? For the ODBC driver, you would then need to set up a linked server to connect it to SQL. Instructions on this are also provided below. Configure connection: [https://cdn.cdata.com/help/LNJ/odbc/pg\_connectiono.htm](https://cdn.cdata.com/help/LNJ/odbc/pg%5C_connectiono.htm) Linked server: [https://www.cdata.com/kb/tech/neo4j-odbc-linked-server.rst](https://www.cdata.com/kb/tech/neo4j-odbc-linked-server.rst) If the issue persists, however, as this is more technical in nature, please reach out to our support team at [support@cdata.com](mailto:support@cdata.com) so we can take a deeper look at troubleshooting. When you reach out, please provide screenshots of the error message along with any relevant configurations so we can assist with this further. ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 4, 2023, 6:44am UTC](https://community.cdata.com/t/connectivity-issue/233/3 "2023-07-04T06:44:18Z")
Yes I went through these steps but it is giving an error of ‘Connection closed’. I am using trial version right now and it will end soon as in this time I need to confirm that it works for me or not so I can purchase for future use. Please resolve the query as soon as possible. ---
**Author:** ![Orges\_Muzhaqi](https://avatars.discourse-cdn.com/v4/letter/o/919ad9/32.png) [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Post date:** [July 4, 2023, 2:54pm UTC](https://community.cdata.com/t/connectivity-issue/233/4 "2023-07-04T14:54:19Z")
Hi @mamoonsaleem , The error you encountered is due to your attempt to use the BOLT protocol with port 7687. However, our CData ODBC Driver for Neo4j only supports the HTTP API, as stated in the driver’s [online documentation](https://cdn.cdata.com/help/LNJ/odbc/RSBNeo4j_p_Server.htm). To resolve this issue, please ensure that HTTP is enabled in your Neo4j instance. When establishing a connection, set the port to its default value of 7474. ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 7:10am UTC](https://community.cdata.com/t/connectivity-issue/233/5 "2023-07-05T07:10:39Z")
Thank you, That totally worked. But while connecting with the new linked server I am coming with the following error, Although I have already initiated TDS remoting service. I am providing with the error screenshot and other relevant screenshots ![1bd9a235-840b-437c-a797-570d1ea2c5c3.png](https://us1.discourse-cdn.com/cdata/original/1X/de3056e81e9d020b2c3e58495821fae4838f776a.png) ![3d0a99c7-c207-4717-92ae-6b508947d770.png](https://us1.discourse-cdn.com/cdata/original/1X/81c2591a73d5e21488a0484c48ce6c1a486da833.png) ![6ca0ba8a-25e9-47e3-9807-3154acf0ac14.png](https://us1.discourse-cdn.com/cdata/original/2X/6/676e5df142ab6f6cf994d291de1cab9efca86132.png) Thanks ---
**Author:** ![Orges\_Muzhaqi](https://avatars.discourse-cdn.com/v4/letter/o/919ad9/32.png) [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Post date:** [July 5, 2023, 9:12am UTC](https://community.cdata.com/t/connectivity-issue/233/6 "2023-07-05T09:12:41Z")
Hi @mamoonsaleem , I have a few points to address: 1. If you are using a 64-bit operating system, I recommend opening the 64-bit version of ODBC Data Sources and configuring the CData Neo4j Sys 64-bit. 2. Please ensure that the port number you assign to the service in the SQL Gateway is different from the port number used by the locally installed SQL Server. 3. When creating a linked server in SSMS, after specifying the General information, navigate to the Security setting. Select “Be made using this security content” and provide the login credentials (username and password) for the user you created in SQL Gateway. For more detailed instructions, please refer to this link: [Connect to Neo4J Data as a Linked Server (cdata.com)](https://www.cdata.com/kb/tech/neo4j-odbc-linked-server.rst). ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 9:29am UTC](https://community.cdata.com/t/connectivity-issue/233/7 "2023-07-05T09:29:17Z")
I followed the steps. but no lead ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 10:03am UTC](https://community.cdata.com/t/connectivity-issue/233/8 "2023-07-05T10:03:49Z")
![5b5385fe-f46d-46d4-82e4-179fa8c0c75a.png](https://us1.discourse-cdn.com/cdata/original/2X/4/432be40087273f4233c0f31ad8b6b9d0dd035a98.png) ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 10:04am UTC](https://community.cdata.com/t/connectivity-issue/233/9 "2023-07-05T10:04:48Z")
![a527b214-a9df-40dc-b04e-b11bfe9ccb18.png](https://us1.discourse-cdn.com/cdata/original/2X/6/6e5dd74f5f32f3e5204e1b307fcaa3b0fe764fc5.png) ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 10:04am UTC](https://community.cdata.com/t/connectivity-issue/233/10 "2023-07-05T10:04:57Z")
No, I am not facing that issue currently as my server is connected(thanks to you) but the query is not running and the tables are not visible on SSMS ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 12:45pm UTC](https://community.cdata.com/t/connectivity-issue/233/11 "2023-07-05T12:45:58Z")
![6405a89f-36c7-498c-b28a-bca5d58d1df1.png](https://us1.discourse-cdn.com/cdata/original/2X/2/238e7d798f6b51c043ed07d437bd2ab18d4e3255.png) ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 12:46pm UTC](https://community.cdata.com/t/connectivity-issue/233/12 "2023-07-05T12:46:31Z")
![95dd2501-43b3-4091-986c-67f574038d55.png](https://us1.discourse-cdn.com/cdata/original/2X/2/27cf9923f2d57627e5525bafc627bc75d8f8d702.png) ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 12:48pm UTC](https://community.cdata.com/t/connectivity-issue/233/13 "2023-07-05T12:48:25Z")
![937fc307-8398-4dca-bf55-a2540cc1780d.png](https://us1.discourse-cdn.com/cdata/original/2X/2/2fb17417c8453506c0be9e6a75b02e47b3fecf3b.png) ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 5, 2023, 1:22pm UTC](https://community.cdata.com/t/connectivity-issue/233/14 "2023-07-05T13:22:14Z")
![9b739679-931d-4090-b83b-6534ac96816a.png](https://us1.discourse-cdn.com/cdata/original/1X/21b2f6fb81a463466c3072243b6edcb90d2d151a.png) ---
**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\ **Post date:** [July 5, 2023, 1:22pm UTC](https://community.cdata.com/t/connectivity-issue/233/15 "2023-07-05T13:22:35Z")
@mamoonsaleem To confirm, is your query now able to succeed? If the tables continue to not appear, then it would be helpful to have logging to look further into this issue. Please reach out to our support team at [support@cdata.com](mailto:support@cdata.com) for instructions on how to generate logging so they can assist with this further. ---
**Author:** ![Orges\_Muzhaqi](https://avatars.discourse-cdn.com/v4/letter/o/919ad9/32.png) [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Post date:** [July 5, 2023, 2:54pm UTC](https://community.cdata.com/t/connectivity-issue/233/16 "2023-07-05T14:54:53Z")
​ Hi @mamoonsaleem , Just for clarification, the labes will be visible on ‘Views’ because our CData ODBC Driver for Neo4j currently is ‘read-only’. This means that all labes will be teated as views since you cannot Insert, Update or Delete their data. ​Regarding the other issue, I suggest you incorporate OPENQUERY into your SQL statement. Here’s an example of the query you were attempting to execute: **SELECT \* FROM OPENQUERY(FINOSYS, ‘SELECT \* FROM [FINOSYS].[CData Neo4j Sys].[Neo4j].[Color]’).** ---
**Author:** ![mamoonsaleem](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mamoonsaleem](https://community.cdata.com/u/mamoonsaleem)\ **Post date:** [July 6, 2023, 6:07am UTC](https://community.cdata.com/t/connectivity-issue/233/17 "2023-07-06T06:07:48Z")
Query: **SELECT \* FROM OPENQUERY(FINOSYS, ‘SELECT \* FROM [FINOSYS].[CData Neo4j Sys].[Neo4j].[Color]’)** Error: OLE DB provider “SQLNCLI11” for linked server “FINOSYS” returned message “Deferred prepare could not be completed.”. Msg 0, Level 20, State 1, Line 1 The database ‘FINOSYS.CData Neo4j Sys’ doesn’t exist. Completion time: 2023-07-05T23:04:32.9564016-07:00 Query: SELECT COUNT(\*) FROM [FINOSYS].[CData Neo4j Sys].[Neo4j].[Color] Result: Null