Vista - 64 bit MDAC needed

07-01-2009

Michel Posseth [MCP] wrote:

Quote:

>
> If you really like ACCCESS and need to use it on a 64 bit system the
> only other solution is to built your project strict form 32 bit in that
> case your app will run on a 64 bit system in the WOW layer
> and can access the 32 bit drivers if they are installed on the system .
> I have done this in the past and it worked flawless

It's not that I'm married to ACCESS. But for this application it was simply
the easiest... Until I tried a 64 bit version. 32bit only is not an option
because I'm making a plugin for AutoCAD and you can't load a 32bit dll into
64bit AutoCAD. Believe me, I tried it.

Quote:

> The only other solution is to use a database with a 64 bit driver SQL
> server , SQL server CE , or another nice free alternative Firebird DB
> wich has a free full featured DB and a SQL CE clone ( although the
> Firebird version was there first ) the firebird XCOPY version however is
> not protectable on file level and SQL CE is ( password protect the DB
> to protect contents from uniauthorized access )
> But for the rest the firebird version is also a great product with all
> sorts of features http://www.firebirdsql.org/
>
>
> For the rest i have never found a good free alternative, for the
> security feature i choose SQL CE as this was verry important to me at
> that time
>
>

Hmm Firebird, didn't think of that I will check it out, thanks.

Rinze

07-01-2009

Norman Yuan wrote:

Quote:

>
> There is not much different between SQL Server, SQL Server Express,
> regarding your need. You seems mistakenly thinking that somehow full SQL
> Server allows you place data file on a network drive, hence the "@ thousands
> of dollar...".
>
> If your app is only meant for single user to use your app, why you have to
> place SQL Server's database file (*.mdf) on network share? If it is meant to
> be shared by multiple users, the SQL Server, or SQL Server Express, or MySQL
> can be installed on any networked computer. I really do not understand why
> the data file of a SQL Server (Express) has to be on a mapped network drive
> in your case.
>

The plugin we're making will come in 2 flavors. A single user version. In
which case SQLExpress would do everything I need. And a network version. In
which case the data needs to be available to everyone on the network.
That's why I needed my file to be on the network.

I did some further checking. I was under the impression that SQLExpress
didn't accept remote connections. Apparently I was wrong! So that solves my
problem of needing a full version of SQLServer.

I guess this solves my problem. Now I just need to figure out how to wrap
it all up in a neat setup without too much hassle for the user

Rinze

07-01-2009

Michel Posseth [MCP] wrote:

Quote:

> Hello Rinze
>
> use foreign key relationships and cascade deletes / updates for this
> purpose.
>
> with SMS you can do this graphicly but it is also possible with script
> http://technet.microsoft.com/en-us/l.../ms173393.aspx
>
> HTH
>
> Michel
>

In SMS I can define the relations graphically on our full SQL server and in
my SQLExpress. But when I open the SQLCE db I can't for some reason. But I
have made a mistake regarding SQLExpress. I thought it didn't accept remote
connections (I thought that was one of the things that made it 'express').
But seeing it does accept remote connections, that solves my problem.

Rinze

07-02-2009

Rinze

Although your problem is already solved , here is option for you to consider
for anny future projects

You could also have solved this by using remoting ( WCF ) for your
database part
the whole problem with the 64 bit thingy is that a process space runs either
32 or 64 bit so what you could do was to call a host outside the current
process space
this could be a 32 / 64 bit prog without anny problems .

Just another interresting option :-)

Michel

"Rinze" <a@xxxxxx> schreef in bericht
news:epdMsih%23JHA.4560@xxxxxx

Quote:

> Michel Posseth [MCP] wrote:

Quote:

>>
>> If you really like ACCCESS and need to use it on a 64 bit system the only
>> other solution is to built your project strict form 32 bit in that case
>> your app will run on a 64 bit system in the WOW layer
>> and can access the 32 bit drivers if they are installed on the system . I
>> have done this in the past and it worked flawless

>
> It's not that I'm married to ACCESS. But for this application it was
> simply the easiest... Until I tried a 64 bit version. 32bit only is not
> an option because I'm making a plugin for AutoCAD and you can't load a
> 32bit dll into 64bit AutoCAD. Believe me, I tried it.
>

