ASP connection string (remote MS Access db)

[WoG]

I am having problems connecting to a MS Access DB that is on a network
server (not local) through ADO/ASP.

Here is the latest version of my connection string:
'set connmajors = server.CreateObject("ADODB.Connection")
'connmajors.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\accessdb.mdb; Uid=***; Pwd=***;"

This does not work. I want to use a DSNless connection, but there are
so many examples of different types of those- I am a bit confused. Do I
even need the username/password?

My goal is to connect to a MS Access db to pull values from a table to
populate a drop down list.

Does anyone have experience trying to get MS Access data off of a server
and populate a drop down list?

Thanks
Jesse

[Aaron Bertrand - MVP]

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

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




"WoG" <jesusfreaks18@hotmail.com> wrote in message
news:ux61$fcPEHA.2128@TK2MSFTNGP11.phx.gbl...

> I am having problems connecting to a MS Access DB that is on a network
> server (not local) through ADO/ASP.
>
> Here is the latest version of my connection string:
> 'set connmajors = server.CreateObject("ADODB.Connection")
> 'connmajors.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=\\server\accessdb.mdb; Uid=***; Pwd=***;"
>
> This does not work. I want to use a DSNless connection, but there are
> so many examples of different types of those- I am a bit confused. Do I
> even need the username/password?
>
> My goal is to connect to a MS Access db to pull values from a table to
> populate a drop down list.
>
> Does anyone have experience trying to get MS Access data off of a server
> and populate a drop down list?
>
> Thanks
> Jesse
>

[WoG]

Aaron-

Thanks for helping me get connected- the advice worked.

However, I am now getting an error that says cannot create Business
Object, or something like that.

Know what that means? Is it a permission problem with the remote server?

Thanks,
Jesse


Aaron Bertrand - MVP wrote:

> [url]http://www.aspfaq.com/2168[/url]
>

[Aaron Bertrand - MVP]

> However, I am now getting an error that says cannot create Business

> Object, or something like that.

Can you be more specific? It's hard to tell google or aspfaq.com or other
search engines to search for "something like ... " ... however, if you
include the actual error message instead of a paraphrase, I might recognize
it straight off, or find a relevant article within a few seconds.

[WoG]

My apologies-

It's error 800a1004
"Business Object cannot be created"

I've googled it as well, not coming up with much...

Thanks
Jesse

Aaron Bertrand - MVP wrote:

>>However, I am now getting an error that says cannot create Business
>>Object, or something like that.

>
>
> Can you be more specific? It's hard to tell google or aspfaq.com or other
> search engines to search for "something like ... " ... however, if you
> include the actual error message instead of a paraphrase, I might recognize
> it straight off, or find a relevant article within a few seconds.
>
>

[Bob Barrows [MVP]]

WoG wrote:

> My apologies-
>
> It's error 800a1004
> "Business Object cannot be created"
>

What is the line of code that generates this error? It does not sound like a
MS error message.

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.

[Aaron Bertrand - MVP]

