Error: Data source name not found and no default driver specified

RoyATokeshi
August 18, 2006 8:38 am

Citrix states in their article: CTX110813

Document ID: CTX110813, Created on: Aug 17, 2006, Updated: Aug 18, 2006

Products: Citrix Presentation Server 4.0 x64 Edition

Symptoms

In the Resource Manager log, the following is displayed after testing the connection on a 64-bit Citrix Presentation Server 4.0 Resource Manager Database Connection Server:

“Source [Microsoft OLE DB Provider for ODBC Drivers].
Description [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified].”

In the Citrix Management Console, the Test button in the Summary Database configuration shows:

“Server: consrv1
Server is up
Summary database software OK
DSN undefined
Database accessibility cannot be determined.”

Cause

The data source name (DSN) rmsummarydatabase has been created using Start > Control Panel > Administrative Tools > Data Sources (ODBC) on a 64-bit database connection server connecting to a 32-bit SQL database server.

Resolution

If a 64-bit Presentation Server 4.0 server connects to a summary database on a 32-bit SQL server, you must create a system DSN called rmsummarydatabase (this is not case-sensitive).

Using the Run dialog box, type %SystemRoot%\SysWow64\odbcad32.exe

Note: Do not use Start > Control Panel > Administrative Tools > Data Sources (ODBC).

More Information

See CTX105744 – Readme for Citrix Presentation Server 4.0 for Microsoft Windows Server 2003 x64 Edition.



Primary links

Custom Search

User login

Who's new

  • Choodogek
  • zepsleltpap
  • layersepavy
  • moneytome12
  • maczugaher

Who's online

There are currently 0 users and 4 guests online.

KrissysCorner.com RuthSwensonLaw.com CreativeLizardProductions.com

DISCLAIMER:

None of this has anything to do with us, someone else is responsible for the entire thing, and we have no idea who or why. We do not know anything about it. It may be alien life forms for all we know: we haven't a clue. You cannot blame us for anything that may result from your visit. That was entirely your own personal choice, made by you of your own volition, and without our knowledge. We do not, after all, have any control over you and cannot by any stretch of the imagination be expected to accept or acknowledge, be it legally or morally, any accountability for decisions made by you on an independent basis, utilizing your own free will, and without our intervention. We are therefore in no way, shape, or form answerable to anyone for any consequences arising from the aforementioned or indeed any other actions, similar or otherwise, because it was not us that did, or did not do anything. It is not even remotely our fault, and we are in no way prepared or willing to accept any liability, not even slightly, ever. We are, in fact completely and utterly blameless, in that it is definitely not our concern, and no blame can possibly be laid at our doorstep, even if we had one, the possession of which we hereby reserve as being entirely our own free choice. The onus is not on us at all, and furthermore, never has been. The entire matter is wholly beyond our control, and completely out of our hands, each of which are washed scrupulously clean of the whole business. We are not accountable for anything at all, and we hereby categorically deny all responsibility for all that has ever, or will ever happen. Our innocence is therefore wholly beyond doubt and absolutely unimpeachable, and so cannot, under even the remotest or unlikeliest circumstances, be brought into question. By clicking either on a link on this site, clicking on a link that leads to this site, or by arriving at this site by natural or supernatural means, you are in effect accepting responsibility for the fact that it is all entirely your own fault, down to the most miniscule detail, and that you are wholly accountable for whatever outcome may arise as a consequence of the aforementioned action or actions insofar as they were undertaken personally by you on an entirely voluntary basis and without any persuasion, coercion or influence from any party or parties other than yourself. Don't come sniveling to us, we are only figments of your imagination. I also agree that if I am ever with a contributor to this website during mealtimes I agree to pay for any super-sizing of their meal, or at least a nice dessert or one of those foo-foo drinks with an umbrella or a monkey. By admitting to have seen the worthless spineless drivel on this website (also known as content)

I Agree Wholeheartedly and Without Reservation to the above. (Except maybe for that part about the monkey.)

All Your Base Are Belong To Us.

Soylent Green Is People!

Never make a bet with a Sicilian when Death is on the Line!

No. Really, I do agree.