sql server management studio express 32 bit or 64 bit....
-
Hi all, Am running a open row set query in my "sql server management studio express". Am getting an error "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".". I think the open row set stored procedure. will work only in 32 bit. So, I want to know whether 1)How cam i know my "SQL server ' is 32bit or 64bit? 2)My OS is Windows xp in my computer?Could that be the reason? 3)How can i know whther Windows Xp is 32 bit or 64bit? Any infprmation will be helpful Thanking You
-
Hi all, Am running a open row set query in my "sql server management studio express". Am getting an error "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".". I think the open row set stored procedure. will work only in 32 bit. So, I want to know whether 1)How cam i know my "SQL server ' is 32bit or 64bit? 2)My OS is Windows xp in my computer?Could that be the reason? 3)How can i know whther Windows Xp is 32 bit or 64bit? Any infprmation will be helpful Thanking You
new2pgrmg wrote:
Am getting an error "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".".
Your error is something else. Your linked server configuration has some problem. Does it have data transfer access?
new2pgrmg wrote:
1)How cam i know my "SQL server ' is 32bit or 64bit?
In management studio, execute @@Version, this will tell you if SQL Server is 32 bit or 64 bit.