Can I use a DSN-less connection?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1735
Printed Date: 28 March 2026 at 12:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Can I use a DSN-less connection?
Posted By: betheball
Subject: Can I use a DSN-less connection?
Date Posted: 10 April 2003 at 10:59am
|
Can I use a DSN-less connection if the DB I want to connect to resides on a different server than my web page? My web page resides on a server called Web1. The DB I want to connect to is on a server called Apps1.
|
Replies:
Posted By: MorningZ
Date Posted: 10 April 2003 at 12:25pm
SQL: yes
Access: never seen it done, there are connection string for remote access db, but i have never seen a working example
-------------
Contribute to the working anarchy we fondly call the Internet
|
Posted By: betheball
Date Posted: 10 April 2003 at 1:48pm
|
I guess it probably complicates matters even more if I tell you my db is actually Excel, huh?
|
Posted By: MorningZ
Date Posted: 10 April 2003 at 1:59pm
well, while excel and access are almost one in the same...
theres no way you'll be able to do like you suggested...
http://www.able-consulting.com/MDAC/ADO/Connection/MSRemote.htm#MSRemoteAccess - Remote connection to Access , but i as said above, never seen it successfully pulled off (and there have been a lot of threads about this on lots of boards over the years)
maybe if you have some way of transfering the doc from the remote server to your web server, then you could just http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForExcel - hook in with this connection
-------------
Contribute to the working anarchy we fondly call the Internet
|
|