Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




SQL Server Connection string

web-app

I have looked at other posts and none of them answer the problem I am having with the software.

I keep getting unable to connect to SQL Server when I run the web interface.

The database resides on a server named bill and the database is called Gemini_test, the user id is gemini and the password is gemini. This is a trusted connection. The application resides on a different server in a virtual directory named GeminiTest. On the application server I created and ODBC datasource called gemini that connects to the SQL Server with no problem.

What would the connection string look like using the above information?

Thanks
daveserv
· 1 		daveserv
Wednesday, August 9, 2006, 9:25:21 PM
Replies (3)
helpful
0
not helpful

This is not possible at the moment.

You can not use ODBC data sources. Is your connection uses sql authentication?
Mark Wing
· 9108 		Mark Wing
Thursday, August 10, 2006, 11:03:15 AM
helpful
0
not helpful

Yes is does use SQL authentication.

Not using ODBC is fine with me and I will use and means to get the application to talk to the sql server.

The server is bill and the database is Gemini_test. The ID is gemini and the password is gemini. How would I setup the connection string?

 

Thanks
daveserv
· 1 		daveserv
Thursday, August 10, 2006, 2:53:01 PM
helpful
0
not helpful

data source=bill;initial catalog=Gemini_test;user id=gemini;password=gemini
Mark Wing
· 9108 		Mark Wing
Thursday, August 10, 2006, 3:00:07 PM