Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cojae
Starting Member
5 Posts |
 Posted - 2008-11-08 : 04:45:08
|
| I need to make a windows application in visual studio which will be linked to a database in sql server 2005. Is there any way I could make this work with the database and deploy it onto a seperate standalone computer which does not have sql server and does not connect to the original computer?cheers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-08 : 04:48:07
|
| yup. you need to define connection string to connect to db from your application. Also you should have a application role defined in database which will the one that application will use to connect. |
 |
|
|
cojae
Starting Member
5 Posts |
Posted - 2008-11-08 : 05:01:42
|
| once the application and database have been developed is there a way of having them together on a computer which does not have sql server installed? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-08 : 05:02:58
|
| Nope. how can you have database on a machine where you've not installed sql server? |
|
|
|
cojae
Starting Member
5 Posts |
Posted - 2008-11-08 : 05:13:04
|
| are there any other solutions where you can have a database integrated into the app even if it does not involve using sql server |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-08 : 05:20:33
|
| is it because of license problems that you're not having sql server on your machine? then you may use free version sql server express in your machine. but it has some limitations. go through the site to see what all features it supports. |
|
|
|
cojae
Starting Member
5 Posts |
Posted - 2008-11-08 : 05:26:32
|
| no its a university project that needs to have a database. I have sql server developer edition, but wuld need this available to people like my lecturer. I'm new to this side of computing which is why i'm unsure what to do. I thought about using Access but it seems a lot more limited.cheers for your help |
|
|
|
cojae
Starting Member
5 Posts |
Posted - 2008-11-08 : 05:28:13
|
| The database will need to pull off alot of data from the internet and would have some very large tables so i'm not sure if limited versions would be adequate |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-08 : 05:30:33
|
| go throuh documentation of Access and see if it supports your needs. |
|
|
|
|
|
|
deploying application