ERROR in Connecting SQL

[Anonymous]

when i press 
file" thin " Export" , then "ODBC" , connection get Failed and never export 

[Viveka_CD]

Hi @Anonymous

Can you check if you have 64bit drivers installed, instead of 32bit as those no longer work wiRevitvit.  In your user's Data source config you should initially check that the server's address is correct, check the password. 

You can also try from the command prompt to ping the db server from their PC to ensure that there isn't some different network issue.

Steps to Create an ODBC DSN for a SQL Server Database

1. On the Windows Start menu, click Settings, click Control Panel, click Administrative Tools, click Data Sources (ODBC). The ODBC Data Source Administrator dialog box is displayed.
2. In the ODBC Data Source Administrator dialog box, click the User DNS tab if you want the data source to be visible only to you on this machine, or click the System DSN tab if you want the data source to be visible to others on this machine and on the network. Click Add. The Create New Data Source dialog box is displayed.
3. In the Create New Data Source dialog box, click SQL Server, click Finish. The Create a New Data Source to SQL Server dialog box is displayed.
4. In this dialog box, in the text entry box labeled Name , type the name that you want to use as the value of the DataSourceName connection property.
5. In this dialog in the text entry box labeled Server, type the name of the SQL Server that you want to connect to.
6. Click Next to go to the next screen where you see the network login Id is used to verify the user’s identity.
7. Click Next to go to the next screen where you can change the default database.
8. Click Next to go to the next screen where you can change other parameters.
9. Click Finish. The ODBC Microsoft SQL Server Setup dialog appears showing the configuration parameter settings.
10. In this dialog click Test Data Source.... The SQL Server ODBC Data Source Test dialog appears giving you test results. Click OK to close this dialog.
11. Click OK to close the ODBC Microsoft SQL Server Setup dialog.
12. In the ODBC Data Source Administrator dialog box, you see the DSN that you just added listed. Click OK.

Please select the Accept as Solution button if my post solves your issue or answers your question. Likes welcome!

Regards,

[informatica]

Hi, Viveka

i'm receiving this error when i try to connect the DNS that i created before

I don't know if it is an error with the connection itself or just some of the parameters that i didn't put correctly

Could you help me?

Thanks