Sql query referencing dsn connection?

[wmikeh]

Can you reference a dsn connection table in a SQL query?
I would like to use a stored procedure to do an INSERT INTO query from an odbc dsn connection into my sql database and would like to know if this is possible.

 

[cmmrfrds]

Why do you want to use ODBC which is normally used for older apps developed before OLEDB was available.

 

[wmikeh]

I'm using QODBC to connect my access project to Quickbooks. I could use the Quickbooks skd, but it is so much easier to just use the ODBC driver.

 

[cmmrfrds]

You should be able to with ODBC, but I don't have any examples since I use mostly OLEDB connections. This site might give you some ideas, although I did not see a Quickbooks ODBC.

http://www.carlprothman.net/Default.aspx?tabid=81