I can say with 99% certainty that this error has nothing to do with
connecting to the database itself. Perhaps you have some kind of
OLEAutomation in a query or something within the database, but it would help
if you could narrow down exactly where this happens in your code (none of
which we've seen thus far).

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




"WoG" <jesusfreaks18@hotmail.com> wrote in message
news:#ILpYtdPEHA.1620@TK2MSFTNGP12.phx.gbl...

> My apologies-
>
> It's error 800a1004
> "Business Object cannot be created"
>
> I've googled it as well, not coming up with much...
>
> Thanks
> Jesse
>
> Aaron Bertrand - MVP wrote:

> >>However, I am now getting an error that says cannot create Business
> >>Object, or something like that.

> >
> >
> > Can you be more specific? It's hard to tell google or aspfaq.com or

other

> > search engines to search for "something like ... " ... however, if you
> > include the actual error message instead of a paraphrase, I might

recognize

> > it straight off, or find a relevant article within a few seconds.
> >
> >

>

[Bob Barrows [MVP]]

Oh wait. You're attempting to use RDS, which has nothing to do with ASP -
it's all client-side code.
Here is a KB article about this error:
[url]http://support.microsoft.com/?kbid=251122[/url]

Please go to a RDS or remotescripting newsgroups if you need more help with
this.

Bob Barrows

WoG wrote:

> My apologies-
>
> It's error 800a1004
> "Business Object cannot be created"
>
> I've googled it as well, not coming up with much...
>
> Thanks
> Jesse
>
> Aaron Bertrand - MVP wrote:

>>> However, I am now getting an error that says cannot create Business
>>> Object, or something like that.

>>
>>
>> Can you be more specific? It's hard to tell google or aspfaq.com or
>> other search engines to search for "something like ... " ...
>> however, if you include the actual error message instead of a
>> paraphrase, I might recognize it straight off, or find a relevant
>> article within a few seconds.

--
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.

[WoG]

here is the connection string and the recordset opening:

<%
'Request the majors list for a dropdown
SQLMAJORS = "SELECT Majorn, Major FROM Majors"

cst = "Provider=MS Remote;" &_
"Remote Server=server;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=folder/correctdb.mdb;"
set conn = server.CreateObject("ADODB.Connection")
conn.open cst
set stuff = server.CreateObject("ADODB.Recordset")

stuff.open SQLMAJORS, conn
dim Q, rs_1
Q = chr(34)
%>

The error line is:
stuff.open SQLMAJORS, conn

Jesse

Aaron Bertrand - MVP wrote:

> I can say with 99% certainty that this error has nothing to do with
> connecting to the database itself. Perhaps you have some kind of
> OLEAutomation in a query or something within the database, but it would help
> if you could narrow down exactly where this happens in your code (none of
> which we've seen thus far).
>

[Aaron Bertrand - MVP]

> "Data Source=folder/correctdb.mdb;"

What is this? You'll notice in the article that you need to specify the
*LOCAL* *ABSOLUTE* path on the remote server. So, if the remote server has
c:\inetpub\wwwroot\folder\correctdb.mdb you need to put that. A relative
path won't work.

A

[WoG]

Yeah, I know- I just didn't feel like posting that path on this forum.
Thanks though.

Jesse

Aaron Bertrand - MVP wrote:

>> "Data Source=folder/correctdb.mdb;"

>
>
> What is this? You'll notice in the article that you need to specify the
> *LOCAL* *ABSOLUTE* path on the remote server. So, if the remote server has
> c:\inetpub\wwwroot\folder\correctdb.mdb you need to put that. A relative
> path won't work.
>
> A
>
>

[Bob Barrows [MVP]]

WoG wrote:

> Yeah, I know- I just didn't feel like posting that path on this forum.
> Thanks though.
>

So post this instead:
"Data Source=" & Server.MapPath("folder/correctdb.mdb")

Not only use it in your newsgroup posts, use it in your code as well.

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.

[Aaron Bertrand - MVP]

> So post this instead:

> "Data Source=" & Server.MapPath("folder/correctdb.mdb")

No, he can't run the code that way. If he runs server.mappath() in the
local ASP code, it will translate the relative path to the LOCAL web
structure. He is connecting to an ASP database on a remote server, so he
has to supply the absolute remote path.

Anyway, what good does c:\folder\file.mdb give me? I'd have to know where
his server is and then gain access to his file system to find the file. In
contrast, exposing the relative path is arguably more dangerous... I only
need to know where his server is, then I can just type the relative URL into
the browser.

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

[Bob Barrows [MVP]]

Aaron Bertrand - MVP wrote:

>> So post this instead:
>> "Data Source=" & Server.MapPath("folder/correctdb.mdb")

>
> No, he can't run the code that way. If he runs server.mappath() in
> the local ASP code, it will translate the relative path to the LOCAL
> web structure. He is connecting to an ASP database on a remote
> server, so he has to supply the absolute remote path.

Oh duh! That explains the RDS error message as well.



--
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.

[WoG]

Considering it's not even the correct relative path, it's a *VERY* moot
point.

Thanks for your help.
Jesse

Aaron Bertrand - MVP wrote:

>>So post this instead:
>>"Data Source=" & Server.MapPath("folder/correctdb.mdb")

>
>
> No, he can't run the code that way. If he runs server.mappath() in the
> local ASP code, it will translate the relative path to the LOCAL web
> structure. He is connecting to an ASP database on a remote server, so he
> has to supply the absolute remote path.
>
> Anyway, what good does c:\folder\file.mdb give me? I'd have to know where
> his server is and then gain access to his file system to find the file. In
> contrast, exposing the relative path is arguably more dangerous... I only
> need to know where his server is, then I can just type the relative URL into
> the browser.
>

[Aaron Bertrand - MVP]

> Considering it's not even the correct relative path, it's a *VERY* moot

> point.

I merely brought it up because you were afraid to post the real path here
(and changing the format led to confusion).

[sattu]

I am having problems connecting to a MS Access DB that is on a network
server (not local) through ADO/ASP.

Here is the latest version of my connection string:
'set connmajors = server.CreateObject("ADODB.Connection")
'connmajors.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\accessdb.mdb; Uid=***; Pwd=***;"

This does not work. I want to use a DSNless connection, but there are
so many examples of different types of those- I am a bit confused. Do I
even need the username/password?

My goal is to connect to a MS Access db to pull values from a table to
populate a drop down list.

Does anyone have experience trying to get MS Access data off of a server
and populate a drop down list?

Thank
Jesse

There is no need to use username/password.
try it...it is working...
but firstly u have to create DSN
var axoConnection = new ActiveXObject("ADODB.Connection");
var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/snv.mdb";
var axoRecordSet = new ActiveXObject("ADODB.Recordset");
var SQL = "select x from snv";

axoConnection.Open(strConnection);
axoRecordSet.Open(SQL, axoConnection);


while (axoRecordSet != null) {

alert(axoRecordSet(0))
axoRecordSet.movenext();
break;

}