database connection for sql server 5.0 and vb.net

Expand Post »

Hi all..
dis is kinda urgent case though coz i dun have much time to complete my final project.

I've installed sql server 5.0 and the connection is on.I have also created the tables related to my interfaces
As for vb.net, i've finished with all my interfaces.
Now, the problem is..
1) how to connect my interface with my database in SQL server?
2) when i tried to select my database, it requires .mdb file for sql server. eventhough i've saved my db file, it seems dat it is not .mdb type coz it doesnt appear when i want to select the db.
how to save sql server 5.0 file?

pls anyone..i really need some help here...urgently..thx!!

Last edited by blossomus; Nov 29th, 2008 at 10:37 pm.

Similar Threads

I need .NET basic interview questions urgently in C#
C++ Assignment NEED HELP URGENTLY in C++
is it possible to save a visual basic form in jpeg format??? pls help... urgently... in Visual Basic 4 / 5 / 6
Help Needed Urgently With Coding in Java
Preparing for an interview and need some questions answered in C

blossomus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Nov 30th, 2008

Re: database connection for sql server 5.0 and vb.net

Hi.
Can you explain to me one more time. Do you need to connect to MS SQL 2005 database or Access file?

Cheers

Rogachev

Reputation Points: 11

Solved Threads: 9

Light Poster

Offline

44 posts
since Nov 2008

Permalink

Nov 30th, 2008

Re: database connection for sql server 5.0 and vb.net

hi there..
thx for ur respond.
btw, i have problem connecting my database(sql server 2005) with my interface(vb.net).
i've tried to connect my interface(vb.net) with my database(sql server 2005), however dis error msg came out:
"An error has occured while establishing a connection to the server. When connecting to sql server 2005, this failure maybe caused by the fact that under the default settings SQL server does not allow remote connection.(error 26:Error locating server/Instance specified).

Or can u help me by giving step to step instruction on how to connect to sql server from vb.net. i'm sooooooo depresssed! =(

thx anyway..

blossomus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Datatable and datarow.

Next Thread in VB.NET Forum Timeline: help in data table object

DaniWeb Message

Cancel Changes

User Name
Password