ODBC help

[atiqraza]

I am still new to sql server so i apologize if this sounds like a trivial question.
I want to query a odbc connection using a query in sql server. the connection string for the DSN naturally looks like "DSN=xxxx;UID=xxxx;PWD=xxx"

Could someone tell me how i can use this is a query to query the odbc driver so i can load it in to my sql server tables ...
Thanks

 

[rac2]

What progamming language are you using, ASP, .NET, perl, php, Windows Script? This will determine what kinds of ODBC component are available. For example, in ASP, you would use ADODB, other languages have other components.

 

[bborissov]

atiqraza,
this is a question to your front-end forum.
What you use as a Front-End programing?
How your front-End connect to external data Sources?
These question, as I said, are related mostly to your Front-End forum.

BTW you didn't query your ODBC driver, you pass the query to BackEnd via ODBC driver.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[mabho]

If you have problems trying to find out the right Connection String (is that an issue for you?) I suggest

http://www.connectionstrings.com/