Solved

Windows CE 5.0 connecting to MSSQL 2005 64 bit

Posted on 2009-04-14
2
296 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
[X]
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
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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