Connection -- visual studio .net general

Emma Hope
5/24/2007 6:51:01 AM

Hi All,

If i have posted in the wrong newsgroup, please let me know where the
correct place would be.

I have VB.net and SQL server express, i have a VB.net front end and a sql
server express back end. I wish to have some graphs on my front end reading
some data from my sql server backend. Having looked at topic on the net it
seems i need an 'add-on', i have downloaded vbchart which seems to be the
most straightforward but it needs me to type a connection string into the
wizard, i have tried copying my connection string from my data source which
is ....... Data Source=.\SQLEXPRESS;AttachDbFilename="|DataDirectory|\The
Gateway.mdf";Integrated Security=True;User Instance=True

but vbChart tells me it needs a "provider", i have tried contacting the
people who make vbChart but so far they have ignored me.

Please can anyone give me the exact connection string i would need to do
this or does anyone else know of any graphing/charting tools that would work
with a SQL back end and are easy to use, i.e. i don't have to know the
connection string to use it (i have also tried ProEssentials tool but this is
even less straightforward and i need lots of code for it). Obviously i would
need something either free or with an evaluation version, so i can see if i
can use it before i buy it.

Emma Hope
5/24/2007 8:05:01 AM

Yes this is the VBChart i am using and as i mentioned in my post, it requires
a connection string for the wizard. The example code does not give an example
using sql server express and i am also not proficient enough to fully code it
yet. The wizard allows you to 'miss out' all the coding but you have to
supply a connection string.

I am asking for help with the simple connection string between a SQL server
express database using the partial data i already have.

Thanks

[quoted text, click to view]

pvdg42
5/24/2007 9:35:02 AM

If this is the VBChart you are using, code examples are available here:

http://www.vbchart.com/support/support.aspx

Have you downloaded these to find what you need?

[quoted text, click to view]

pvdg42
5/24/2007 11:09:27 AM

[quoted text, click to view]
Which is obviously not so simple.
Without downloading and installing the product, any advice you get here is
purely guesswork, as only the product vendor knows what is actually
required. How long have you waited for a response to the email you sent
them? Often the priority system for support places paying customers before
free trial users, so you should anticipate a wait of up to a week. You can
try a follow up email to them.

As a wild guess, here is a complete connection string example from a .NET
application:

<add name="Ch05DetailsViewUpdate.My.MySettings.ContactsConnectionString"

connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Contacts.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True"

providerName="System.Data.SqlClient" />

It's possible that a providerName clause will help.

pvdg42
5/24/2007 11:11:48 AM

[quoted text, click to view]
<snip>

I forgot. There is a .NET VB group where you might try your question as
well:

microsoft.public.dotnet.languages.vb

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about visual studio .net general

visual studio .net general : Connection