SQL syntax assistance on a Pass-Through query desparately needed...

MLH

I apologize in advance to forum readers noticing this somewhat
redundant post. I fear that my Subject Heading was ill-chosen in
earlier post I made on this topic. Am hoping that a clearer Subject
heading will attract the knowledgeable forum contributors I'm
seeking. Thank-you...

I'm being academically challenged trying to build a pass-through
query inside of Access 2.0 to "reach out 'n touch" a remote data
file running on a Linux box in Kansas. I was able to achieve this
goal from within Access 97 (thanks be to the higher powers) but
am suffering somewhat with Access 2.0. I'm certain that it can be
done, but I'm just not the right man for the job without some
assistance.
What I've tried in Access 2.0 is to open a query in design view
and select the "Query" item from the menubar. Then choose
"SQL Specific" and "Pass-Through". Then, in the properties
box for the query object, I invoke the builder button for the
"ODBC Connect String" property. I'm then prompted to
specify an SQL Data Source. That's where I lose it. I
can't seem to input the parms (see prev post) needed.

Error: ODBC call failed... [MicroSoft] [ODBC DLL] Datasource not
found and no default ODBC driver specified.

I've tried stuff like the following for the ODBCConnectStr Property...
ODBC;DSN=ABCD;S ERVER=123.456.7 89.10;UID=UserN ame;PWD=MyPass
where ABCD is the dBase name on the remote server.

Somehow, my syntax just isn't getting through. Should I be passing
something else for the DNS and SERVER assignments? Where do
I go from here?

Nov 12 '05 #1

Subscribe Reply

6537

MGFoster

MLH wrote:

I apologize in advance to forum readers noticing this somewhat
redundant post. I fear that my Subject Heading was ill-chosen in
earlier post I made on this topic. Am hoping that a clearer Subject
heading will attract the knowledgeable forum contributors I'm
seeking. Thank-you...

I'm being academically challenged trying to build a pass-through
query inside of Access 2.0 to "reach out 'n touch" a remote data
file running on a Linux box in Kansas. I was able to achieve this
goal from within Access 97 (thanks be to the higher powers) but
am suffering somewhat with Access 2.0. I'm certain that it can be
done, but I'm just not the right man for the job without some
assistance.
What I've tried in Access 2.0 is to open a query in design view
and select the "Query" item from the menubar. Then choose
"SQL Specific" and "Pass-Through". Then, in the properties
box for the query object, I invoke the builder button for the
"ODBC Connect String" property. I'm then prompted to
specify an SQL Data Source. That's where I lose it. I
can't seem to input the parms (see prev post) needed.

Error: ODBC call failed... [MicroSoft] [ODBC DLL] Datasource not
found and no default ODBC driver specified.

I've tried stuff like the following for the ODBCConnectStr Property...
ODBC;DSN=ABCD;S ERVER=123.456.7 89.10;UID=UserN ame;PWD=MyPass
where ABCD is the dBase name on the remote server.

Somehow, my syntax just isn't getting through. Should I be passingsure
something else for the DNS and SERVER assignments? Where do
I go from here?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure about some of this, but . . . .

The DSN is the Data Source Name - have you created one on the PC the
application is running on? If you don't want to use a DSN you can go
DSN-less. Here's the part I'm not sure about - how to create a DSN
less connect string for dBase. In MS SQL Server a DSN-less connect
string would be like this:

ODBC;Driver={SQ L Server};Server= 123.456.789.10; UID=UserName;PW D=MyPass

So I'd guess dBase DSN-less connect string would be like this:

ODBC;Driver={Mi crosoft dBase Driver};Server= 123.456.789.10; UID=....
etc.

Look in the ODBC administrator for the names of the drivers available
on your PC. Hoepfully, any other PC that the Access app. runs on will
have the same db drivers.

I don't usually use the Builder wizards - I just type the string
straight into the ODBC Connect String property of the query.

The advantage of a DSN-less connection is you don't have to create a
DSN object for each PC that will use the application - as long as the
PC has access to the network that the db server is on the DSN-less
connection should work.

HTH,
- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP4dc04echKq OuFEgEQLTlwCgt2 UJLUCHBkk1s8Y3e 2IB/gUCiz8AoPDo
OFLfuWmSiVzZD0w lQ8iVKzLU
=mGqA
-----END PGP SIGNATURE-----

Nov 12 '05 #2

