please help connecting to access database

[Doug Parker]

i'm trying to connect to an access database on an asp ready server.
i know the ftp login information - does that apply to logging into the
database string as well?

will this work?

Provider=MSDASQL.1;Password=*****;PersistSecurityI nfo=True;UserID=username;


please help, i'm a php/mysql programmer and i don't understand why this is
so difficult. i'm think i'm losing my mind.

[Jeff Cochran]

On Thu, 15 Apr 2004 13:26:27 -0400, "Doug Parker"
<drparker@phreshdesign.com> wrote:

>i'm trying to connect to an access database on an asp ready server.
>i know the ftp login information - does that apply to logging into the
>database string as well?

Maybe. Maybe not. If the passwords and accounts are idnetical, yes.

>will this work?
>
>Provider=MSDASQL.1;Password=*****;PersistSecurity Info=True;UserID=username;
>
>
>please help, i'm a php/mysql programmer and i don't understand why this is
>so difficult. i'm think i'm losing my mind.

Might look at some tutorials:

[url]http://www.able-consulting.com/ADO_Conn.htm[/url]
[url]http://www.tutorial-web.com/asp/database/[/url]
[url]http://www.vallin.com/pub/1/asp1.asp[/url]

And of course:

[url]http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=asp+database+tutorial[/url]

Jeff

[Bob Barrows [MVP]]

Doug Parker wrote:

> i'm trying to connect to an access database on an asp ready server.
> i know the ftp login information - does that apply to logging into the
> database string as well?
>
> will this work?
>
>

Provider=MSDASQL.1;Password=*****;PersistSecurityI nfo=True;UserID=username;

>
>
> please help, i'm a php/mysql programmer and i don't understand why
> this is so difficult. i'm think i'm losing my mind.

Go to [url]www.able-consulting.com/ado_conn.htm[/url] and look up the appropriate
connection string that uses the native Jet OLEDB provider.

For a non-password-protected database, the string can be as simple as:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=p:\ath\to\database.mdb

The IUSR_machinename account on the machine needs to have Change
(read/write/delete) permissions on the p:\ath\to folder.

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Doug Parker]

i apologize in advance - i've read every tutorial i could find on the
subject, i just can't read another one. i'd really appreciate it if you
guys would continue to walk me through it.

did this:

set conn = Server.CreateObject("ADODB.Connection")
sConn = "Provider=MSDASQL;" & _
"Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=/db/boonton.mdb;"
conn.Open sConn

got this:

Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x744 Thread 0x3f0
DBC 0x884b6e4 Jet'.
/calibration/config1.asp, line 14



"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:4085c726.17207272@msnews.microsoft.com...

> On Thu, 15 Apr 2004 13:26:27 -0400, "Doug Parker"
> <drparker@phreshdesign.com> wrote:
>

> >i'm trying to connect to an access database on an asp ready server.
> >i know the ftp login information - does that apply to logging into the
> >database string as well?

>
> Maybe. Maybe not. If the passwords and accounts are idnetical, yes.
>

> >will this work?
> >

>
>Provider=MSDASQL.1;Password=*****;PersistSecurity Info=True;UserID=username;

> >
> >
> >please help, i'm a php/mysql programmer and i don't understand why this

is

> >so difficult. i'm think i'm losing my mind.

