Error connecting to database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 397,625 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,454 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 3111 | Replies: 10

Previous Post in Thread

Next Post in Thread

•

Join Date: Nov 2005

Posts: 23

Reputation: Reham Ejaz is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

Reham Ejaz Reham Ejaz is offline

Offline

Newbie Poster

Error connecting to database

Jan 15th, 2006

I am having problem in connecting to database. The problem is with the following code.

Help with Code Tags

(Toggle Plain Text)

dim objCmd as new OleDbDataAdapter()
objCmd.SelectCommand.Connection = dbconn
objCmd.SelectCommand.CommandText= sql

I am having error on line2

the error is

System.NullReferenceException: Object variable or With block variable not set.

I think there is problem in my connection string but i cant figure out.

the connection string is

Help with Code Tags

(Toggle Plain Text)

dim strConnection as String="Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("mydb.mdb")
Dim dbconn as New OleDbConnection(strConnection)

i have also tried

Help with Code Tags

(Toggle Plain Text)

dim dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=c:/inetpub/wwwroot/day1/mydb.mdb")

but still its not working. I have also seen some tutorials but they didnt help me. Can anyone plz tell me what could be wrong. I want to insert values into database from textboxes.
But i am facing this connectivity error.