Distribute software with SQL Server 7 db? what files are needed? MSDE?

[Guest_imported]

What do I need to install on the clients computer for him to be able to run our software and connect to the SQL Server 7 databare. Currently our software connects to an Acces97 database.<br><br>Something with MSDE? <br><br>Thanks for your help!<br><br>//Jonas

 

[trebort]

All you need is ODBC. If you don't have the correct versions (or no version), you can download MDAC2.x from the microsoft site.

 

[Guest_imported]

Maybe I wasn't clear enough...<br><br>The clients don't have SQL Server installed on their systems. Cause that would be really expensive etc.<br><br>I am looking for some other kind of &quot;runtime&quot; system that makes it possible to access the SQL Server 7 databases through our software (with ODBC that is).<br><br>Thanks for taking time!

 

[foxdev]

Then MSDE is what you'll want.&nbsp;&nbsp;Microsoft's license allows you to distribute MSDE with your client software.&nbsp;&nbsp;There is a 2Gb database size limit, but otherwise it is essentially the same as SQL Server (probably akin to the Desktop version). <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[Guest_imported]

Thanks for your help!<br><br>I wonder what the &quot;easiest&quot; way would be to install the databases that I've created with SQL Server 7; together with MSDE. Do I somehow need to &quot;import&quot; the SQL Server 7 databases that I have created into the MSDE.<br><br>Or is the MSDE installed separately and then the databases that I've made with SQL Server 7 are located on some other place.<br><br>I probably need to &quot;export&quot; my SQL Server 7 databases now so I have them in separate files that I distribute to the clients who buy this system? Or could I just copy the *.mdf files (and maybe also *.ldf files) onto the clients computer?

 

[foxdev]

You can design and develop the databases in SQLS, then distribute them with MSDE.<br><br>For full details (well, as full as any MS documentation) on MSDE and its use, visit:<br><br><A HREF="

http://msdn.microsoft.com/library/default.asp?URL=/vstudio/msde/techfaq.asp"

TARGET="_new">

http://msdn.microsoft.com/library/default.asp?URL=/vstudio/msde/techfaq.asp</A><br>

<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>