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 |
|
mivey4
Yak Posting Veteran
66 Posts |
 Posted - 2008-12-10 : 19:47:31
|
I am modifying an application to use a database file that I created locally on my system. The application was initially using an MS Access database but due to some field restrictions of Access I wanted to get away from it.My question: Is there any way to attach to the datafile with a connection string and exclude the server name? My reason for this is that I want to make the program portable enough to use on any system without the necessity of the user having SQL server installed. Also I don't want to complicate the methodolgy of making the connection by having the user modify a config file if they were to have SQL server installed.I can't find any connection strings that I can use that don't have the Server name or IP address required.Can this be done or am I thinkin' wrong???  Maybe I should re-consider my choice for the database? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mivey4
Yak Posting Veteran
66 Posts |
Posted - 2008-12-10 : 20:00:10
|
| Thanks tkizer, I was afraid that was going to be the answer. Any recommendations. I need something portable as Access but a bit more robust. My app crashes when the text field is greater than 255 characters.thx again! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mivey4
Yak Posting Veteran
66 Posts |
Posted - 2008-12-10 : 20:13:48
|
| Sorry, you're correct. I'll ask in an Access Forum. Too bad SQL won't work for me but thanks for the advice. |
|
|
|
|
|
|
SQL Server Application Connection