April 20, 2011 at 7:31 am
When installing the x64 SQL 2008 native client, it also installs the 32bit binaries. How does the client applications determine which flavor is actually called? Is there a way to specify in the connection string?
April 20, 2011 at 8:50 am
It depends on whether the process is running in 32-bit or 64-bit mode. This is also true of DSNs. If you are referencing a DSN in your connection string when in 32-bit mode it will only be able to access the 32-bit user and system DSNs.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:04 am
Is your OS 32-Bit,Installation of SQL Server 2008 is same for both bits,it will automatically check the OS then install the required version,Its depend on the OS
x86
x64
xI64
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 9:08 am
Syed Jahanzaib Bin hassan (4/20/2011)
x86
x64
xI64
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5DThis is regarding the SQL Client, not the server service. The OP already mentioned that both the x86 and x64 client binaries were dropped.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:15 am
Yes thats why , if this OS 64bit then it will install the 64bit client otherwise 32bit,It will not install both NATIVE client
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 9:19 am
From MSDN http://msdn.microsoft.com/en-us/library/ms131321.aspx
The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client.
You can run processes in 32-bit mode on a 64-bit server. In that scenario the process needs the 32-bit version of the Native client which is why both are installed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:24 am
There is no 32bit Native client install on the 64bit OS and 64bit SQL Server installation,There is only 1 Native client available in the DSN window...
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 9:28 am
Syed Jahanzaib Bin hassan (4/20/2011)
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5DWhat technology did you say your MCITP was in again?
Which ODBC applet are you in, the 32-bit or the 64-bit applet? Do you know there are two?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:38 am
Take it easy man,we are here to provide solution ,dont take it personal,if I am wrong then leave me on my way.If you dont have any qualification thats not my responsibility.
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 9:41 am
Nothing personal...I do have qualifications, I just don't display them on my shirt sleeve (or in my forum signature). What's in a qualification anyway?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:49 am
In this MSFT article, it clearly states that the x64 client also installs the 32-bit binaries.
http://msdn.microsoft.com/en-us/library/ms131321.aspx
I can confirm that files exist under both %SYSTEMDRIVE%\Program Files and %SYSTEMDRIVE%\Program Files (x86).
The operating system is Windows Server 2008 x64 SP2. The application is actually running in x64 Apache Tomcat, and part uses the SQL Server JDBC driver, but another component requires the SQL native client. I really don't know if the process is 32-bit or 64-bit, but will investigate.
So my present understanding is that the process scope determines which SQL client binary is invoked?
Thanks,
Jared
April 20, 2011 at 9:52 am
You cant think Albert as just showing his name in your signature
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 9:57 am
jallmond (4/20/2011)
In this MSFT article, it clearly states that the x64 client also installs the 32-bit binaries.
That's the same article I linked to above.
So my present understanding is that the process scope determines which SQL client binary is invoked?
That is my understanding. A 32-bit process would not be able to load a 64-bit Native client binary, and vice-versa.
I am not sure how you can figure out whether your process is 32 or 64 bit.
Are you using DSN-less connections with JDBC? Even if you are, a quick cheat you can try is to setup a 32-bit DSN and try using it in your JDBC connection string. If it works you'll know you're in 32-bit.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 10:02 am
I didnt deny the installation of binaries,I was talking about Native Client only,How many Native client drive on your windows System
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 20, 2011 at 10:08 am
That's the same article I linked to above.
Sorry missed the link in the first pass.
I am not sure how you can figure out whether your process is 32 or 64 bit.
I'm thinking it could be as simple as launching Task Manager and examining the process to see if *32 appears in the image name. Thoughts?
Are you using DSN-less connections with JDBC? Even if you are, a quick cheat you can try is to setup a 32-bit DSN and try using it in your JDBC connection string. If it works you'll know you're in 32-bit.
I'm not sure I undersand DSN-less connections. I'm a .NET developer and never really worked with JDBC. Our Java developer provided me with the XML file that holds the connection attributes.
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:sqlserver://server:1433;DatabaseName=DB1;useCursors=true;appName=DefaultDS</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>user</user-name>
<password>password</password>
<check-valid-connection-sql>SELECT COUNT(*) FROM sysobjects</check-valid-connection-sql>
<background-validation-millis>10000</background-validation-millis>
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
Thanks,
Jared
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply