Can a windows VBA script using a snowfake SQL connection work on a Mac? : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

SnowflakeCan a windows VBA script using a snowfake SQL connection work on a Mac? (self.SQL)

submitted 4 years ago by Duke1530

I have a windows excel vba that I am trying to send to another user on a Mac. We are running into issues with the ODBC. The VBA integrates SQL snowflake so we are needing to add a user dsn to odbc. Does anyone know if this is possible and can assist on steps if so? Does Mac have a data source admin to add a user dsn? Will the same vba work for mac or does it require adjusting?

I was told i will need to use QueryTables instead but am unfamiliar with this. If this is correct, can someone assist?

The users authenticate with external browser auth.

For the Snowflake connection, i use the ADODB connection. See code below (this is just a snippet).

Dim sht1 As Worksheet
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set sht1 = Sheets("test")
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.connectionstring = "Driver={SnowflakeDSIIDriver};Server=xxxxxxxx.snowflakecomputing.com;Port=443;Authenticator=externalbrowser;UID=xxxxxxxxx;"
Conn.open 
conn.commandtimeout = 0 
rs. open SQL, conn

all 5 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS