C SIDE SQL automatic connection - startup parameters problem

anvar

Hello,

I've read in the w1w1isql.pdf the startup parameters, but I can't get them to work.
My shortcut is as following, in the target field:

""C:\Program Files (x86)\Microsoft Dynamics NAV\CSIDE Client\" servername=sqlcluster1, database=database_name, ntauthentication=yes

Can someone help me out with this?
I want to create 2 icons, with 2 different databases in case of a mirror failover

kriki

Try this:

"C:\Program Files (x86)\Microsoft Dynamics NAV\CSIDE Client\finsql.exe" servername=sqlcluster1, database=database_name, ntauthentication=yes

You forgot the "finsql.exe".
BTW: better use ntauthentication=1. Avoid Yes/no to avoid multilanguage problems.

anvar

thanks for the reply, same problem with your string.
(Changed the databasename )
Must there be a space between the " and the first parameter?
Must there be a . at the last?

kriki

Yes, you must give a blank between " and first parameter.
No . must be put.

Here is an example:

C:\NAV\NAV2009SP1W11129227\finsql.exe NTAUTHENTICATION=0, NETTYPE=TCP, servername=192.168.214.5, database="Somedatabase", COMPANY="Some Company", ID="C:\DB\CC\ZUP\SomeZupFile.zup"

The ID serves to use a certain zup file.