By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

ODBC String

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a

"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

P: n/a
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

P: n/a
"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

This discussion thread is closed

Replies have been disabled for this discussion.