November 21, 2003 at 3:28 am
Hi
I have a VB6 SQL Server 2000 app, and utilise the sqldmo and sqldts libraries for the control of DTS packages. The application is to be installed on machines with and without SQL libaries installed (ie. "clean" machines, and those with SQL Client Tools and/or SQL Server installed). So during setup (created using Installshield) I check whether SQL is present on the target machine or not - then install the required libraries if needed. This works fine.
*BUT* (!)
When installing to a machine that has SQL Server installed (and Client Tools) but is configured with a different resource setting, the app falls over with "Unexpected Error".
My development machine and server is configured to a resource folder number of 1033, whereas the target machine is configured to 2057. I understand a little about codepages/character sets and SQL collations but can't figure out why this should impact the object libraries I'm trying to use.
Does anyone have any ideas please?
Thanks in advance,
Chris
There are only 10 types of people in the world. Those that understand binary and those that don't.
There are only 10 types of people in the world. Those that understand binary and those that don't.
November 24, 2003 at 9:51 am
Not sure myself. Every SQL Server install I've seen in the US has resource 1033.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply