| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-19 : 07:39:43
|
| Steven Fouracre writes "What files are required to Package & deploy a VB application which utilises a sql server database to connect to. I don't want to install MS Sql Server on the machine I'm installing the VB application.I've included the EXE file for Enterprise Manager in the Package & deployment Setup program, but this doesn't seem to work. Can anyone help?" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-03-19 : 07:50:12
|
| Is this for use within a network that has SQL Server in it ? If so, then no SQL Server files are needed as it can connect to SQL Server through the network.If you are wanting to give the VB app to someone who doesn't have SQL Server then you have a problem.Can you clarify what you are trying to achieve a bit more please===========Paul |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-19 : 13:08:49
|
| You will probably need mdac but I think that gets picked up automatically.For a win2k m/c you may need the latest mdac as it might not work with the earlier versions of the latest release.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2003-03-19 : 13:15:14
|
| If you are attempting to install your VB app on a computer that has no access to a SQL Server you might want to investigate MSDE.[url]http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp[/url]Got SQL? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-19 : 13:20:37
|
| MDAC is all that you need, but most machines should already have it so I'm not sure why you are encountering a problem. What is the error that you get?Tara |
|
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2003-03-19 : 13:26:48
|
| Doesn't MDAC only include the drivers that allow you to connect to a specified database? If there is not a database to connect to then MDAC won't help. If Steven is asking how to distribute the actual database then he will need both MSDE and MDAC. If the SQL Server is already installed locally or on the network somewhere than the user will only need MDAC.Got SQL? |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-19 : 13:55:43
|
| If the VB project contains a reference to ADO, the files will get copied. An MDAC_Typ.exe file will get included automatically by the PD Wizard. And if you are trying to connect to a SQL Server on a network, your app's gotta have some code for the server and database connection.Sarah Berger MCSD |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-19 : 14:03:11
|
quote:
Doesn't MDAC only include the drivers that allow you to connect to a specified database? If there is not a database to connect to then MDAC won't help. If Steven is asking how to distribute the actual database then he will need both MSDE and MDAC. If the SQL Server is already installed locally or on the network somewhere than the user will only need MDAC.
Steven didn't say that he wants to distribute the database, he just said that he wants to package and deploy a VB application (he then says that utilizes a db, but doesn't say that he wants the database deployed too). I'm pretty sure that he knows that deploying EM won't ever get you the database, so I would think that he was just thinking that EM would allow the user to connect to a database (which it doesn't, but that's what MDAC is for).Tara |
|
|
|
|
Package & deploy Wizard in VB