|
Your two examples are trying to connect to the Northwind database in SQL Server.
You are trying to connect to the Northwind database (the data and structure) but on Access. You need a different connection string (see here[^]) and to use the OleDb* classes (OleDbConnection and OleDbCommand for example), since the Sql* classes are only for SQL Server.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi LuiSR:
Image that? An entire WEB site dedicated to connection strings for databases...
Thank you! It worked.
Was I mistaken to think that I could connect to a database created with Access using SQL Server? Many of the examples that I have encountered specifically name the Northwind example and specifically use SQL Server - including the one from this Wrox book I've been reading.
Thank you again,
Jethro63
|
|
|
|
|
Jethro63 wrote:
Was I mistaken to think that I could connect to a database created with Access using SQL Server?
No you can't. They are two VERY different animals. Access doesn't support stored procedures in the sense that a normal SQL database does. You can't write entire procedures or batches of statements in Access/Jet. It only supports single statement per "stored procedure".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Jethro63 wrote:
An entire WEB site dedicated to connection strings for databases
Things you can find on the web... 
Jethro63 wrote:
Was I mistaken to think that I could connect to a database created with Access using SQL Server?
To add and clarify what Dave replied, a database by itself is only the collection of tables with some data. SQL Server and Access are two database applications, as are many others like mysql, Oracle, and so on. So, you can have your collection of tables (the Northwind database) in an SQL Server database, or an Access database, or an Oracle database, or....
And to connect to each different kind of database application, you need different commands (it's more or less like asking for certain papers in English or in Spanish -- you have to speak the language of that that is giving you the papers, not of the papers themselves.)
OleDb* classes are very general, and you can use those to connect to almost any kind of database, including Access and SQL Server. The only difference is in the provider part of the connection string. So, for simple databases, changing the connection string is enough to change from Access to SQL Server.
But SQL Server is way more powerful than Access. As Dave mentioned, you have stored procedures for example. And the Sql* clasess are specific for SQL Server, giving you better performance and access to SQL Server-specific features, but also restricting you from using other database applications.
By the way, there's a free edition of SQL Server, called Microsoft SQL Server Desktop Engine, which you can download from here[^]. It is SQL Server, with the only limitations of 5 concurrent users and 2 o4 GB per database (enough for most small applications (and for some medium apps too)).
If you have any more questions, feel free to reply to this thread, we'll be glad to answer them.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Thanks again LuisR (and others):
Maybe I was mislead by the book I am going through (by Wrox Press). They have a very specific set of examples where they are specifically naming the Northwind Database AND the program code that they provide in all of the example use SqlConnection, SqlCommand, etc. etc.
The author of the book claimed that the MS SQL Desktop Engine would be installed automatically if the .NET Framework SDK had been installed AND the Northwind database would also be supplied in a samples directory. As far as I could tell, this was not true. I could find neither the server or the sample database files on my system after installing the SDK.
So, I did indeed go to the MSDE site and download the free desktop server, installed it and then started tearing out my hair trying to get the examples to work.
My only explanation for all of this is that perhaps the Northwind sample database HAS been created or converted to MS-SQL format and this is what the book's author had intended.
I am happy that I at least have something working here. I have Access and I can create databases with Access and play with them through my C# code for a while and then move on.
Thank you again! 
Jethro63
|
|
|
|
|
Thanks Luis, your post helped me to solve one of my problem.
Best Regards,
Mushq
Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan
|
|
|
|
|
Is it possible to get a form to paint over the top of its child control without overriding the paint for the child controls?
My Problem
I’ve got a form that contains a number of panels. The panels all do their own painting. I am attempting to paint a grid on top of all the panels and I do not wish to set the panel’s transparency to transparent.
My attempted solution was to override the forms Paint method and paint the grid onto the form. However I can’t get this solution to paint over the top of the panels. Does anybody have any suggestions?
Many thanks
Mark.
|
|
|
|
|
Doesn't bringing the grid to the front (Right click, Bring to Front) help?
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
hi all
i'm create code demo as the one in this link http://www.15seconds.com/issue/020917.htm[^]
after run this code i found that the cearted code file contain only these lines
using System;<br />
using System.IO;<br />
<br />
<br />
namespace CodeDom {<br />
<br />
}
if anyone know where is the error please inform me coz i need it urgantly
|
|
|
|
|
namespace codedemo
namespace is only one word, that the only error I see in the above code.
/\ |_ E X E GG
|
|
|
|
|
thnx for ur replay but this is not the error and i don't know why this code didn't work correctly
|
|
|
|
|
(Previous can be deleted, my XML wasn't shown properly)
Hello,
I'm working on a C# console program.
Now I've encountered the following problem:
I read data from a MS-SQL database and create Article objects with this data (own class).
An Article object exists out of the following members: custIDa, custIDb, docID, accountNr,
tCode, tTarif, VAT.
A customer can have multiple articles (so when custIDa is for example 1 it can have docID =
1 and docID = 2 (so 2 articles)).
I add every Article object to an ArrayList (and maybe I'll sort it).
What I want to accomplish is the following:
I want to run through the ArrayList and write the Article-data to XML like this:
<RootNode>
<Customer IDa="1" IDb="UX200">
<Article docID="invoice001">
<AccountNr value="453-2513-564" />
<Code value="Foreign" />
<Tarif value="5" />
<VAT value="250" />
</Article>
</Customer>
<Customer IDa="2" IDb="BF500">
<Article docID="invoice007">
<AccountNr value="456-5465-546" />
<Code value="Domestic" />
<Tarif value="2" />
<VAT value="120" />
</Article>
<Article docID="invoice008">
<AccountNr value="456-5465-546" />
<Code value="Domestic" />
<Tarif value="2" />
<VAT value="568" />
</Article>
</Customer>
</RootNode>
I think I'll have to do this with a nested loop, 1 to check if custIDa is the same or has
changed and one for the docID's.
So custIDa can occur multiple times with everytime a changed docID (you could state that
it's a combined primary key as in SQL).
Anyone can help me out with this or has any ideas to help me out 'cause I'm really stuck
here 
Thanks in advance!
PS: Sorry for my English, I'm from Belgium 
|
|
|
|
|
I think it should be easier to do the selecting via sql. If can't send mulitple sql-statements to the db you should try to get your data into a local Datatable object. Then you can query it locally via the Select method.
|
|
|
|
|
Well I have to do it the way I described it and it all works, except for the writing to XML thingie...
You can run through an ArrayList just like you run through a DataTable so it must be possible in a way. But that's just my problem, which way is the good way
|
|
|
|
|
Hello,
I'm working on a C# console program.
Now I've encountered the following problem:
I read data from a MS-SQL database and create Article objects with this data (own class).
An Article object exists out of the following members: custIDa, custIDb, docID, accountNr,
tCode, tTarif, VAT.
A customer can have multiple articles (so when custIDa is for example 1 it can have docID =
1 and docID = 2 (so 2 articles)).
I add every Article object to an ArrayList (and maybe I'll sort it).
What I want to accomplish is the following:
I want to run through the ArrayList and write the Article-data to XML like this:
<rootnode>
<customer ida="1" idb="UX200">
<accountnr value="453-2513-564">
<br />
<tarif value="5"><br />
<vat value="250"><br />
<br />
<br />
<customer ida="2" idb="BF500"><br />
<br />
<accountnr value="456-5465-546"><br />
<code><br />
<tarif value="2"><br />
<vat value="120"><br />
<br />
<br />
<accountnr value="456-5465-546"><br />
<code><br />
<tarif value="2"><br />
<vat value="568"><br />
<br />
<code><br />
<code><code><br />
<br />
I think I'll have to do this with a nested loop, 1 to check if custIDa is the same or has <br />
<br />
changed and one for the docID's.<br />
<br />
So custIDa can occur multiple times with everytime a changed docID (you could state that <br />
<br />
it's a combined primary key as in SQL).<br />
<br />
Anyone can help me out with this or has any ideas to help me out 'cause I'm really stuck <br />
<br />
here :(<br />
<br />
Thanks in advance!<br />
<br />
PS: Sorry for my English, I'm from Belgium ;)
|
|
|
|
|
I can't see your code. It's not showing up for me...
|
|
|
|
|
check (try 2) above
|
|
|
|
|
Dear friends,
I juat want to create windows custom user control which should have a property to set transparency.
How can i do this....Please provide me better solution...
amal
|
|
|
|
|
Try setting the color to System.Drawing.Colors.Transparent. If not supported, add a SetStyle(ControlStyles.SupportsTransparentBackColor, true); in your control's constructor.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: He has a funny face. And he's my son.
Judah Himango
|
|
|
|
|
Hi,
What is a signed assemblies ? Is it a component
that is encrypted and require a key to use it ?
So can I create a dll which require a key to use it in .NET environment ?
Many Thanks
|
|
|
|
|
Hi all,
I have a scheduler application, running as a windows service.
This application generates a Threading.Timer for each process with a callback called OnTimedEvent().
What is happening is that if two processes are scheduled at the same time, one of the processes may enter OnTimedEvent() multiple times (the current record is 10).
Threading.Timers were used as there is a bug with the System.Timers whereby if two events are scheduled at the same time one won't fire at all. This is a known issue and I was advised by Microsoft to use the Threading.Timers.
Does anybody know if it is possible to prevent this. I initially thought that multiple threads might be being created, but logging the thread id indicates that it is a single thread per scheduled item, and that single thread is entering the OnTimedEvent callback multiple times per event.
I tried a mutex at the start of the callback i.e.
public void OnTimedEvent(object objSource)
{
if(!m_mtxEvent.WaitOne(1, false))
{
Thread.Sleep(1500);
return;
}
lock(this)
{
// Do some processing here
}
}
Adding the Thread.Sleep(1500) line seemed to reduce the problem, but not eliminate it.
I knew I should have stuck to C++
|
|
|
|
|
How are you creating your timer? You should be specifying Timeout.Infinite for the constructor's period parameter if you want a one-shot timer.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Thanks Mike.
I just found that out and I was about to post on here!
I only discovered it by accident though, as I realised I didn't need to specify a period as I have to re-compute the time to the next event anyway so removed some redundant code and set period to 0. This seems to fix the problem.
Regards
Simon Hart
|
|
|
|
|
I have a COM callable assembly written in C# which exposes 10 different functions to COM.
If I make changes to the internal functionality of the assembly I increase the revision number of the assembly version (i.e. 1.0.0.1 -> 1.0.0.2)
If I make changes to the COM definitions (i.e. changes to the type library) I increase the minor version of the assembly (i.e. 1.0.0.7 -> 1.1.0.7)
The problem I have is that regardless of any changes I make to the version is changes the tlb which means that the coders using the COM assembly (from Delphi) have to recompile.
Is there any way I can use versioning and not force the other coders to recompile (unless the COM interface has changed)
This problem probably has its roots firmly planted in my misunderstanding of version and type libraries, so I would appreciate any help.
post.mode = postmodes.signature;
SELECT everything FROM everywhere WHERE something = something_else;
> 1 Row Returned
> 42
|
|
|
|
|
hi
i am developing application with which my application will send CGI requests to a web serverv and listen to responces
ho can i accomplish this using C# / how can i send sttp streams to web server using c#
Thanking you in anticipation it will be wondefull if any body can guides me
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
