Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Windows CE 5.0 connecting to MSSQL 2005 64 bit

Posted on 2009-04-14
2
293 Views
Last Modified: 2012-05-06
Hi all.

We have a client that installed a MS SQL 2005 64bit DB on a server. We traditionally use only the 32 bit version so this is a new field for us. But first, a quick walkthrough.

We have proprietary software which various devices connect to. It's simply a production database running behind it, the interface and backend is all Microsoft based. That is, MSSQL DB, Windows server etc.
We have scanners which can be either CE or Windows mobile. On the scanners, we install a program which handles the communication with the SQL server (sending the barcode string to correct  receiver).

When testing this 64 bit server I haven't come across any problems except with the scanner. When I select the program it gives me the standard generic SQL Connection error. Unfortunately I do not have a screenshot or a test that I can post, I hope that will not be a problem. But basically it is "

Now, my question is, do I need to have my connection string reprogrammed/redone whatever by the programmers or is this something more sinister, like there not being a DLL that handles communication of this type? Sorry for this maybe a stupid question, but I haven't been able to find anything relevant by googling.

Thanks.
0
Comment
Question by:rattati
2 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24154369
Named Pipes and TCP/IP is over TCP/IP (network), which doesn't care about 32 or 64 bit. So it should not have anything to do with the server being 64 bit.
I definitely have 32 bit SQL Server drivers connecting to a 64 bit SQL Server.
There's two things you can try:
1. Run SQL Server Profiler on the SQL Server and seee if you can see the device trying to connect.
2. Try and get more info from the device - can you ping the server, get through the firewalll etc. Are any log files created by this software?
0
 

Accepted Solution

by:
rattati earned 0 total points
ID: 24199085
Hi all.
I did find the solution and it has nothing to do with the connection string itself, as I feared. The connection was good - 32 to 64 bit was no problem at all. The problem was in the application itself (on the server) so when I focused on that particular bit I found the application configuration error and fixed that.
Thanks everyone, especially nmcdermaid and sorry for wasting your time.
Cheers all.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Set the max value for a column 7 39
Error when saving to sql table a '/' 5 29
Query to return total 6 21
Find results from sql within a time span 11 46
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question