c# - using SQL Server Management Objects (SMO) Developer Machine 32 bit - SQL Server 64 bit -

-

i develop windows forms application on 32 bit win7 machine , have sql server 2008 on same machine testing. database server of release inviroment has 64 bit. when install application on client (32 bit) in release inviroment connected 64 bit sql server following failure when code try use sql server management objects (smo):

code causes failure:

        private static bool createdatabase(string dbname, string sqlpath, string connstr)     {         fileinfo file = new fileinfo(sqlpath + dbname + ".sql");         string strscript = file.opentext().readtoend();         bool result;         string test = "create database [" + dbname + "]";          try         {             sqlconnection connection = new sqlconnection(connstr);             using (connection)             {                 using (sqlcommand sqlcmd = new sqlcommand(test, connection))                 {                     connection.open();                     sqlcmd.executenonquery();                     connection.close();                     result = true;                 }             }              if (result == true)             {                 connstr = connstr + ";initial catalog=" + dbname;                 sqlconnection sqlconnection = new sqlconnection(connstr);                 serverconnection svrconnection = new serverconnection(sqlconnection);                 server server = new server(svrconnection);                  server.connectioncontext.executenonquery(strscript); // here app crashes             }         }         catch (sqlexception ae)         {             result = false;             system.windows.forms.messagebox.show(ae.message.tostring());         }         return result;     }

failure message:

anwendung: xingaadmin.exe frameworkversion: v4.0.30319 beschreibung: der prozess wurde aufgrund einer unbehandelten ausnahme beendet. ausnahmeinformationen: system.io.filenotfoundexception stapel: bei system.reflection.runtimeassembly._nload(system.reflection.assemblyname, system.string, system.security.policy.evidence, system.reflection.runtimeassembly, system.threading.stackcrawlmark byref, boolean, boolean, boolean) bei system.reflection.runtimeassembly.nload(system.reflection.assemblyname, system.string, system.security.policy.evidence, system.reflection.runtimeassembly, system.threading.stackcrawlmark byref, boolean, boolean, boolean) bei system.reflection.runtimeassembly.internalloadassemblyname(system.reflection.assemblyname, system.security.policy.evidence, system.threading.stackcrawlmark byref, boolean, boolean) bei system.reflection.runtimeassembly.internalload(system.string, system.security.policy.evidence, system.threading.stackcrawlmark byref, boolean) bei system.reflection.assembly.load(system.string) bei microsoft.sqlserver.management.common.serverconnection.getstatements(system.string, microsoft.sqlserver.management.common.executiontypes, int32 byref) bei microsoft.sqlserver.management.common.serverconnection.executenonquery(system.string, microsoft.sqlserver.management.common.executiontypes) bei xingacommonclasses.utilities.database.databasehelper.createdatabase(system.string, system.string, system.string) bei xingacommonclasses.utilities.database.databasehelper.checkdatabase(system.collections.generic.list`1, system.string) bei xingaadmin.program.main()

the database created fine, sql-script table creation not executed.

is possible have use 64 bit version of sql server management objects (smo)? if, how can version. cannot install 64 bit version on 32 bit machine.

this question contains same stack trace, stack dump contains information smo assembly failed load. use try-catch block dump stack trace in exception.

the sql server machine needs have 64bit smo library installed.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more