| Author |
Topic |
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
 Posted - 2008-03-02 : 21:50:30
|
| Hi everyone. I have a question.I have an installer that runs seamlessly in any 32bit -x86 OS. But if I tried to run the exe(installer) to any 64bit OS, yeah it runs and creates a database, but does not create a tables on it... The installer is compiled in a platform 32bit OS.Do you have any idea about this? Do I need to recompile the application in a 64bit OS?RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-02 : 22:20:55
|
does your installer log errors anywhere? if so post them.
elsasoft.org |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-03-02 : 22:27:00
|
| It does not create a log error eventhough I have coded the catch exemption in my application.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-02 : 22:36:19
|
profile the server when you run your installer, see if the statements are being sent.
elsasoft.org |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-03-02 : 23:01:59
|
| This is the trace in xml. <?xml version="1.0" encoding="utf-16" ?> - <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">- <Header> <TraceProvider name="Microsoft SQL Server" MajorVersion="9" MinorVersion="0" BuildNumber="3042" /> <ServerInformation name="sdmcserver" /> - <ProfilerUI>- <OrderedColumns> <ID>27</ID> <ID>1</ID> <ID>12</ID> <ID>14</ID> <ID>2</ID> </OrderedColumns>- <TracedEvents>- <Event id="14"> <EventColumn id="1" /> <EventColumn id="14" /> <EventColumn id="12" /> </Event>- <Event id="15"> <EventColumn id="14" /> <EventColumn id="12" /> </Event>- <Event id="17"> <EventColumn id="12" /> <EventColumn id="1" /> <EventColumn id="14" /> </Event>- <Event id="11"> <EventColumn id="2" /> <EventColumn id="14" /> <EventColumn id="12" /> </Event>- <Event id="13"> <EventColumn id="12" /> <EventColumn id="1" /> <EventColumn id="14" /> </Event> </TracedEvents> </ProfilerUI> </Header>- <Events>- <Event id="11" name="RPC:Starting"> <Column id="1" name="TextData">exec sp_reset_connection</Column> <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.687+08:00</Column> </Event>- <Event id="15" name="Audit Logout"> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:56:07.187+08:00</Column> </Event>- <Event id="14" name="Audit Login"> <Column id="1" name="TextData">-- network protocol: LPC set quoted_identifier on set arithabort off set numeric_roundabort off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set cursor_close_on_commit off set implicit_transactions off set language us_english set dateformat mdy set datefirst 7 set transaction isolation level read committed</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.687+08:00</Column> </Event>- <Event id="13" name="SQL:BatchStarting"> <Column id="1" name="TextData">CREATE DATABASE BIZBOXDBHS8</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.687+08:00</Column> </Event>- <Event id="11" name="RPC:Starting"> <Column id="1" name="TextData">exec sp_reset_connection</Column> <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.747+08:00</Column> </Event>- <Event id="15" name="Audit Logout"> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.687+08:00</Column> </Event>- <Event id="14" name="Audit Login"> <Column id="1" name="TextData">-- network protocol: LPC set quoted_identifier on set arithabort off set numeric_roundabort off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set cursor_close_on_commit off set implicit_transactions off set language us_english set dateformat mdy set datefirst 7 set transaction isolation level read committed</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.747+08:00</Column> </Event>- <Event id="13" name="SQL:BatchStarting"> <Column id="1" name="TextData">CREATE DATABASE BIZBOXDBHS8_TRAINING</Column> <Column id="12" name="SPID">52</Column> <Column id="14" name="StartTime">2008-03-03T11:57:33.747+08:00</Column> </Event> </Events> </TraceData>RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-02 : 23:57:20
|
did you step through your code in a debugger to make sure it's actually executing the sql you think it should be executing?
elsasoft.org |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-03-03 : 00:13:26
|
| We have Windows XP Professional (32-bit) machines which we use for development purpose, on which we will compile our application(32-bit) code using Visual Studio 2005, which builds and works really fine on the developer machines.The Production Server has got Windows 2003 (64-bit) machine, that’s why the code which compiles on the developer machines fails on this server.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-03 : 08:52:40
|
ok, so step through it in the debugger on a 64 bit machine to find out what's going on.
elsasoft.org |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-03-05 : 02:57:42
|
| Thanks jez. I found out that the DLLs compiled in a x32 OS is different from x64 OS. Thanks for the time.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
|
my installer