Quote:

>> The only other solution is to use a database with a 64 bit driver SQL
>> server , SQL server CE , or another nice free alternative Firebird DB
>> wich has a free full featured DB and a SQL CE clone ( although the
>> Firebird version was there first ) the firebird XCOPY version however is
>> not protectable on file level and SQL CE is ( password protect the DB to
>> protect contents from uniauthorized access )
>> But for the rest the firebird version is also a great product with all
>> sorts of features http://www.firebirdsql.org/
>>
>>
>> For the rest i have never found a good free alternative, for the
>> security feature i choose SQL CE as this was verry important to me at
>> that time
>>
>>

>
> Hmm Firebird, didn't think of that I will check it out, thanks.
>
> Rinze

07-02-2009

Hello Rinze ,

AFAIK

Quote:

> I thought it didn't accept remote connections (I thought that was one of
> the things that made it 'express').

After proper configuration it does accept external connection however not
after a default install you need to set some options

HTH

Michel

"Rinze" <a@xxxxxx> schreef in bericht
news:%23kkxFvh%23JHA.4168@xxxxxx

Quote:

> Michel Posseth [MCP] wrote:

Quote:

>> Hello Rinze
>>
>> use foreign key relationships and cascade deletes / updates for this
>> purpose.
>>
>> with SMS you can do this graphicly but it is also possible with script
>> http://technet.microsoft.com/en-us/l.../ms173393.aspx
>>
>> HTH
>>
>> Michel
>>

>
> In SMS I can define the relations graphically on our full SQL server and
> in my SQLExpress. But when I open the SQLCE db I can't for some reason.
> But I have made a mistake regarding SQLExpress. I thought it didn't accept
> remote connections (I thought that was one of the things that made it
> 'express'). But seeing it does accept remote connections, that solves my
> problem.
>
> Rinze

07-01-2009	#11 (permalink)
Rinze n/a posts	Re: 64 bit MDAC needed Michel Posseth [MCP] wrote: Quote: > > If you really like ACCCESS and need to use it on a 64 bit system the > only other solution is to built your project strict form 32 bit in that > case your app will run on a 64 bit system in the WOW layer > and can access the 32 bit drivers if they are installed on the system . > I have done this in the past and it worked flawless It's not that I'm married to ACCESS. But for this application it was simply the easiest... Until I tried a 64 bit version. 32bit only is not an option because I'm making a plugin for AutoCAD and you can't load a 32bit dll into 64bit AutoCAD. Believe me, I tried it. Quote: > The only other solution is to use a database with a 64 bit driver SQL > server , SQL server CE , or another nice free alternative Firebird DB > wich has a free full featured DB and a SQL CE clone ( although the > Firebird version was there first ) the firebird XCOPY version however is > not protectable on file level and SQL CE is ( password protect the DB > to protect contents from uniauthorized access ) > But for the rest the firebird version is also a great product with all > sorts of features http://www.firebirdsql.org/ > > > For the rest i have never found a good free alternative, for the > security feature i choose SQL CE as this was verry important to me at > that time > > Hmm Firebird, didn't think of that I will check it out, thanks. Rinze
My System Specs

07-01-2009	#12 (permalink)
Rinze n/a posts	Re: 64 bit MDAC needed Norman Yuan wrote: Quote: > > There is not much different between SQL Server, SQL Server Express, > regarding your need. You seems mistakenly thinking that somehow full SQL > Server allows you place data file on a network drive, hence the "@ thousands > of dollar...". > > If your app is only meant for single user to use your app, why you have to > place SQL Server's database file (*.mdf) on network share? If it is meant to > be shared by multiple users, the SQL Server, or SQL Server Express, or MySQL > can be installed on any networked computer. I really do not understand why > the data file of a SQL Server (Express) has to be on a mapped network drive > in your case. > The plugin we're making will come in 2 flavors. A single user version. In which case SQLExpress would do everything I need. And a network version. In which case the data needs to be available to everyone on the network. That's why I needed my file to be on the network. I did some further checking. I was under the impression that SQLExpress didn't accept remote connections. Apparently I was wrong! So that solves my problem of needing a full version of SQLServer. I guess this solves my problem. Now I just need to figure out how to wrap it all up in a neat setup without too much hassle for the user Rinze
My System Specs

