Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to connect to an Access data source

Posted on 2000-04-27
7
Medium Priority
?
1,932 Views
Last Modified: 2010-03-17
I've a MSaccess97 database with a single table.
How do I go about writing the connection string.  I have no idea about odbc drivers, I've tried following the online help.
I'm on win98
Through the control panel OBBC datasources I have gone to System DSN, then added Microsoft Access driver (*.mdb) and made up a name 'msaa', then selected a specific database.

Then in Flash under set enviroment I put this:-

msaa:///?driver=obdcjt.dll&url=antennas.mdb&userid=&password=SELECT%20%20FROM%20antennatest

suprisingly (!) it does not work, there are so many things I don't understand I am looking for any help or advice.
0
Comment
Question by:susannahbond
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 

Expert Comment

by:ranjit021100
ID: 2776248
hI,

Following set of code may help u.

String strAccConnUrl="jdbc:odbc:msaa";

Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");                         
connDB = DriverManager.getConnection(strAccConnUrl);       

Regds
Ranjith
0
 

Accepted Solution

by:
huijkman earned 300 total points
ID: 2786204
Hi Susanna,
It seems like the URL you put under Set Environment is incomplete. You put the query part directly after the password without calling it first, and you left out an essential *, in the end it should ressemble something like this: (after the password part) &query=SELECT%20*%20FROM%20antennatest.
Apart from that you put your DSN at the beginnig of the URL. the first part contains info about the ODBC driver so your DSN should not be there, it is called in another part of the URL. Try the following URL:
fgjdbc:///?driver=sun.jdbc.odbc.JdbcOdbcDriver&url=jdbc:odbc:msaa&userid=&password=&query=SELECT%20*%20FROM%20antennatest
I got this from the Generator manual and completed it with your specific data
Good Luck
Huijkman
0
 
LVL 1

Author Comment

by:susannahbond
ID: 2955152
the comment below is more helpful
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 1

Author Comment

by:susannahbond
ID: 2955154
Comment accepted as answer
0
 

Expert Comment

by:john_
ID: 4604978
hi Susannahbond,

Please pardon for posting my question here.  I really cant find anymore help from other people.  I think you might have better picture of how to drive the database from MS Access to Macromedia Generator.  I am really a newbie in drivig the database from one source to another source.  Hence can you please help me to overcome my problem. (I have been assigned this task but I really have zero knowledge on it)  I do try many methods of driving the data either from Macromedia help file or online solutions.  Please let me know if you are willing to help me.  Thus i will send you my problem. (this is to show my respcet to you)

from John
s9813119@mmu.edu.my
0
 

Expert Comment

by:huijkman
ID: 4619759
Hi John,

Maybe I can help you. I have worked with Generator and MS Access for several months. So send me your problem and I will have a look at it. I also know how hard it is to get specific information about the subject. (I've been there).

huijkman@hotmail.com

0
 

Expert Comment

by:john_
ID: 4632941
Hi huijkman,

I am so glad that for your feedback.  In fact i wish to let you solve my problems here but I couldnt attach my relevant problem and error messages from my work.  Hence I wish to send you my questions from your personal hotmail address.  Please concern about my situation.  

Thanks Huijkman.  

from John
s9813119@mmu.edu.my
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question