I've been using Dreamweaver MX connecting to an IIS 6 server on
win2003. I've used an MS Access DB (2000 format) If I use server DNS,
I connect to my via ASP with out a problem. However, my ISP does not
support DNS connections, so I've been trying for a few days to get a
dns less connection work. This is the closes I've got:
Dim MM_ElimCaAspSer ver_STRING
MM_ElimCaAspSer ver_STRING = Connection = "Driver={Micros oft Access
Driver (*.mdb)}; DBQ=" + Server.MapPath( "/assets/ElimDb/elimCan.mdb")
I can setup the connection and can test the Record set, it's OK Can
see the table data in the test in DW. But when I launch the page, I
get a http 500 error. And again, I had no problem with DNS in the
same environment.
Help!! 1 3088
Big Dave wrote:
Already answered over in .db
Please do not multipost Dave. This is definitely a database-related
question so .asp.db was the perfect group in which to post it. Posting it
here as well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.
There are times when you will not be sure which group is most appropriate
(again, this was not one of them), and you will want to post a question to
both groups. In that situation, you should use the cross-posting technique,
rather than posting the same message multiple times. To crosspost, put
a semicolon-delimited* list of the newsgroups to which you wish to post in
the To: header of your post and post it once. It, and any replies to it,
will appear in all the newsgroups in your list. So, if I reply in .asp.db,
my reply will also appear here in .asp.general.
* ... or whatever delimiter is recognized by your news client
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: shank |
last post by:
What's wrong with the syntax in this connection string?
It's a DSN less connection to an Access DB.
thanks!
<%
Set Conn = Server.CreateObject("ADODB.Connection")
MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("authors.mdb") & ";" & _
Jet OLEDB:Database Password=48912; & _
Jet OLEDB:System...
|
by: slc |
last post by:
Help,
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it...
|
by: Paul Mitchell |
last post by:
I have taken several individual apps that each use a dsn and combined
them into one app. I was wondering if anyone has any sample code that
would allow switching between odbc dsn-less connections to multile
dbs, with and without Trusted NT? the following function works but I
can't figure out the logic to deploy it. Essentially the databases...
|
by: Ken |
last post by:
How can I copy data from SQL to MS Access using dsn-less connection
and not using SQL DTS? I have this but am stuck. I just want to do
an export but can't figure out how to do a "select into". It pastes
the data in SQL instead of access. The below code will cycle but I
will have to create a table to place the data first. Is there an...
|
by: Roald Oines |
last post by:
I've implemented Doug Steele's code (
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html ) to create
a dsn-less connection to a SQL Server database from Access 2003 under XP
Pro. I was given a userid and password for the database I'm connecting
to, so I put them in the connection string and changed
Trusted_Connection from yes to no....
| |
by: ZRexRider |
last post by:
Hi,
I have an application that uses MS-SQL Linked tables. I have a utility
routine that drops all links and re-establishes them. It works great
when my connection string is a DSN connection but I would like to
change it to DSN-Less so users don't have to set up ODBC connections on
each workstation.
If I use the following DSN
|
by: Greg Strong |
last post by:
Hello All,
The short questions are
1 Do you know how to make DSN connection close in Access to Oracle 10g
Express Edition?
&/or
2 Do you know how to make a DSN-less pass-through query work from
|
by: Brad |
last post by:
With Oracle 9.2 drivers, this worked connection string worked in a DSN-less
connection
ODBC;DRIVER={Microsoft ODBC For
Oracle};Server=MyServerName;UID=MyName;PWD=MyPwd;
However, after upgrading to Oracle 10.2, the connection string does not
work.
I don't want to go back to a regular DSN connection because of the setup
involved on many...
|
by: Bill Nguyen |
last post by:
I have this connection string using ODBC DSN
Dim FactorJaco As String = "dsn=jaco;catalog=factor;uid=user;pwd=passord"
This requires an ODBC DSN (jaco) at every client PC. I need to use DSN-less
connection for terminal server setup.
Any help is greatly appreciated.
|
by: misterb |
last post by:
Hello, and thanks for your help to my last question :)
I am setting up my website using ASP and an Access database, the site is being hosted, with an option to use DSN, but the recommendation from the hosting company is to use a DSN-less connection.
The following is the configuration for the Access database connection, but I find the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |