Can it be that NO ONE HERE knows this answer?

[Lauren Wilson]

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?

[David W. Fenton]

Lauren Wilson <no****@nospam. com> wrote in
news:9o******** *************** *********@4ax.c om:

On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@dfe nton.com.invali d> wrote:

Is running SQL Server or some other server db on the web server
not a possibility?

It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database. .
. .

I'm confused. An MDB can connect to a remote SQL Server database, so
why would you implement a DAP just to get to the remote SQL Server
database?
. . . If so,
believe (hope) I can create a hidden DAP form to be the interface
for this licensing, update checking process. I know, I know.
DAPs are going away in Office 12. But we should be able to
continue using Access 2003 for at least another 2-3 years. After
that, I'll just re-write the procedure using the Access 12
technology. Since it's a process that's transparent to the user,
they'll never know the difference.

I don't get what purpose a DAP would serve in a scenario where you
had a remote SQL Server connection available to your local MDB.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Lauren Wilson]

On Sun, 19 Mar 2006 14:31:13 -0600, "David W. Fenton"
<XX*******@dfen ton.com.invalid > wrote:

Lauren Wilson <no****@nospam. com> wrote in
news:9o******* *************** **********@4ax. com:

On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@df enton.com.inval id> wrote:

Is running SQL Server or some other server db on the web server
not a possibility?

It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database. .
. .

I'm confused. An MDB can connect to a remote SQL Server database, so
why would you implement a DAP just to get to the remote SQL Server
database?

OK, to get us in sync: Until about 36 hours ago, I was CONSIDERING
whether or not a DAP could be used for something that I THOUGHT was
not possible without it. Either I misread earlier posts or there is
disagreement about the issue among those who posted responses.

Bottom line: You appear to be saying that it IS possible to use ADO
FROM the VBA code of an MDB (or MDE) to connect to a table in an SQL
Database on a remote web server, using an HTTP URL as a connection
string -- correct?

Until you reminded me that this might be possible, I first looked for
a way to do it with an MDB on the web server. Since I have access to
several web servers running either MS SQL Server OR MySQL, I've simply
switched my focus to doing it that way.

. . . If so,
believe (hope) I can create a hidden DAP form to be the interface
for this licensing, update checking process. I know, I know.
DAPs are going away in Office 12. But we should be able to
continue using Access 2003 for at least another 2-3 years. After
that, I'll just re-write the procedure using the Access 12
technology. Since it's a process that's transparent to the user,
they'll never know the difference.

I don't get what purpose a DAP would serve in a scenario where you
had a remote SQL Server connection available to your local MDB.

[Lyle Fairfield]

ROFL!

[rkc]

Lyle Fairfield wrote:

ROFL!

You were right all along.
I should know that by now.

[Lyle Fairfield]

This solution is where I would probably go for some small data to
support my application.
It seems simple and quick and easily modifed from the server side by
messing with the ASP files.
And I am right in thinking that if the ASP can get at a db, any db, and
write some data, I can suck that data back into my Access or other
application? And I could send Parameters?
I'm going to have to play with this after income tax season.
I suppose I can use it from Script with the ActiveXObject too!
or even from ASP ... to ASP
Hmmmmmm ...
sounds too good to be true ... what's the catch?

[rkc]

Lyle Fairfield wrote:

This solution is where I would probably go for some small data to
support my application.
It seems simple and quick and easily modifed from the server side by
messing with the ASP files.
And I am right in thinking that if the ASP can get at a db, any db, and
write some data, I can suck that data back into my Access or other
application? And I could send Parameters?
I'm going to have to play with this after income tax season.
I suppose I can use it from Script with the ActiveXObject too!
or even from ASP ... to ASP
Hmmmmmm ...
sounds too good to be true ... what's the catch?

It's so simple it seems like magic, but it is also what makes
the so called Ajax technology possible. All major up to date
browsers support an xmlhttp object. Microsoft as an active x
object. The others built in to the javascript support of the
browser.

[Bri]

Lauren Wilson wrote:

Bottom line: You appear to be saying that it IS possible to use ADO
FROM the VBA code of an MDB (or MDE) to connect to a table in an SQL
Database on a remote web server, using an HTTP URL as a connection
string -- correct?

Close, but not quite right. If you are connecting directly to the remote
server db (SQL Server or MySQL) then you can do so using the appropriate
connection string. This will NOT be a HTTP URL. For a list of all
possible connection strings (or at the very least all of the meaningful
ones) take a look at:
http://www.carlprothman.net/Default.aspx?tabid=81

From this fantastic resource (adjust to your specifics):

ODBC Driver for MySQL (via MyODBC)
To connect to a remote database

oConn.Open "Driver={mySQL} ;" & _
"Server=db1.dat abase.com;" & _
"Port=3306; " & _
"Option=131072; " & _
"Stmt=;" & _
"Database=mydb; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

HTH
--
Bri

[David W. Fenton]

Lauren Wilson <no****@nospam. com> wrote in
news:r4******** *************** *********@4ax.c om:

On Sun, 19 Mar 2006 14:31:13 -0600, "David W. Fenton"
<XX*******@dfe nton.com.invali d> wrote:

Lauren Wilson <no****@nospam. com> wrote in
news:9o****** *************** ***********@4ax .com:

On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@d fenton.com.inva lid> wrote:

Is running SQL Server or some other server db on the web server
not a possibility?

It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database.
. . .

I'm confused. An MDB can connect to a remote SQL Server database,
so why would you implement a DAP just to get to the remote SQL
Server database?

OK, to get us in sync: Until about 36 hours ago, I was
CONSIDERING whether or not a DAP could be used for something that
I THOUGHT was not possible without it. Either I misread earlier
posts or there is disagreement about the issue among those who
posted responses.

Bottom line: You appear to be saying that it IS possible to use
ADO FROM the VBA code of an MDB (or MDE) to connect to a table in
an SQL Database on a remote web server, using an HTTP URL as a
connection string -- correct?

No. Not HTTP -- a direct connection to the SQL Server port.
Until you reminded me that this might be possible, I first looked
for a way to do it with an MDB on the web server. Since I have
access to several web servers running either MS SQL Server OR
MySQL, I've simply switched my focus to doing it that way.

Well, I was not suggesting HTTP -- Access's capabilities in that
regard have already been completely defined in this thread. A
different back end on the server does not change that.

The only thing a server database changes is that there's a process
running on the server to connect to, which is not the case with an
MDB. If the ISP can't open up the SQL Server port, or provide a VPN
connection, then this won't work, either.

But Lyle has frequently posted about the ISPs that provide this kind
of service. I have no dealings with any of them, since I will never
buy web hosting from a Windows-based ISP, since I consider it
substandard.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/