473,698 Members | 2,393 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 97 DSNless connection to SQL server

<crossposted to several groups>
Is there any way to create a DSNless connection to SQL server from
access 97 (DAO)
All the samples of connection strings I am finding - all have a
reference to a DSN.

Many thanks
Tony
Nov 13 '05 #1
2 4341
Tony Epton wrote:
<crossposted to several groups>
Is there any way to create a DSNless connection to SQL server from
access 97 (DAO)
All the samples of connection strings I am finding - all have a
reference to a DSN.


(All one line)

ODBC;DRIVER=SQL Server;
SERVER=your_ser ver_name;DATABA SE=your_databas e_name;Trusted_ Connection=Yes

If you're not using Windows authentication (Trusted Connection) you'd
include the user id and it's password:

ODBC;DRIVER=SQL Server;SERVER=y our_server_name ;DATABASE=your_ database_name;
UID=sql_server_ login_name;pwd= your_passwd

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2
ace join_to wa**@iinet.net. au (Tony Epton) wrote:
<crossposted to several groups>
And answered in the microsoft newsgroups.
Is there any way to create a DSNless connection to SQL server from
access 97 (DAO)
All the samples of connection strings I am finding - all have a
reference to a DSN.


Using DSN-Less Connections
http://members.rogers.com/douglas.j....LessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/...BC_DSNLess.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1378
by: Jaunty Edward | last post by:
Hi, I need to get this ASP program to work with ms access instead of ms SQL... I have converted the DB now I just wanted to know should I just change the DB connection settings or there is more to be seen and taken care of. will I have to change the intire sql commands or its just the database connection setting. Warm Regards Jaunty Edward
0
1698
by: Asim | last post by:
I seem to be having a lot of problems with running/developing web site on my XP Professional OS. I have a simple web site (using ASP/VB), which retrieves information from an Access 2000 database. I have MS Access XP installed on my machine. When I open the database in Access and try to open up a page, I get this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Could not use '(unknown)'; file
8
1790
by: Bob Alston | last post by:
With all the recent discussions on ADPs and their lack of success, can someone point me to some GOOD reading on what is required to link MDBs to SQL Databases / Microsoft SQL Server 2000 Desktop Engine. Also are their any good, concise summaries of key differences that someone with Access/Jet experience would need to understand? Thanks Bob
4
9735
by: MrsBean | last post by:
I've been working on learning how to use PHP with MS Access, and as long as I use ODBC, I can make it work. I want to use a DSNless connection. Everthing I have tried has failed. Can anyone show me a simple example? MrsBean
2
1860
by: hmyers | last post by:
We have converted an Access 97 database to Access 2000 on an XP machine. The application uses a DSN-less connection: adoConn1.Open "DRIVER={iSeries Access ODBC Driver};" & _ "SYSTEM=SystemName;DBQ=LibraryName,Libraries;", sUserID, sPassword This fails everytime with an error message saying "Password for <sUserIdon server <SystemNameis not correct..." The user enters their userid and password via a form created in the
6
5597
by: venmore | last post by:
Hi Can someone please point in the right direction. I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while - no joy thanks
3
1673
anukagni
by: anukagni | last post by:
Hi, Using ASP with Ms access by DSN-less connection ..thats wat iam here from lotz of my cricle ..but the sad thing :(is iam not able to understand what they are saying please explain me wat is DSN connection and DSNless Connection.. anukagni
1
4598
by: vinodkus | last post by:
dear sir/madam Can any one help me how to connect ASP and MS ACCESS using FILE DSN. Thanks in Advance vinod
8
4250
Dököll
by: Dököll | last post by:
Hiya Fans! I hit a brick wall. I was attempting to make a DSNLess connection I seemed to have Goofed somewhere: Private Sub SQLServer_Click() Dim MyWorkspace As DAO.Workspace Set MyWorkspace = CreateWorkspace("", "admin", "", dbUseODBC) Dim MyConnection As DAO.Connection Set MyConnection = MyWorkspace.OpenConnection("", , , "ODBC;DATABASE=FirstSQLDB")
0
8676
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9161
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8897
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7732
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5860
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3050
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2006
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.