07-01-2009	#13 (permalink)
Rinze n/a posts	Re: 64 bit MDAC needed Michel Posseth [MCP] wrote: Quote: > Hello Rinze > > use foreign key relationships and cascade deletes / updates for this > purpose. > > with SMS you can do this graphicly but it is also possible with script > http://technet.microsoft.com/en-us/l.../ms173393.aspx > > HTH > > Michel > In SMS I can define the relations graphically on our full SQL server and in my SQLExpress. But when I open the SQLCE db I can't for some reason. But I have made a mistake regarding SQLExpress. I thought it didn't accept remote connections (I thought that was one of the things that made it 'express'). But seeing it does accept remote connections, that solves my problem. Rinze
My System Specs

07-02-2009	#14 (permalink)
Michel Posseth [MCP] n/a posts	Re: 64 bit MDAC needed Rinze Although your problem is already solved , here is option for you to consider for anny future projects You could also have solved this by using remoting ( WCF ) for your database part the whole problem with the 64 bit thingy is that a process space runs either 32 or 64 bit so what you could do was to call a host outside the current process space this could be a 32 / 64 bit prog without anny problems . Just another interresting option :-) Michel "Rinze" <a@xxxxxx> schreef in bericht news:epdMsih%23JHA.4560@xxxxxx Quote: > Michel Posseth [MCP] wrote: Quote: >> >> If you really like ACCCESS and need to use it on a 64 bit system the only >> other solution is to built your project strict form 32 bit in that case >> your app will run on a 64 bit system in the WOW layer >> and can access the 32 bit drivers if they are installed on the system . I >> have done this in the past and it worked flawless > > It's not that I'm married to ACCESS. But for this application it was > simply the easiest... Until I tried a 64 bit version. 32bit only is not > an option because I'm making a plugin for AutoCAD and you can't load a > 32bit dll into 64bit AutoCAD. Believe me, I tried it. > Quote: >> The only other solution is to use a database with a 64 bit driver SQL >> server , SQL server CE , or another nice free alternative Firebird DB >> wich has a free full featured DB and a SQL CE clone ( although the >> Firebird version was there first ) the firebird XCOPY version however is >> not protectable on file level and SQL CE is ( password protect the DB to >> protect contents from uniauthorized access ) >> But for the rest the firebird version is also a great product with all >> sorts of features http://www.firebirdsql.org/ >> >> >> For the rest i have never found a good free alternative, for the >> security feature i choose SQL CE as this was verry important to me at >> that time >> >> > > Hmm Firebird, didn't think of that I will check it out, thanks. > > Rinze
My System Specs

07-02-2009	#15 (permalink)
Michel Posseth [MCP] n/a posts	Re: 64 bit MDAC needed Hello Rinze , AFAIK Quote: > I thought it didn't accept remote connections (I thought that was one of > the things that made it 'express'). After proper configuration it does accept external connection however not after a default install you need to set some options HTH Michel "Rinze" <a@xxxxxx> schreef in bericht news:%23kkxFvh%23JHA.4168@xxxxxx Quote: > Michel Posseth [MCP] wrote: Quote: >> Hello Rinze >> >> use foreign key relationships and cascade deletes / updates for this >> purpose. >> >> with SMS you can do this graphicly but it is also possible with script >> http://technet.microsoft.com/en-us/l.../ms173393.aspx >> >> HTH >> >> Michel >> > > In SMS I can define the relations graphically on our full SQL server and > in my SQLExpress. But when I open the SQLCE db I can't for some reason. > But I have made a mistake regarding SQLExpress. I thought it didn't accept > remote connections (I thought that was one of the things that made it > 'express'). But seeing it does accept remote connections, that solves my > problem. > > Rinze
My System Specs

Similar Threads
Thread	Forum
Vista and MDAC	Software
Installing Mdac 2.8	Vista installation & setup
installl MDAC 2.7 and 2.8	Vista General
MDAC	Vista General
MDAC 2.8 SP1 won't install	Vista General