SQL pulls to SQLserver without setting a machine data source?

DSA — Fri, 26 Jan 2018 13:45:55 GMT

Hi JMP community,

I am playing with a ODBC connection to a SQLserver, and everything works nice when i connect via open table or query builder. I have then created my own query in JSL to be used with the open database() command, and that works well as well.

Right now my connection string looks like this SQLconnect="DSN=MyDatabase;Description=MyDatabase;Trusted_Connection=Yes";

MyDatabase is referring to the Data source I have created in the user interface using the standard microsoft SQL server driver and a server address, the rest are default settings.

Can I explicitly put all of this in my connection string, and how do I do that?

We hope to share this tool, and it would be annoying if I had to force all users to define their machine data source exactly as I did before they can use the tool.

Thanks in advance,

Daniel

Re: SQL pulls to SQLserver without setting a machine data source?

ih — Fri, 26 Jan 2018 14:26:22 GMT

Yes:

Open Database(
		"DRIVER=SQL Server;SERVER=mysqlserver\dbname;" ||
			"Trusted_Connection=Yes;APP=Microsoft® Windows® Operating System;",
		"SELECT * from db..."
	);

Re: SQL pulls to SQLserver without setting a machine data source?

DSA — Fri, 26 Jan 2018 14:33:06 GMT

Thank a lot for the very quick and accurate help!

It worked perfectly :)

topic Re: SQL pulls to SQLserver without setting a machine data source? in Discussions

SQL pulls to SQLserver without setting a machine data source?

Re: SQL pulls to SQLserver without setting a machine data source?

Re: SQL pulls to SQLserver without setting a machine data source?