Ask Experts Questions for FREE Help !
Ask
    jenkinsdjj's Avatar
    jenkinsdjj Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Jul 27, 2005, 10:43 PM
    Acessing a database in VB .Net 2003
    I have tried many times to open an database and an SQLServer2000 database from VB .Net 2003. The import statements and code syntax is correct and has been checked over and over. I have also tried various published examples and still I get the error message "No source code at this point". I there likely to be a bug fix I have not applied?

    Typical code I have used is as follows:

    Imports System.Data.OleDb

    Public Sub CheckFiles()
    Dim dbs As New OleDbConnection

    dbs.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
    "Data Source=C:\VB .Net Projects\Collectivist v4" + _
    "\Collectivist v4\bin\Access Docs\Collectivist.mdb;"
    dbs.Open()

    'other code here

    End Sub

Check out some similar questions!

Ms Works Database [ 3 Answers ]

I am using ms works database but the only way I can add the contents of a field is by creating a report.Anyone help me please there must be a shorter way.:)

Advertising Database [ 3 Answers ]

I work in real estate and need to set up an advertising database. Is Microsoft Access suitable for this or what would be the best program to use? I need to be able to charge out advertising on a weekly basis to each relevant property, e.g. the property address needs to be in the database and...

Database [ 2 Answers ]

Hi there! I would like to have some detailed information about This topic:- Specify the hardware needed to support Database system, supporting your reasoning with argument and a detailed rationale. Waiting for your reply Cheers Reetika

How do I connect to a database [ 2 Answers ]

Hi, I'm having problems connecting to my database. I have had my site working perfectly on brinkster, but when I've moved it over to my new host it doesn't work. How do I know what way I should be connecting to the database i.e. DNS-less, system DNS or file DNS etc. Could some one...

Database [ 1 Answers ]

In a database I have inputed a subform. The subform adds up totals of plants by adding Price*quantity. That is fine, the problem I have is that I want to have a box that adds up all the plants totals to give an overal price. Anyway you can help me? Thanks

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.