Posts Tagged “sql server”On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled. If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this: In ordrer to enable TCP/IP you have to do a few steps:
22
05
2009
 
SQL Server 2005 named instance in Oracle SQL DeveloperPosted by: Andrei in Database, OracleI’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange. A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“. |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
Powered by WordPress, Mandigo theme by tom.
Entries (RSS)
and Comments (RSS).
73 queries. 19.479 seconds.