>
> Might look at some tutorials:
>
> [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> [url]http://www.tutorial-web.com/asp/database/[/url]
> [url]http://www.vallin.com/pub/1/asp1.asp[/url]
>
> And of course:
>
>

[url]http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=asp+database+tutorial[/url]

>
> Jeff

[Aaron Bertrand [MVP]]

>i apologize in advance - i've read every tutorial i could find on the

> subject, i just can't read another one. i'd really appreciate it if you
> guys would continue to walk me through it.

Are you really that lazy? How do you expect to learn anything if all you do
is expect people to hand you the answers? What are you going to do when you
get your connection string working and you don't know how to write a SELECT
statement? More handouts?

I'm all for helping people learn. I'm *NOT* very fond of being told that
rather than provide pointers I should write someone's code for them. Next
you'll be asking me to wash your dishes.

> set conn = Server.CreateObject("ADODB.Connection")
> sConn = "Provider=MSDASQL;" & _
> "Driver={Microsoft Access Driver (*.mdb)};" & _
> "Dbq=/db/boonton.mdb;"
> conn.Open sConn

You've mixed up all kinds of garbage from all kinds of different places.
First off, decide whether you want to use Access or SQL Sevrer. Then, try
to make sure you use a JET OLEDB driver. Finally, keep in mind that the DBQ
value is expecting a *LOCAL* path. It has no idea what /db/ is.

Set conn = CreateObject("ADODB.Connection")
sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/db/boonton.mdb")
conn.open sConn

[url]http://www.aspfaq.com/2126[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Doug Parker]

got it, thanks for your help.

solution:

set conn = Server.CreateObject("ADODB.Connection")
sConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
server.mappath("boonton.mdb")
conn.Open sConn



"Doug Parker" <drparker@phreshdesign.com> wrote in message
news:#U8UxKxIEHA.2480@tk2msftngp13.phx.gbl...

> i apologize in advance - i've read every tutorial i could find on the
> subject, i just can't read another one. i'd really appreciate it if you
> guys would continue to walk me through it.
>
> did this:
>
> set conn = Server.CreateObject("ADODB.Connection")
> sConn = "Provider=MSDASQL;" & _
> "Driver={Microsoft Access Driver (*.mdb)};" & _
> "Dbq=/db/boonton.mdb;"
> conn.Open sConn
>
> got this:
>
> Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x744 Thread 0x3f0
> DBC 0x884b6e4 Jet'.
> /calibration/config1.asp, line 14
>
>
>
> "Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
> news:4085c726.17207272@msnews.microsoft.com...

> > On Thu, 15 Apr 2004 13:26:27 -0400, "Doug Parker"
> > <drparker@phreshdesign.com> wrote:
> >

> > >i'm trying to connect to an access database on an asp ready server.
> > >i know the ftp login information - does that apply to logging into the
> > >database string as well?

> >
> > Maybe. Maybe not. If the passwords and accounts are idnetical, yes.
> >

> > >will this work?
> > >

> >

>
>Provider=MSDASQL.1;Password=*****;PersistSecurity Info=True;UserID=username;

> > >
> > >
> > >please help, i'm a php/mysql programmer and i don't understand why this

> is

> > >so difficult. i'm think i'm losing my mind.

> >
> > Might look at some tutorials:
> >
> > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> > [url]http://www.tutorial-web.com/asp/database/[/url]
> > [url]http://www.vallin.com/pub/1/asp1.asp[/url]
> >
> > And of course:
> >
> >

>

[url]http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=asp+database+tutorial[/url]

> >
> > Jeff

>
>

[Aaron Bertrand [MVP]]

Great, now please read [url]http://www.aspfaq.com/2126[/url] to see why you should
change from using the ODBC driver to the JET OLEDB driver.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]


"Doug Parker" <drparker@phreshdesign.com> wrote in message
news:eQ9IRcxIEHA.2948@TK2MSFTNGP11.phx.gbl...

> got it, thanks for your help.
>
> solution:
>
> set conn = Server.CreateObject("ADODB.Connection")
> sConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> server.mappath("boonton.mdb")
> conn.Open sConn

[Bob Barrows [MVP]]

Doug Parker wrote:

> got it, thanks for your help.
>
> solution:
>
> set conn = Server.CreateObject("ADODB.Connection")
> sConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> server.mappath("boonton.mdb")
> conn.Open sConn
>

This is the wrong solution. The correct solution is:
sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & server.mappath("boonton.mdb")

The ODBC provider has been deprecated. You should use the native OLEDB
provider when one exists.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.