Thread: Problems with ODBC driver and MSSQL

Problems with ODBC driver and MSSQL

From
mike
Date:
Hi I have loaded the latest pg ODBC driver on an NT machine.
The problem is that now the MSSQL ODBC driver has ceased working - has
anyone come across this problem / know of a workaround



Re: Problems with ODBC driver and MSSQL

From
Bruce Momjian
Date:
Oops, that is bad.  Someone?

Is there more information about the problem?


> Hi I have loaded the latest pg ODBC driver on an NT machine.
> The problem is that now the MSSQL ODBC driver has ceased working - has
> anyone come across this problem / know of a workaround
>  
> 
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


RE: Problems with ODBC driver and MSSQL

From
Michael Ansley
Date:
<p><font size="2">It's possible that you installed the driver manager as well as the driver, which could screw things
upa bit.  If that is the case, best to just get the latest SQL Server driver from MS, and install, it should replace
thedriver manager as well.</font><p><font size="2">To get the driver manager details, go to Control Panel | ODBC [or
DataSources] | About and look at the Driver Manager line.  This will give you the current version number.  Check
againstwhat the MSSQL driver wants.</font><p><font size="2">Cheers...</font><br /><p><font size="2">MikeA</font><br
/><br/><br /><p><font size="2">-----Original Message-----</font><br /><font size="2">From: Bruce Momjian [<a
href="mailto:pgman@candle.pha.pa.us">mailto:pgman@candle.pha.pa.us</a>]</font><br/><font size="2">Sent: 12 February
200113:02</font><br /><font size="2">To: mike</font><br /><font size="2">Cc: pgsql-interfaces@postgresql.org</font><br
/><fontsize="2">Subject: Re: [INTERFACES] Problems with ODBC driver and MSSQL</font><br /><p><font size="2">Oops, that
isbad.  Someone?</font><p><font size="2">Is there more information about the problem?</font><br /><p><font
size="2">>Hi I have loaded the latest pg ODBC driver on an NT machine.</font><br /><font size="2">> The problem
isthat now the MSSQL ODBC driver has ceased working - has</font><br /><font size="2">> anyone come across this
problem/ know of a workaround</font><br /><font size="2">>  </font><br /><font size="2">> </font><br /><font
size="2">></font><br /><p><font size="2">-- </font><br /><font size="2">  Bruce Momjian                        |  <a
href="http://candle.pha.pa.us"target="_blank">http://candle.pha.pa.us</a></font><br /><font size="2"> 
pgman@candle.pha.pa.us              |  (610) 853-3000</font><br /><font size="2">  +  If your life is a hard drive,    
| 830 Blythe Avenue</font><br /><font size="2">  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026</font><code><fontsize="3"><br /><br /> **********************************************************************<br
/>This email and any files transmitted with it are confidential and<br /> intended solely for the use of the individual
orentity to whom they<br /> are addressed. If you have received this email in error please notify<br /> Nick West -
GlobalInfrastructure Manager.<br /><br /> This footnote also confirms that this email message has been swept by<br />
MIMEsweeperfor the presence of computer viruses.<br /><br /> www.mimesweeper.com<br />
**********************************************************************<br/></font></code>