Currently looking at deployment options for Windows 7. One of the questions we're looking into is 32 bit vs 64 bit. I'm trying to run a SCCM report against our estate to identify which machines are 64-bit capable (whether or not they're currently running a 64-bit OS).There seem to be a few resources out on the net for this (, and ) but none of them seem to work right on machines running 32-bit Windows XP. I had a feeling that posting on here would be what made me find the actual answer myself!Have found a property of the system processor that seems to answer the question exactly right on all OS's I've tested with (server & workstation from XP/2003 up).
Generally all you need to get up and running on X64 machine is to natigate to, scroll down to 'Microsoft SQL Server 2008 Native Client' section and install X64 package. Upon completion you will get both X86 and X64 drivers installed. Installer will generally lay down 3 files: sqlncli10.dll, sqlncli10r.rll and sqlncli10.chm. You should see two sqlncli10.dll - one in%WINDIR%System32 and the other in%WINDIR%SysWOW64. To test x86 driver you need x86 application.
How To Install Sccm Client On Windows 7 64 Bit Indir
Likewise to use x64 driver you need x64 application. OLE DB provider name is SQLNCLI10. If you specified everything correctly and your application is throwing REGDBECLASSNOTREG error code please check your system event log for any issues. On top of that you may try navigating to sqlncli10.dll file in either System32 or SysWOW64 and running regsvr32.exe sqlncli10.dll. This would re-register OLE DB COM server. Hope this helps. I use PowerBuilder 11.2 and have been going at this in their forum as well so forgive for not giving all the details.
I did find that info in my online searching and was able to successfully configure SNC through ODBC and connect using ODBC from my app. However, I don't want to use ODBC so that leaves us where I started. Someone on the PB forum gave a sample connection string that they stated worked for them in my scenario but it didn't workfor me.:-( That same connection string works fine on my Vista machine. At this point I'm going to try some other Windows 7 machines to see if it is just a peculiarity of this machine I'm testing on. I'll be working on that over the next few days but any debugging or other advice is very welcome! In case anyone has PB experience here is my setup: // Initialize this SQLCA - SNC sqlca.DBMS = 'SNC SQL Native Client(OLE DB)' sqlca.Database = ' sqlca.LogID = 'sa' sqlca.LogPass = '.'
sqlca.UserID = ' sqlca.DBPass = ' sqlca.Lock = ' sqlca.DbParm = 'Provider='SQLNCLI10'; Database='Longbow'; User Id=sa; Password=.' sqlca.Autocommit = true ( the servename is be pulled from an.ini file) Shawn. Generally all you need to get up and running on X64 machine is to natigate to, scroll down to 'Microsoft SQL Server 2008 Native Client' section and install X64 package. Upon completion you will get both X86 and X64 drivers installed. Installer will generally lay down 3 files: sqlncli10.dll, sqlncli10r.rll and sqlncli10.chm. You should see two sqlncli10.dll - one in%WINDIR%System32 and the other in%WINDIR%SysWOW64. To test x86 driver you need x86 application.
Likewise to use x64 driver you need x64 application. OLE DB provider name is SQLNCLI10. If you specified everything correctly and your application is throwing REGDBECLASSNOTREG error code please check your system event log for any issues.
On top of that you may try navigating to sqlncli10.dll file in either System32 or SysWOW64 and running regsvr32.exe sqlncli10.dll. This would re-register OLE DB COM server. Hope this helps.