linked server using JDBC?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » linked server using JDBC?

linked server using JDBC?

Rate Topic

Display Mode

Topic Options

Author

Message

bruce-347665

Posted Thursday, October 04, 2012 1:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:03 AM
Points: 9, Visits: 135

ca I create a linked server in MSSQL 2008 using a JDBC driver (located in a file)? How?

Post #1368673

bruce-347665

Posted Friday, October 05, 2012 10:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:03 AM
Points: 9, Visits: 135

no idea?

Post #1369191

opc.three

Posted Monday, October 08, 2012 9:45 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 6,826, Visits: 11,950

Not directly. Linked Servers use OLE DB providers only. I did a quick Google session looking for an OLE DB Provider for JDBC but cameup empty.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1370145

Jon.Morisi

Posted Thursday, February 07, 2013 12:20 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 10:44 AM
Points: 276, Visits: 685

I know it's an old topic, but you can try and do it the other way. Use JDBC from what you were linking to, and query SQL from the other end.

Post #1417303

« Prev Topic | Next Topic »

Permissions