Sql server access in SIM on RES 5 / Windows 7

[jd11111]

Hoping someone has run into this one already and can help.

I have a SIM that uses SQL Server Native Client to connect to a SQL Server database to retrieve and update data. This works on RES 5.1 on Windows XP. However, on Windows 7 64 bit, I'm getting "input/output error" when attempting to get data. I have installed the 64-bit Sql Server native client 10.0 and tested the connection in ODBC Data Sources successfully.

What am I missing here?

 

[pmegan]

You probably have to run it through the 32 bit version of the SQL Server client. Res is running as a 32 bit application, so won't be able to access the 64 bit drivers.

 

[jd11111]

Thank you, pmegan. I tried installing the 32 bit client and it wouldn't allow it. Is there a 32 bit version that gets installed with the 64 bit client?

 

[pmegan]

I'm hoping you have an ODBC connection set up for your SIM to access, otherwise I wouldn't know where to start.

The ODBC connection is what has to be set up on the 32 bit side. I don't think it will work if you set it up through the Windows Control Panel. Go to the SysWOW64 folder, C:\Windows\SysWOW64\, and run odbcad32.exe. Set up a System ODBC connection to your SQL Server from there. That's about as far as I've had to go with this kind of thing, so I hope that works for you.

 

[jd11111]

Thanks pmegan. I was just figuring out how to access the 32 bit odbc configuration when you posted that! Turns out my error was actually due to logging from the sim. I'll have to track that down, but at least I have the database connection working.

Thanks again!

 

[pmegan]

Good deal. If the path for your logging is there the problem may be permissions. Try giving full access to that folder to everyone while you're testing it. Win7 security is the leading cause of premature baldness these days.

 

[Moregelen]

I don't really have anything to add except to lol over:

"Win7 security is the leading cause of premature baldness these days."


You haven't had to deal with setting many windows 8 computers up for store managers have you

 

[pmegan]

See, now that's one of the nice things about being on my side of the business rather than yours. Our managers don't get to pick their computers or OS; we give them what they're going to use, so no Windows 8 yet.

 

[Moregelen]

*Is now Jealous*

Hahah... true, true. You get a lot of perks being on your side of the business