472,794 Members | 1,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,794 software developers and data experts.

Connect student version of vb.net to a sql database?

Hi

I am a poor student studying towards my MCSD. I have managed to get a
cheapish student version of vb.net. Problem is that this version does not
connect to sql databases and I need it to because access ... well I just do!
I was wondering if anybody knows of any 3rd party tools or com objects etc
that would enable me to make this life giving connection?

Thanks

Frank - its a long shot, I know
Nov 21 '05 #1
4 3737

"Frank" <fr***********@hotmail.com> wrote in message news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi

I am a poor student studying towards my MCSD. I have managed to get a cheapish student version of vb.net. Problem is that this
version does not connect to sql databases and I need it to because access ... well I just do! I was wondering if anybody knows
of any 3rd party tools or com objects etc that would enable me to make this life giving connection?

Thanks

Frank - its a long shot, I know


Not knowing exactly which version you have, I can only guess it is the Standard version. If that is the case you can connect to
a SQL database, but, will have to write the code yourself. There are no Database Wizards in the Standard Versions.

Start here http://www.connectionstrings.com/

To find connections strings to use.

There is plenty of Database examples that don't rely on Database Wizards online.

Here's a good one: http://msdn.microsoft.com/data/DataF...s/default.aspx
And this one should have a lot of answers to your questions too:

http://www.xtremevbtalk.com/forumdisplay.php?f=107

These three links should give you a good start.
Good luck,
james

Nov 21 '05 #2
And given that he is a student, you don't do much learning having the wizard
do everything for you.

"james" <jjames700ReMoVeMe at earthlink dot net> wrote in message
news:ep*************@TK2MSFTNGP15.phx.gbl...

"Frank" <fr***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi

I am a poor student studying towards my MCSD. I have managed to get a
cheapish student version of vb.net. Problem is that this version does not
connect to sql databases and I need it to because access ... well I just
do! I was wondering if anybody knows of any 3rd party tools or com
objects etc that would enable me to make this life giving connection?

Thanks

Frank - its a long shot, I know


Not knowing exactly which version you have, I can only guess it is the
Standard version. If that is the case you can connect to a SQL database,
but, will have to write the code yourself. There are no Database Wizards
in the Standard Versions.

Start here http://www.connectionstrings.com/

To find connections strings to use.

There is plenty of Database examples that don't rely on Database Wizards
online.

Here's a good one:
http://msdn.microsoft.com/data/DataF...s/default.aspx
And this one should have a lot of answers to your questions too:

http://www.xtremevbtalk.com/forumdisplay.php?f=107

These three links should give you a good start.
Good luck,
james

Nov 21 '05 #3
You are quite right. I had falsely assumed that connections were not
possible at all The error message that pops up "Unable to connect to
database. It is only possible to connect to SQL Server Desktop Engine
databases and Microsoft Access databases with this version of Visual
Studio." is a bit misleading because it makes it sound like sql cannot be
used at all, whereas the standard version just doesn't include the database
wizard. It is totally possible (and probably good habit) to just connect
through code.

Frank Hayward
http://www.apricot.topfreewebhosting.com
fr***********@hotmail.com
"james" <jjames700ReMoVeMe at earthlink dot net> wrote in message
news:ep*************@TK2MSFTNGP15.phx.gbl...

"Frank" <fr***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi

I am a poor student studying towards my MCSD. I have managed to get a
cheapish student version of vb.net. Problem is that this version does not
connect to sql databases and I need it to because access ... well I just
do! I was wondering if anybody knows of any 3rd party tools or com
objects etc that would enable me to make this life giving connection?

Thanks

Frank - its a long shot, I know


Not knowing exactly which version you have, I can only guess it is the
Standard version. If that is the case you can connect to a SQL database,
but, will have to write the code yourself. There are no Database Wizards
in the Standard Versions.

Start here http://www.connectionstrings.com/

To find connections strings to use.

There is plenty of Database examples that don't rely on Database Wizards
online.

Here's a good one:
http://msdn.microsoft.com/data/DataF...s/default.aspx
And this one should have a lot of answers to your questions too:

http://www.xtremevbtalk.com/forumdisplay.php?f=107

These three links should give you a good start.
Good luck,
james

Nov 21 '05 #4
Yes, as another poster stated, you will learn much more coding the connections yourself. And also you will have much more
control over the how things are done. It's more work, but, much more versitle than using Wizards. Between the links I posted
and using Google, there is not too much you cannot find on the subject.
james
"Frank" <fr***********@hotmail.com> wrote in message news:u%****************@TK2MSFTNGP10.phx.gbl...
You are quite right. I had falsely assumed that connections were not possible at all The error message that pops up "Unable to
connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with
this version of Visual Studio." is a bit misleading because it makes it sound like sql cannot be used at all, whereas the
standard version just doesn't include the database wizard. It is totally possible (and probably good habit) to just connect
through code.

Frank Hayward
http://www.apricot.topfreewebhosting.com
fr***********@hotmail.com

Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Marcus | last post by:
Hello! I'm trying to write a VB.NET program that connects to a AS/400 Server. I've tried almost everything, but it will not connect. I've tried to set up a DSN using the Client Access...
4
by: Development at American Savings | last post by:
I'm having some trouble being able to connect to my db2 server (it lives on an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net 2003. Any suggestions? I have a local user...
4
by: banz | last post by:
Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to...
10
by: Andy K | last post by:
Hi again , I've been trying to connect to a distant database with my control center on WinXp . I'm using a personnal edition DB2 v8.1.9.700 for the control center on WinXp. I've setup a...
5
by: mayamorning123 | last post by:
A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit...
6
by: Al G | last post by:
Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and...
1
by: syed asghar abbas | last post by:
I am Student of the BS(Cs) and i am student of the Final Term and my Final Project on the Barcode Reader that "How to Connect the Barcode Reader Device Scanner With Sql Database in C# 2005 "
4
by: psyvanz | last post by:
Im a college student, my program is a computerized enrollment system, Im using MS ACCESS database in connecting my VB6 program form. Inside i'd created two tables, named "tbstudentinfo" and...
1
by: ajeeshc | last post by:
the code that i tried <?php $con = mysql_connect("telious", ***, ***); if (!$con) { die('Could not connect: ' . mysql_error()); } if (mysql_query("CREATE DATABASE my_db",$con)) {
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.