By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,919 Members | 1,625 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,919 IT Pros & Developers. It's quick & easy.

Please help with connection string problem

P: n/a
I am converting an ASP app to ASP.net. I need to run the old asp app on my
desktop in the process. I downloaded the files from the web server and set
my connection string as follows

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\database\USITracking.mdb;"

I am unable to connect to the database on my machine. What am I doing
wrong?
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Which type of connection are you making? Make sure that you are using the
OleDb libraries and not the SqlClient libraries as the SqlClient ones are
only for SQL Server. Also, make sure that the IUSR and ASPnet user accounts
have enough permissions to access the db.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"William Gower" <w_*****@hotmail.com> wrote in message
news:uY**************@TK2MSFTNGP09.phx.gbl...
I am converting an ASP app to ASP.net. I need to run the old asp app on my desktop in the process. I downloaded the files from the web server and set my connection string as follows

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\database\USITracking.mdb;"

I am unable to connect to the database on my machine. What am I doing
wrong?

Nov 18 '05 #2

P: n/a
Explain what you mean by "I am unable to connect to the database." What code
are you running? What behavior are you seeing?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"William Gower" <w_*****@hotmail.com> wrote in message
news:uY**************@TK2MSFTNGP09.phx.gbl...
I am converting an ASP app to ASP.net. I need to run the old asp app on my desktop in the process. I downloaded the files from the web server and set my connection string as follows

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\database\USITracking.mdb;"

I am unable to connect to the database on my machine. What am I doing
wrong?

Nov 18 '05 #3

P: n/a
In addition, if you are using C#, make sure that you have escaped the \ characters in your connection string.

ie: strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\database\\USITracking.mdb;"

or

strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database\USITracking.mdb;"
Which type of connection are you making? Make sure that you are using
the OleDb libraries and not the SqlClient libraries as the SqlClient
ones are only for SQL Server. Also, make sure that the IUSR and ASPnet
user accounts have enough permissions to access the db.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
"William Gower" <w_*****@hotmail.com> wrote in message
news:uY**************@TK2MSFTNGP09.phx.gbl...
I am converting an ASP app to ASP.net. I need to run the old asp app
on

my
desktop in the process. I downloaded the files from the web server
and

set
my connection string as follows

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\database\USITracking.mdb;"
I am unable to connect to the database on my machine. What am I
doing wrong?

--

--
Matt Berther
http://www.mattberther.com
Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.