Re: freeTDS to access sqlserverExpress
"Duncan Kerr" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
James Can I use freetds to query Oracle? Duncan Kerr NYSE Technologies t +44 (0)20 7655 7214 > -----Original Message----- > From: [email protected] [mailto:freetds- > [email protected]] On Behalf Of James K. Lowden > Sent: 19 March 2009 13:21 > To: FreeTDS Development Group > Subject: Re: [freetds] freeTDS to access sqlserverExpress > > Duncan Kerr wrote: > > it returns null as you suggested. Does that > > mean I can't use the instance option in .freetds.conf, or do I need to > > do something else to point to a NULL server? > ... > > lxdevws85 apps% tsql -S mcdb -U FUENV4\\fuadmin -P ful1ffe -Lv > > locale is "C" > > locale charset is "ANSI_X3.4-1968" > > 1> select serverproperty('InstanceName') > > 2> go > > > > NULL > > (1 row affected) > > Before there were Instances, we all used Port. That's still a safe bet: > if you know the port, you might as well use it. > > Technically, you could use the name of the default instance instead. Your > server should return the name of all instances, including the default, > using the tsql command I provided (assuming a recent snapshot). Or you > could ask your friendly DBA. > > But I wouldn't bother. If you know the port, why not use it? It's simple > and explicit, and it's not going to change. > > HTH. > > --jkl > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds