Hi all,
Wondering if anyone made a successful connection between Eviews and Snowflakes. I can connect Eviews and Excel through ODBC driver, but somehow couldn't make Eviews and Snowflake connected. I also couldn't find Evews logfile.
Thanks in advance if anyone can offer help.
Vicky
Eviews and snowflake
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Eviews and snowflake
Turns out the Snowflake ODBC driver won't let you connect interactively as is normally required for use in EViews. To work around this problem, you'll have to manually create a DSN file and then use that from within EViews. Here's what the DSN file should look like:
Replace all the values above (including your password) with your own specific values then save this file in your Documents folder as testsnow.dsn.
Then start EViews, go to File menu/Open/Workfiles, select ODBC from the File Type dropdown, then select the "testsnow.dsn" from your Documents folder. Assuming all the values were correct, you should see a "Select table" dialog appear with a list of available tables.
Steve
Code: Select all
[ODBC]
DRIVER=SnowflakeDSIIDriver
UID=myusername
PWD=mypassword
SERVER=myservername
DATABASE=mydb
SCHEMA=myschema
WAREHOUSE=mywarehouse
ROLE=myrole
APP=EViews
Replace all the values above (including your password) with your own specific values then save this file in your Documents folder as testsnow.dsn.
Then start EViews, go to File menu/Open/Workfiles, select ODBC from the File Type dropdown, then select the "testsnow.dsn" from your Documents folder. Assuming all the values were correct, you should see a "Select table" dialog appear with a list of available tables.
Steve
Return to “Installation and Registration”
Who is online
Users browsing this forum: No registered users and 3 guests