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 |
|
JohnJohn73
Yak Posting Veteran
57 Posts |
 Posted - 2007-11-15 : 09:51:55
|
| Ok. Here is what I need to do: several computers on the intranet need to use a client program to access data from the server (a desktop)Here is what is going on:1. I am using Visual Studio 2005 c#.net 2.02. Sql Server Express 20053. I don't have IIS set up4. The database is being shared from the c drive on the server (not sophisticated at all, but this is a one man operation!)Questions:1. Is IIS an absolute must to make this happen?2. If not, a user pointed out that I can't use UNF to access the database. How do I set up the connection string to access the db on the server?This is my basic connection string (local)connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\MonzaDB\MonzaDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;Asynchronous Processing=true"Thanks for any help on this subject. I know basically nothing about NETWORK programming and database administration! |
|
|
JohnJohn73
Yak Posting Veteran
57 Posts |
Posted - 2007-11-15 : 10:00:36
|
| Do I need to provide the address of the machine? I saw this example:"Provider=sqloledb;Network Library=DBMSSOCN;Data Source=130.120.110.001,1433;Initial Catalog=MyDatabaseName;UserID=MyUsername;Password=MyPassword;I understand that sql server listens on port 1433, and I see that in the string. Just not sure if this will work! |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-15 : 11:43:44
|
| What u mean by UNF????RKNAIR |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-15 : 11:58:36
|
| I guess he meant UNCI connect to any sql server remotely.You dont need to have any drives mapped!!! Dont use AttachDbFilename!Just attach providing server name or IP address.I recommend you to play with one SQL server before you not went too far,and only them 'hook them up' |
|
|
|
JohnJohn73
Yak Posting Veteran
57 Posts |
Posted - 2007-11-15 : 12:00:57
|
| Yeah, I mean UNC. Sorry!I'll get rid of the AttachDBFilename and try your suggestions.Thanks |
|
|
|
|
|
|
Configure Sql Server 2005 for remote hookup?