The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Extracting data from SQLEXPRESS

Is there another way to extract data from the free SQL Server product aside from the .NET interface? I'd like to put a small app in it, but then make the data available to server processes that might be located on a Unix machine, for example.

Is this doable at all, or should I just stick to the Oracle that I'm familiar with?
Steve Hirsch Send private email
Wednesday, July 11, 2007
 
 
ODBC?

Wednesday, July 11, 2007
 
 
Steve,

What database technologies are you familiar with? Microsoft has a JDBC connector for SQL Server, which should work with SQLEXPRESS just as well.
Slartibartfast Send private email
Wednesday, July 11, 2007
 
 
Here's the URL for that JDBC driver:

http://msdn2.microsoft.com/en-us/data/aa937724.aspx
Slartibartfast Send private email
Wednesday, July 11, 2007
 
 
OK, thanks, I'm so used to Oracle it seems like my brain went blank.
Steve Hirsch Send private email
Wednesday, July 11, 2007
 
 
The standard oledb driver for sql 2000 works fine (well for delphi at least!)
Chris goCRM Send private email
Thursday, July 12, 2007
 
 
Now I remember what I was getting at. Is there a feature in SQL Server (and Express) akin to the database links in Oracle, whereby one database instance can query another directly?
Steve Hirsch Send private email
Thursday, July 12, 2007
 
 
try googling "SQL Server linked server"
Honu Send private email
Friday, July 13, 2007
 
 
Thanks. That's what I was looking for.
Steve Hirsch Send private email
Friday, July 13, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz