April 7, 2015 at 7:21 am
Dear all
I've been trying to solve this weird issue but without success. Have searched the forums about this issue and even after applying and checking recommended settings I am still without a solution. Here is a description of my issue.
We have a database residing on a SQL Server 2012 Express system running under Windows Server 2012. I have installed the SQL 2012 Native Client on the user's workstation. I created the System DSN with the required settings and when I test the connection all tests pass. I am able to ping the server as well as connect to it via SQL Server Management Studio.
Now when the user launches the application he is presented with the dialog window as in Screenshot1 (see attached). After clicking on Ok he is next presented with the dialog window where he has to select the SQL server. See attached Screenshot2. The user selects the SQL server from the drop down list and he is then able to access the application and work normally. I cannot understand why this is happening because I have included the correct server instance in the DSN settings i.e. sqlserver\sqlexpress
Telling the user to select the server himself is not an option for us.
I have checked the settings on the SQL Server. TCP/IP is enabled, remote connections are allowed and there is no firewall blocking. Port 1433 has been set as the default port to use.
I would appreciate your help/comments on this as I am truly stuck 🙁
TIA
Pierre
April 7, 2015 at 7:54 am
Why are you using a system DSN to connect here? Why not just make a direct connection and skip the system DSN.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 7, 2015 at 8:06 am
Thanks for replying. When I remove the System DSN and try to launch the application I still get the same error message.
When you say connect directly, how can this be done?
Thx
April 7, 2015 at 8:16 am
pmcamilleri (4/7/2015)
Thanks for replying. When I remove the System DSN and try to launch the application I still get the same error message.When you say connect directly, how can this be done?
Thx
I don't have any clue what language your application is written but they all have a way to establish a connection to sql server. System DSN is a very old type of technology that fell out of favor about 10 years ago or more.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 7, 2015 at 8:19 am
This application was written in Visual Dataflex 17.1 and we installed their SQL Connectivity Kit on the user's workstation in order for him to be able to connect to the database which is being on SQL Server 2012 Express.
April 7, 2015 at 8:23 am
pmcamilleri (4/7/2015)
This application was written in Visual Dataflex 17.1 and we installed their SQL Connectivity Kit on the user's workstation in order for him to be able to connect to the database which is being on SQL Server 2012 Express.
I have never heard of Visual Dataflex but surely there are data objects in that language? Something so you can establish a connection to sql server.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 7, 2015 at 8:24 am
Why would an application use your system DSN?
Maybe there is an app config or app registry setting.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply