ODBC String - Microsoft Access / VBA

Not Me

Hi,

I have an ODBC connection to an SQL server database set up in my data
sources. Is there a way I can use this to create a connection string I could
use in a pass-through query? Otherwise is there a template of a string I
could use and just change the server/database names in it?

Cheers,
Chris

Nov 12 '05 #1

Subscribe Reply

2138

Alistair

"Not Me" <No****@faker.fake.fa.kee> wrote in message
news:c7**********@ucsnew1.ncl.ac.uk...

Hi,

I have an ODBC connection to an SQL server database set up in my data
sources. Is there a way I can use this to create a connection string I could use in a pass-through query? Otherwise is there a template of a string I
could use and just change the server/database names in it?

Cheers,
Chris

have you tried here

http://www.connectionstrings.com/

Nov 12 '05 #2

Roger

once you have the passthrough query created
goto the query properties (right click on the top bar)
and click at the end of the 'odbc connect str' to browse to a dsn you
wish to use and you can save the password in the string

"Not Me" <No****@faker.fake.fa.kee> wrote in message news:<c7**********@ucsnew1.ncl.ac.uk>...

Hi,

I have an ODBC connection to an SQL server database set up in my data
sources. Is there a way I can use this to create a connection string I could
use in a pass-through query? Otherwise is there a template of a string I
could use and just change the server/database names in it?

Cheers,
Chris

Nov 12 '05 #3

Not Me

"Roger" <le*********@natpro.com> wrote in message
news:8c*************************@posting.google.co m...

"Not Me" <No****@faker.fake.fa.kee> wrote in message news:<c7**********@ucsnew1.ncl.ac.uk>...
I have an ODBC connection to an SQL server database set up in my data
sources. Is there a way I can use this to create a connection string I could use in a pass-through query? Otherwise is there a template of a string I
could use and just change the server/database names in it?

once you have the passthrough query created
goto the query properties (right click on the top bar)
and click at the end of the 'odbc connect str' to browse to a dsn you
wish to use and you can save the password in the string

Aha! fantastic, never spotted that before :p

Cheers,
Chris

Nov 12 '05 #4

Similar topics

13859

Help: tomcat and JDBC/ODBC

by: Riccardo | last post by:

Hi, This jsp code doesn't run. Why ? ----------------------------------------------------------- <%@ page import="java.sql.*" %> <%! String Query(String SQL, String DSN) {

Java

5194

ODBC setting

by: Sean Anderson | last post by:

ODBC under System DSN Setup Access Driver give it the DSN (Data Source Name) MSA Click on Select and point to the myfile.mdb (your database file)

Java

2225

py2exe, mx.ODBC

by: Marco Aschwanden | last post by:

Hi - Win2000 - Python 2.3.3 - py2exe 0.5.0 - eGenix Comercial & Base Package I am developing an app using mxODBC. On the home page they say ...

Python

6165

ODBC on new installs

by: Lauren Quantrell | last post by:

Maybe a dumb question - I'm new to ODBC. How do I install an Access ..mde file on a user's workstation and create the ODBC connection to the backend SQL Server database without having to go through...

Microsoft Access / VBA

40378

ODBC connection failed

by: Alec | last post by:

Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network...

Microsoft Access / VBA

4567

access odbc output parameter

by: juststarter | last post by:

Hello all, I am executing a stored procedure (on an SQL Server) using ODBC but i can't get the output parameter's value on the client. The stored proc has 3 parameters ,2 of them are input and 1...

Visual Basic .NET

11997

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr

by: bazzer | last post by:

hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...

ASP.NET

12910

Close ODBC connection via code?

by: Greg Strong | last post by:

Hello All, Is there any way to close an ODBC connection via DSN without completely closing the Access front-end? I'm doing some testing with using Access as a front-end to Oracle 10g Express...

Microsoft Access / VBA

9605

Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End

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

Microsoft Access / VBA

2518

UpSizing Wizard and AUTO DNS ODBC Connection

by: Michael Kintner | last post by:

How do I create and ODBC connection enbedded inside a link???? The upsizing wizard worked great however when it created the ODBC connection somehow it enbeddeds the link and does not add to USER...

Microsoft Access / VBA

7037

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

General

6904

Changing the language in Windows 10

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

Windows Server

7076

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

6873

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

General

4767

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

Microsoft Access / VBA

4471

Couldn’t get equations in html when convert word .docx file to html file in C#.

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

C# / C Sharp

2990

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

Networking - Hardware / Configuration

2976

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1294

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

C# / C Sharp