MLH

On Sat, 11 Oct 2003 01:28:34 GMT, MGFoster <me@privacy.com > wrote:

The DSN is the Data Source Name - have you created one on the PC the
application is running on? If you don't want to use a DSN you can go
DSN-less. Here's the part I'm not sure about - how to create a DSN
less connect string for dBase. In MS SQL Server a DSN-less connect
string would be like this:

ODBC;Driver={S QL Server};Server= 123.456.789.10; UID=UserName;PW D=MyPass

So I'd guess dBase DSN-less connect string would be like this:

ODBC;Driver={M icrosoft dBase Driver};Server= 123.456.789.10; UID=....

I tried MyODBC3.dll as the Driver= assignment value. Are the curly
brackets important? I tried with and without them - no luck. This is
the actual DLL file name. So, I thought "Maybe you don't use the
actual file nam... maybe the name of the user friendly name as its
known in Windows???" So,

I tried
ODBC;Driver=MyS QL ODBC 3.51
Driver;SERVER=1 23.456.789.10;U ID=UserName;PWD =MyPass

and I tried
ODBC;Driver={My SQL ODBC 3.51
Driver};SERVER= 123.456.789.10; UID=UserName;PW D=MyPass
(with the curly brackets)

- neither worked.

I have NO trouble with Access 97 getting to the remote server. I'm
sure Access 2.0 would do it if I can get around this connect string
thing.

Nov 12 '05 #3

MLH

How can I verify that a Data Source Name has been set up on a PC?
Its a Windows XP box.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxx
On Sat, 11 Oct 2003 01:28:34 GMT, MGFoster <me@privacy.com > wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure about some of this, but . . . .

The DSN is the Data Source Name - have you created one on the PC the
application is running on? If you don't want to use a DSN you can go
DSN-less. Here's the part I'm not sure about - how to create a DSN
less connect string for dBase. In MS SQL Server a DSN-less connect
string would be like this:

ODBC;Driver={S QL Server};Server= 123.456.789.10; UID=UserName;PW D=MyPass

So I'd guess dBase DSN-less connect string would be like this:

ODBC;Driver={M icrosoft dBase Driver};Server= 123.456.789.10; UID=....
etc.

Look in the ODBC administrator for the names of the drivers available
on your PC. Hoepfully, any other PC that the Access app. runs on will
have the same db drivers.

I don't usually use the Builder wizards - I just type the string
straight into the ODBC Connect String property of the query.

The advantage of a DSN-less connection is you don't have to create a
DSN object for each PC that will use the application - as long as the
PC has access to the network that the db server is on the DSN-less
connection should work.

HTH,
- --
MGFoster:::m gf
Oakland, CA (USA)

Nov 12 '05 #4

MGFoster

MLH wrote:

How can I verify that a Data Source Name has been set up on a PC?
Its a Windows XP box.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxx
On Sat, 11 Oct 2003 01:28:34 GMT, MGFoster <me@privacy.com > wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure about some of this, but . . . .

The DSN is the Data Source Name - have you created one on the PC the
application is running on? If you don't want to use a DSN you can go
DSN-less. Here's the part I'm not sure about - how to create a DSN
less connect string for dBase. In MS SQL Server a DSN-less connect
string would be like this:

ODBC;Driver={ SQL Server};Server= 123.456.789.10; UID=UserName;PW D=MyPass

So I'd guess dBase DSN-less connect string would be like this:

ODBC;Driver={ Microsoft dBase Driver};Server= 123.456.789.10; UID=....
etc.

Look in the ODBC administrator for the names of the drivers available
on your PC. Hoepfully, any other PC that the Access app. runs on will
have the same db drivers.

I don't usually use the Builder wizards - I just type the string
straight into the ODBC Connect String property of the query.

The advantage of a DSN-less connection is you don't have to create a
DSN object for each PC that will use the application - as long as the
PC has access to the network that the db server is on the DSN-less
connection should work.

HTH,
- --
MGFoster:::mg f
Oakland, CA (USA)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

To find the ODBC DSNs on Windows XP:

1. Click Start button
2. Click Settings - select Control Panel
3. Double-click "Administra tive Tools"
4. Double-click "Data Sources (ODBC)" - the ODBC administrator dialog
box will appear.
5. Under the User, System of File DSN tabs look for the Data Source
Name you had in your original connect string "DSN=???".

