• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 959
  • Last Modified:

How do configure a linked server to connect to a H2 database

I am trying to connect to a database from Sql Server using the linked server feature. What should I select for the provider in the other data source section?
The H2 database is accessed through a web browser and the url is jdbc:h2:tcp://localhost:1521/tom  and the driver class is org.h2.Driver

How do configure a linked server to connect to the H2 database
0
sikyala
Asked:
sikyala
  • 2
1 Solution
 
sikyalaSenior Database AdministratorAuthor Commented:
Are you saying use the db2 configuration to link to the h2 database? How exactly would that work. when I try to create a new linked server I don't see the data source for db2. So if i use the commands in the link you provided would it work?
0
 
sikyalaSenior Database AdministratorAuthor Commented:
no response
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now