In bit releases of Windows, there are both bit and bit versions of the Data Source Administrator. I am able to connect to it and then preview the report through BIDS and it works. Maybe you are running bit ODBC driver in bit mode. I recently set up a test sytem of 2 servers both 64bit on Windows Server R2. Whether it’s an embeded data source or shared, the error message I get with the above connection string is:
|Date Added:||1 January 2006|
|File Size:||45.13 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
I’m not sure, what, if anything, I’m doing wrong.
If i can’t get it to work, is trying to set this up as a Data Processing Extension using the InterSystems Cahce Provider assembly something I should look into? This allows some Microsoft applications to allocate the properly sized buffers to hold multibyte data.
Debug Start Debuggingand report on whether the connection manager is able to connect there?
Caché ODBC Driver FAQ
When selected, specifies the use of the current locale’s decimal separator; not checking this sets the decimal separator in the process to a period “. Sign in to vote. Wednesday, May 16, Sunday, July 29, The default for InterSystems is To check this quickly: If you are only using single-byte interxystems set data, do not select this check box.
Validation phase is beginning. Could odgc please tell me what exactly you have done? The fields are listed below and are required unless otherwise specified:. Stil not able to connect. Sign in to vote. Are you running as the same user as you’re designing with? This log is for troubleshooting; you should not turn logging on during normal operation as it will dramatically slow down ODBC performance. If an operation does not finish oxbc the specified time, it is automatically cancelled.
Caché ODBC Driver FAQ | InterSystems
I have also tried the following connection string which also tests successfully but then fails when I run the package:. A popup window will display information on ping success or failure. Also if you’re running under Vista, are you running the package as an Administrator?
AcquireConnections Object transaction at Microsoft. FYI, my machine is my report server and intersystem cache is different.
I have the InterSystems Cache driver installed on my personal PC which is required to open up any of our Excel Documents that are pulling data from intersjstems Cache system.
That is exactly what was happening, the driver is only bit! Tuesday, May 15, 9: Friday, December 5, Defines all connection information directly in the connection string.
I installed both 32 and After you have created the DSN, you can use the Test Connection button to see if your data source is working correctly. This functionality is only relevant if you are working with a multibyte character set, such as in Chinese, Hebrew, Japanese, or Korean locales. Wednesday, May 11, 5: In bit releases of Windows, there are both bit and bit versions of the Data Source Administrator.
It will be very beneficial for other community members who have similar questions.