|
keroed_edmond wrote: to access a database
Notice access A database, not an Access database
only two letters away from being an asset
|
|
|
|
|
Yes, you are probably right. I read "access database" in the subject line, and assumed (as there is no other reference to something that looks like a database name) that it was about the Access database.
---
b { font-weight: normal; }
|
|
|
|
|
keroed_edmond wrote: is it possible for me to allow my windows application that i have developed to be able to access a database on my server????
Yes, like Mark stated, use a connection string to tell the applications where the database is located. www.connectionstrings.com[^] has references to many common databases and their connection strings.
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
Your mission, if you choose to accept it, is to go to the page that you linked to, look at the database connections for Access, and tell me where you specify the server that the database is located on.
---
b { font-weight: normal; }
|
|
|
|
|
\\Servername\Sharename\dbpath for the database path portion of the connection string. Works like a charm as long as the user has read/write access to the share.
|
|
|
|
|
wrote: look at the database connections for Access
Where are you going on about MS Access? The original poster wanted to know about accessing a database from the server. They might be using MSSQL, MySQL, Oracle, or Firebird. They didn't specify. The link I provided has connection strings that work plenty fine
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
No, you can not use an Access database in that way.
I seem to have a faint memory of some sort of bridge/proxy that you can set up on the server to allow access to the database. Didn't sound very easy or very efficient...
If you have direct file access to the server, you might be able to set up permissions so that you can access the database directly. This might require that the computers belong to the same network domain. As this means that you access the entire database file over the network, and not only the data you request, it can be quite slow.
I think that your best bet would be to go for a limited database server, like MSDE or SQL Express, or a real database server, like MySQL or SQL Server.
---
b { font-weight: normal; }
|
|
|
|
|
I think you over-read the original post. He didn't say anything about using an Access database. He said "...to be able to access a database on my server."
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: He didn't say anything about using an Access database. He said "...to be able to access a database on my server."
Thank you for pointing that out
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
You didn't really specify what database engine you are using, and that impacts the answer. If it's Microsoft Access, you would need to place it on a shared drive on the server and use a UNC string for the database path (\\Servername\Sharename\path) part of the connection string (the user would also need read and write access to the share). For SQL server and other server base databases, you just need to specify the correct server in the connection string, and insure that the correct network client drivers were present on the client.
If you used ADO or ADO.Net and SQL server, you they will likely already be present. The connecting user will need to be a user known to the server if using windows authentication (either a domain member, or if a work group, have an account on the server with exactly the same username and password).
|
|
|
|
|
Sorry, responded to the wrong post - see my reply to Guffa below. He is incorrect, you can use Access on a server, with some reservations.
|
|
|
|
|
Rob Graham wrote: He is incorrect, you can use Access on a server, with some reservations.
Where am I incorrect? I explained how you could access the database file through the file system.
---
b { font-weight: normal; }
|
|
|
|
|
Use a UNC file path for DBQ/Data Source. As long as the user has read/write access to the server share, this works fine. (must also be either a domain user - so can authenticate - or have an account with excacty the same username and password on the workgroup server). I have used this sevreal times, and it works in ADO.NET or ADO.
|
|
|
|
|
Either you are replying to the wrong post again, or you didn't read my post before replying?
---
b { font-weight: normal; }
|
|
|
|
|
hey guys, How can i do compression in .net? I have i files i would to compress. I came acorss this project called SharpZip in C#. Its got a lot of functionality but its too complicated. Anything simpler. I just have a bunch of filenames in a string array that i would like to add into a single ZIP file.
|
|
|
|
|
I dont know exactly but, the way that I can say you, try to use windows api.
|
|
|
|
|
hey, thanks a lot. i ahve been googling like crazy for the past hour and i have come to realize that SharZIp is the best. It's tried and tested - no major bugs and it gives a lots of functionality.
|
|
|
|
|
If you are using 2.0 you could try the System.IO.Compression namespace
only two letters away from being an asset
|
|
|
|
|
Use the J# library
http://www.codeproject.com/csharp/vmeasyzipunzip.asp?df=100&forumid=39636&exp=0&select=1438491
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Use the Compression of .net2 or go use the sharplibzip of sharpdevelop
SharpZipLibLINK
Don't you also love the code?
|
|
|
|
|
Hi guys!
This is my method signature:public static string Translate(string translationCode, string culture, Dictionary<string, Dictionary<string, string>> input)
i would like to know how to access the value of the 'input' dictionary within the method?
e.g. if(input.ContainsKey(culture))
{
if(how do I check they 'key' of the inner dictionary?)
{
//use the value of the inner dictionary
then how would i access the value of the inner dictionary
}
}
I hope this makes sense. Thanks
|
|
|
|
|
I think this should work:
if (input.ContainsKey (culture)) {
Dictionary d = input [culture];
if (d.Contains (translationCode))
return d [translationCode];
return String.Empty;
} /ravi
|
|
|
|
|
Just apply every operation to the inner dictionary to input[culture] :
if(input.ContainsKey(culture))
{
if(input[culture].ContainsKey(innerDictionaryKey))
{
string theValueYouWant = input[culture][innerDictionaryKey];
}
}
|
|
|
|
|
Hi, this is a repost from earlier.
Using WinForms in VS2003 and a DataGrid, how do I control the *color* for individual columns / rows / cells. I don't see any properties in DataGrid, DataTable, DataView, or DataGridTableStyle.
Thanks.
|
|
|
|
|
Is this what you're looking for?
DataGrid grid = new DataGrid();
//First Row BackColor
grid.Items[0].BackColor = Color.Red;
//First Row First Cell
grid.Items[0].Cells[0].BackColor = Color.Green;
As for changing the column's color I think you need to loop though each row for a particular cell and change the color that way... I'm not really sure if there is a better way to do it.
e.g.
//Change Column color for first cell
foreach(DataRow row in grid.Rows)
{
row.Cells[0].BackColor = Color.Blue;
}
Cheers
Disgyza
Programmer Analyst
|
|
|
|