Re: Starting with VB2005 and SQL Server 2008 Express Edition

Tech-Archive recommends: Fix windows errors by optimizing your registry



--


"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message news:eEpmAyzwJHA.4956@xxxxxxxxxxxxxxxxxxxxxxx

"NZSchoolTech" <nzschooltech@xxxxxxxxxxxx> wrote in message
news:%23ttSSMywJHA.5584@xxxxxxxxxxxxxxxxxxxxxxx
<snipped>

Now maybe I'm wrong and the learning curve from MS Access to VB is really
steep. but how hard can it be to get a connection from a VB application to
the SQL Server 2008 Express database? Well, the documentation seems pretty
hard to find. Anyway this is what I tried:


Now I realize you are not talking about the "classic" VB development
platform (VB6 and lower), but the .Net Framework development platform. As
you clearly indicated in your subject title. Duh!

Actually I don't know the difference myself so no apology needed :)

I only used classic VB and actually don't have much experience of .NET

[Which also explains why you were were having so much trouble with "VB",
which seemed odd if you had extensive experience with MS Access (Forms, VBA,
...). <g>]

So I apologize for wasting your time, except for what I said about comparing
VB (free-standing program), MS Access, Jet, and SQL Server Express is the
same for both development platforms. Basically if using a file-based
database neither platform is going to dramatically improve multi-user
sharing.

For specific questions on the .Net Framework, you need to post your question
to a dotnet newsgroup.
Perhaps:
microsoft.public.dotnet.framework.windowsforms.databinding
microsoft.public.dotnet.languages.vb

But frankly, no matter what development tool you chose you should
investigate migrating to a full-version of SQL Server.

Probably we could not consider the cost of deploying SQL Server to our site at this time and would use a free DBMS like Postgresql.

Thanks.


.

Relevant Pages

  • RE: Accessing SqlServer(Express) data on the server
    ... As for the ASP.NET, it is built upon the .net framework, so generally all ... you can change the connectionstring to point to another ... manually create another database (named "MyASPNETDB" in SQL Express ... you can even use SQL Server authentication(specify username/password ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Visual C# Express question
    ... With SQL Server Express all you need is the .NET Framework 2.0 as the ... database is file based and the data access components are part of the .NET ...
    (microsoft.public.dotnet.framework)
  • dll error with .Net 1.0 and 1.1 installed
    ... information from a SQL Server 2000 database using SQLXML so that we ... can POST that XML stream to a secured URI, using .Net Framework ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Is Microsoft phasing out MS Access as a development platform?
    ... It's called SQL SERVER MSDE ... Access as a development platform is all but dead. ... have been asking us to completely remove any notion of SQL Server ... I am getting the uneasy feeling that Microsoft ...
    (microsoft.public.dotnet.faqs)
  • Re: Starting with VB2005 and SQL Server 2008 Express Edition
    ... the SQL Server 2008 Express database? ... but the .Net Framework development platform. ... VB, MS Access, Jet, and SQL Server Express is the ... For specific questions on the .Net Framework, you need to post your question ...
    (microsoft.public.vb.database)