473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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;SERVER=123.456.789.10;UID=UserName;P WD=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
4 6508
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;SERVER=123.456.789.10;UID=UserName;P WD=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={SQL Server};Server=123.456.789.10;UID=UserName;PWD=MyP ass

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:::mgf
Oakland, CA (USA)

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

iQA/AwUBP4dc04echKqOuFEgEQLTlwCgt2UJLUCHBkk1s8Y3e2IB/gUCiz8AoPDo
OFLfuWmSiVzZD0wlQ8iVKzLU
=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={SQL Server};Server=123.456.789.10;UID=UserName;PWD=MyP ass

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

ODBC;Driver={Microsoft 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=MySQL ODBC 3.51
Driver;SERVER=123.456.789.10;UID=UserName;PWD=MyPa ss

and I tried
ODBC;Driver={MySQL ODBC 3.51
Driver};SERVER=123.456.789.10;UID=UserName;PWD=MyP ass
(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.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx
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;PWD=MyP ass

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:::mgf
Oakland, CA (USA)


Nov 12 '05 #4
MLH wrote:
How can I verify that a Data Source Name has been set up on a PC?
Its a Windows XP box.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx
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;PWD=MyP ass

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:::mgf
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 "Administrative 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/AwUBP4n8loechKqOuFEgEQJJEQCg3lLzMt25AN2b1/Xznv/aDca2mwoAoNJ3
xeXHm1Rq4sMxhpMdgXPAYCpv
=kcbI
-----END PGP SIGNATURE-----

Nov 12 '05 #5

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

Similar topics

11
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,
14
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...
23
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...
11
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...
7
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: ...
31
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...
5
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...
19
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 $...
3
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...
6
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.