SQL Server Performance Forum – Threads Archive
Connect SQL2005 with VC++6.0 client
I want to feed C++6.0-project data into SQL server and hoped that StudioExpress would show the correct connection string in detail. But I made the experience that StudioExpress didnot succeed in connecting to a SQL server Express configured for SQL Authentication. I made sreenshots of the details and put them in subfolders of my homepagehttp://home.arcor.de/sql2005/. Does anybody know what exact connection string has to be used and which changes in StudioExpress AdvancedConnectionProperties are necessary to establich a working connection?
May checkhttp://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx for more information. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
@Satya thank you very much for your advice. In the meantime I found that at least the following OLEDB-ConnectionString is working, when Im logged in as admin and can use Windows Autentication: Provider=’sqloledb’
Data Source=’.’ – without ‘/SQLEXPRESS’ !!
Initial Catalog=’MyDatabaseName’
Integrated Security=’SSPI’ For details of SQL setup and code to test possible connetion strings
please see my homepagehttp://home.arcor.de/SQL2005/. Martin
Also
www.ConnectionStrings.com Madhivanan Failing to plan is Planning to fail
Thanks
Madhivanan for your link to ConnectionStrings. Another good source: www.carlprothman.net. But sometimes even such exellent links dont solve your problem. The new generation of Microsofts server software adresses new people, not only the professional with years of education but also people who just jump in – the taxidriver, the lawyer interested in simple applications, as a Microsoft article stated lately. Such people can easily be lost with connection problems, since there are thousands of different setup possibilities, thousands of possible reasons of failure and it can take hundreds of hours to find ‘your’ reason, even of you are a professional. So to my opinion, if you dont succeed immediately, its better the other way round. Dont search for the magic bug in your code, but take a simple, but running solution and try to destroy this solution by changing the code into your target direction. When the simple solution stopps running you probalby found ‘your’ bug and the problem is solved in 1-2 hours. For this reason I wrote a simple solution (connect.cpphttp://home.arcor.de/sql2005/download/) without any functionality but showing error messages. Maybe this code might be helpful. Martin For more links, comment and code dealing with SQL2005 Express Server see my homepagehttp://home.arcor.de/sql2005/
Martin
Your reference also helps a lot and I agree sometimes good links doesn’t give much solution, but helps a lot to revise the procedure what has been followed so far. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>