| Author |
Topic |
|
Tirez
Starting Member
13 Posts |
 Posted - 2011-10-25 : 21:17:47
|
| hai, I'm just migrate from access table to SQL Server. wright now i'm using SQL Server 2000. I have some question about SQL Server:1) When i'm used Access as back end for my application, it can packed( i mean when i installed it in another PC that it'snt have Access it can be run). so in SQL Server, it can be do same like Access?? If it's can how (explained to me step by step what should I've to do?)? or in another PC must be installed SQL server first. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-26 : 01:23:34
|
| didnt get your question. are you asking way to connect to sql from another machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-26 : 02:25:57
|
| You can use ms-access database on a PC where it is not installed only if you appropriate drivers installed using which your application connects to the access db.SQL Server needs to be installed on the system which you are going to use as a database server. |
|
|
|
Tirez
Starting Member
13 Posts |
Posted - 2011-10-26 : 21:31:22
|
| I'm still confuse, i mean i've case that when i'm packed my application where it's using Access as beck end, i'm selected files whom it's required by the system. If I use SQL Server as back end and VB as front end are they can be do same like i'm packed my application where it's using Access? because in SQL server i know there's DTS file etc( I mean just selecting a few files from SQL server who it's required by the system). I've ever using Sybase as beck end and it's works. so In sql server is it can? or as you told that we have to installed the SQL server software. Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-27 : 02:28:41
|
quote:
Originally posted by Tirez
I'm still confuse, i mean i've case that when i'm packed my application where it's using Access as beck end, i'm selected files whom it's required by the system. If I use SQL Server as back end and VB as front end are they can be do same like i'm packed my application where it's using Access? because in SQL server i know there's DTS file etc( I mean just selecting a few files from SQL server who it's required by the system). I've ever using Sybase as beck end and it's works. so In sql server is it can? or as you told that we have to installed the SQL server software. Thanks
VB and SQL server can work in the same way. you need to have a sql installed box which vb application can access (it need not be in same machine). you'll add connection configuration in the machine with VB app and through it you connect to sql server created db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Tirez
Starting Member
13 Posts |
Posted - 2011-10-27 : 23:24:18
|
| excuse me Mr/Miss/Mrs. visakh16, I think you're not get my point yet. I already made application client server using VB as front end and SQL Server 2000 as back end and it's work, but my problem is can i packed it just like when I'm using Access as back end just selected files whom it required by the system. So when I want to installed in PC who it's not have Access can run well. My Question is can i packed my application just selected files whom it required by the system who it come from SQL Server files self? so when i' installed it in another PC who it doesn't have SQL server can be run well? If It can, please give me the way step by step. Or as Mr/Mrs/Miss Cindyaz that i've to installed SQL Server software first in new PC. Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-28 : 05:08:03
|
| Ok. I got the point. If you want to embed it in application and if you've have only light weight queries, use SQL Server Compacthttp://support.microsoft.com/kb/920700------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Tirez
Starting Member
13 Posts |
Posted - 2011-10-30 : 21:59:30
|
| excuse me Mr/Miss/Mrs. visakh16, I'm still not get your point yet. Is it can or not? if it's, should i upgrade my SQL server software to 2005 version or ...? please give me your advice as the expert. thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-31 : 04:22:31
|
| please read the attached link. SQL server compact is a light weight implementation of sql server db which youcan embed in applications------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Tirez
Starting Member
13 Posts |
Posted - 2011-11-01 : 03:38:09
|
| I see, thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-01 : 04:33:52
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
asking how to packing