|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Run 32-bit and 64-bit instances on same machine
Is it possible to run 32-bit and 64-bit instances of sql
server 2008 on the same windows server 2008 instance? I searched and found this slide presentation that mentions that it is *not* possible under sql 2005: http://www.sdsqlug.org/presentations/November2006/November_2006_64-bit_SQL_Server.pdf I have an application that accesses a legacy data format using a linked server via 32-bit ODBC driver, so I need to run 32-bit sql server for that. Thanks in advance. I have not tried this myself. But I'd first check if I can configure the
linked server to use a 32-bit ODBC driver instead of installing a 32-bit instance just to accommodate that linked server. Linchi Show quoteHide quote "John" wrote: > Is it possible to run 32-bit and 64-bit instances of sql > server 2008 on the same windows server 2008 instance? > > I searched and found this slide presentation that mentions > that it is *not* possible under sql 2005: > > http://www.sdsqlug.org/presentations/November2006/November_2006_64-bit_SQL_Server.pdf > > I have an application that accesses a legacy data format > using a linked server via 32-bit ODBC driver, so I need > to run 32-bit sql server for that. > > Thanks in advance. > > > Hi Linchi,
Thanks for responding. The ODBC driver is 32-bit so I am unable to use it from 64-bit sql server. They do not have a 64-bit version of it. Microsoft does not provide a layer that will thunk from native 64-bit to 32-bit odbc running under WOW64. Show quoteHide quote "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message news:BB4EE5D0-88C7-4CCC-87AE-EFB174FBCB89@microsoft.com... >I have not tried this myself. But I'd first check if I can configure the > linked server to use a 32-bit ODBC driver instead of installing a 32-bit > instance just to accommodate that linked server. > > Linchi John
Do you mean , you cannot create a linked server between 64 and 32 bits? Show quoteHide quote "John" <john@donotspam.invalid> wrote in message news:eVadtY27JHA.4632@TK2MSFTNGP02.phx.gbl... > Hi Linchi, > > Thanks for responding. > > The ODBC driver is 32-bit so I am unable to use it from > 64-bit sql server. They do not have a 64-bit version of it. > > Microsoft does not provide a layer that will thunk from > native 64-bit to 32-bit odbc running under WOW64. > > "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message > news:BB4EE5D0-88C7-4CCC-87AE-EFB174FBCB89@microsoft.com... >>I have not tried this myself. But I'd first check if I can configure the >> linked server to use a 32-bit ODBC driver instead of installing a 32-bit >> instance just to accommodate that linked server. >> >> Linchi > > Should be able to, but check this post out for at least one reason why
people give up trying to make it work: http://is.gd/14yX0 On 6/17/09 12:16 PM, in article ean0wb27JHA.1***@TK2MSFTNGP03.phx.gbl, "Uri Dimant" <u***@iscar.co.il> wrote: Show quoteHide quote > John > Do you mean , you cannot create a linked server between 64 and 32 bits? > > > "John" <john@donotspam.invalid> wrote in message > news:eVadtY27JHA.4632@TK2MSFTNGP02.phx.gbl... >> Hi Linchi, >> >> Thanks for responding. >> >> The ODBC driver is 32-bit so I am unable to use it from >> 64-bit sql server. They do not have a 64-bit version of it. >> >> Microsoft does not provide a layer that will thunk from >> native 64-bit to 32-bit odbc running under WOW64. >> >> "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message >> news:BB4EE5D0-88C7-4CCC-87AE-EFB174FBCB89@microsoft.com... >>> I have not tried this myself. But I'd first check if I can configure the >>> linked server to use a 32-bit ODBC driver instead of installing a 32-bit >>> instance just to accommodate that linked server. >>> >>> Linchi >> >> > > Hi Uri,
I mean you cannot use a 32-bit odbc driver from a native 64-bit process. The driver in my case is Paradox, but the same holds true for others like Microsoft Excel, Microsoft Text, etc. It makes sense, the driver is a 32-bit dll, and a 64-bit exe cannot load a 32-bit dll into its process. Show quoteHide quote "Uri Dimant" <u***@iscar.co.il> wrote in message news:ean0wb27JHA.1716@TK2MSFTNGP03.phx.gbl... > John > Do you mean , you cannot create a linked server between 64 and 32 bits? > There is an option of running the driver out of the process. Worth checking
out if that would make it work. Linchi Show quoteHide quote "John" wrote: > Hi Uri, > > I mean you cannot use a 32-bit odbc driver from a native > 64-bit process. The driver in my case is Paradox, but the > same holds true for others like Microsoft Excel, Microsoft Text, > etc. > > It makes sense, the driver is a 32-bit dll, and a 64-bit exe > cannot load a 32-bit dll into its process. > > > "Uri Dimant" <u***@iscar.co.il> wrote in message > news:ean0wb27JHA.1716@TK2MSFTNGP03.phx.gbl... > > John > > Do you mean , you cannot create a linked server between 64 and 32 bits? > > > > > You might want to check out the following:
http://www.datadirect.com/products/data-connectivity/ms-sql-2005/index.ssp I don't know if this works, but they do show in that chart that they have an x64 driver that will work. It probably is not going to be inexpensive though. Jeff Show quoteHide quote "John" <john@donotspam.invalid> wrote in message news:OHQr#o27JHA.3860@TK2MSFTNGP05.phx.gbl... > Hi Uri, > > I mean you cannot use a 32-bit odbc driver from a native > 64-bit process. The driver in my case is Paradox, but the > same holds true for others like Microsoft Excel, Microsoft Text, > etc. > > It makes sense, the driver is a 32-bit dll, and a 64-bit exe > cannot load a 32-bit dll into its process. > > > "Uri Dimant" <u***@iscar.co.il> wrote in message > news:ean0wb27JHA.1716@TK2MSFTNGP03.phx.gbl... >> John >> Do you mean , you cannot create a linked server between 64 and 32 bits? >> > > Hi Jeff,
Thanks for the suggestion. I thought of them before, but ruled it out because it looked like they do not support old file-based formats (like Paradox, dBase, Btrieve, text, etc.) via 64-bit. Their 64-bit support matrix does not show Paradox or other file-based (all are wire-protocol): http://www.datadirect.com/products/odbc64/matrix/connect64odbc.htm I should probably send them an e-mail just to be certain. Show quoteHide quote "Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message news:OY9FVy77JHA.4100@TK2MSFTNGP06.phx.gbl... > You might want to check out the following: > http://www.datadirect.com/products/data-connectivity/ms-sql-2005/index.ssp > > I don't know if this works, but they do show in that chart that they have > an x64 driver that will work. It probably is not going to be inexpensive > though. > > Jeff It is not clear, but the link I gave you does list this as an option. Not
the top option or best option - but at least it states it is an option. Again, I have not used them and have no idea whether or not it will actually work. Good luck, Jeff Show quoteHide quote "John" <john@donotspam.invalid> wrote in message news:uV2afx97JHA.4404@TK2MSFTNGP04.phx.gbl... > Hi Jeff, > > Thanks for the suggestion. > > I thought of them before, but ruled it out because it looked > like they do not support old file-based formats (like Paradox, > dBase, Btrieve, text, etc.) via 64-bit. Their 64-bit support > matrix does not show Paradox or other file-based (all are > wire-protocol): > > http://www.datadirect.com/products/odbc64/matrix/connect64odbc.htm > > I should probably send them an e-mail just to be certain. > > "Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message > news:OY9FVy77JHA.4100@TK2MSFTNGP06.phx.gbl... >> You might want to check out the following: >> http://www.datadirect.com/products/data-connectivity/ms-sql-2005/index.ssp >> >> I don't know if this works, but they do show in that chart that they have >> an x64 driver that will work. It probably is not going to be inexpensive >> though. >> >> Jeff > > Jeff,
I double-checked with them, and they said they do not offer 64-bit Paradox. They would be willing to port their driver to 64-bit, however, we would have to pay for the port plus ongoing annual maintenance, etc. Anything more than a few thousand dollars is not worth it to us. Thanks again. Show quoteHide quote "Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message news:%23$qVdEC8JHA.1380@TK2MSFTNGP05.phx.gbl... > It is not clear, but the link I gave you does list this as an option. Not > the top option or best option - but at least it states it is an option. > > Again, I have not used them and have no idea whether or not it will > actually work. > > Good luck, > > Jeff That's too bad - thought it looked like they had something.
Jeff Show quoteHide quote "John" <john@donotspam.invalid> wrote in message news:eNerWzC8JHA.1424@TK2MSFTNGP02.phx.gbl... > Jeff, > > I double-checked with them, and they said they do not offer > 64-bit Paradox. They would be willing to port their driver > to 64-bit, however, we would have to pay for the port > plus ongoing annual maintenance, etc. > > Anything more than a few thousand dollars is not worth > it to us. > > Thanks again. > > "Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message > news:%23$qVdEC8JHA.1380@TK2MSFTNGP05.phx.gbl... >> It is not clear, but the link I gave you does list this as an option. >> Not the top option or best option - but at least it states it is an >> option. >> >> Again, I have not used them and have no idea whether or not it will >> actually work. >> >> Good luck, >> >> Jeff > >  
Other interesting topics
|
|||||||||||||||||||||||