Re: your other post - You can't use the name of the DLL that holds the
db engine driver - use the name of the mySQL driver as it is listed in
the ODBC administrator dialog "Drivers" tab. I always use the curly
brackets for the Driver= parameter - that's how I learned it.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP4n8loechKq OuFEgEQJJEQCg3l LzMt25AN2b1/Xznv/aDca2mwoAoNJ3
xeXHm1Rq4sMxhpM dgXPAYCpv
=kcbI
-----END PGP SIGNATURE-----

Nov 12 '05 #5

Similar topics

2836

method (a, b = '', *c, **d): gets a syntax error?

by: Andreas Neudecker | last post by:

Hello. I am relatively new to Python and I have a strange problem with some code. In a class the __call__ method gets parameters like this: class WhatsUp: __call__ ( self, var1,

Python

2315

tweaking @decorator syntax

by: Sandy Norton | last post by:

If we are going to be stuck with @decorators for 2.4, then how about using blocks and indentation to elminate repetition and increase readability: Example 1 --------- class Klass: def __init__(self, name):

Python

1932

Decorator syntax

by: C. Barnes | last post by:

I vote for def f(): (body of function) This is backwards compatible (Python <= 2.3 raise SyntaxError), and looks much nicer than @. The only problem is that you can't one-line a decorated function. You can't do that with

Python

1632

Maybe, just maybe @decorator syntax is ok after all

by: Ville Vainio | last post by:

It might just be that @decorator might not be all that bad. When you look at code that uses it it's not that ugly after all. A lot of the furor about this is probably because it happened so quicly. The situation might have been different if we had seen a pronouncement a week before, in the vein of "I have chosen this syntax - it will go in to the next alpha". My chief worry was throwing away one of the few unused ascii symbols, but if...

Python

1587

remaining decorator syntax options

by: Steven Bethard | last post by:

So here's the state of the decorator debate as I see it: *** Location GvR pretty strongly wants decorators before the function: http://mail.python.org/pipermail/python-dev/2004-August/047112.html http://mail.python.org/pipermail/python-dev/2004-August/047279.html

Python

2437

pre-PEP: Suite-Based Keywords

by: Brian Sabbey | last post by:

Here is a pre-PEP for what I call "suite-based keyword arguments". The mechanism described here is intended to act as a complement to thunks. Please let me know what you think. Suite-Based Keyword Arguments ----------------------------- Passing complicated arguments to functions is currently awkward in Python. For example, the typical way to define a class property winds up polluting the class's namespace with the property's get/set...

Python

2736

Saving long text field to Access - Syntax Issue Problem

by: Drifter | last post by:

The quote below is part of the information i want to save to a MS Access database - or update, as the case may be. The original database was built a long time ago, and looking at the code for add/update on the original site-it does not compensate for odd syntax like the quotes. Problem i am hitting now is syntax issue in the SQL when I go to save/update. The syntax present causes failures every time. User said she had no problems...

ASP / Active Server Pages

2975

PEP: Specialization Syntax

by: Nicolas Fleury | last post by:

Hi everyone, I would to know what do you think of this PEP. Any comment welcomed (even about English mistakes). PEP: XXX Title: Specialization Syntax Version: $Revision: 1.10 $ Last-Modified: $Date: 2003/09/22 04:51:49 $ Author: Nicolas Fleury <nidoizo at gmail.com> Status: Draft Type: Standards Track

Python

1583

Optional algol syntax style

by: Sokolov Yura | last post by:

I think, allowing to specify blocks with algol style (for-end, if-end, etc) will allow to write easy php-like templates and would attract new web developers to python (as php and ruby do). It can be straight compilled into Python bytecode cause there is one-to-one transformation. So this: # -*- syntax-style: algol -*- class asd: def __init__(self,a): if a:

Python

2561

Python syntax question

by: Daniel | last post by:

I hope this question is OK for this list. I've downloaded Rpyc and placed it in my site packages dir. On some machines it works fine, on others not so much. Here is one error I get when I try to import it: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Python25\lib\site-packages\Rpyc\__init__.py", line 7, in <module>

Python

9456

What is ONU?

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...

General

10040

Problem With Comparison Operator <=> in G++

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...

C / C++

9713

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8713

AI Job Threat for Devs

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...

Career Advice

7248

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5142

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3806

transfer the data from one system to another through ip address

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

C# / C Sharp

3359

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2666

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General