Import Data from SQL Server DSN-less connection string

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

ezteiw
Posts: 1
Joined: Wed Dec 12, 2012 3:25 pm

Import Data from SQL Server DSN-less connection string

Postby ezteiw » Wed Dec 12, 2012 3:32 pm

Hello,

I am trying to design a Syntax that imports data from a SQL Server.
This is no problem using a syntax created with the make new query functionality.

Only this always depends a DSN name/existing ODBC driver specific for a server/database.

I want to share this syntax with someone else without having to make the same ODBC driver on a different PC. This is because of flexible work stations.

I cannot find a way or example "/CONNECT=" string anywhere on the web. For a Access database this is not a problem.

Can you help me?

Who is online

Users browsing this forum: No registered users and 1 guest

cron