Can't access SQL Server with Qdesign

[Jeff Hoffman]

Blue

My appologies, now that I look at it, you are correct, I was also trying to
connect to a SYBASE db at the same time, that was case sentitive.

For what it is worth the folloing is the environment varaibles and PDL that
we used on Windows to access a Ms sql db.

set VPBASE=DBNAME
set VPUSER=YESIHAVEANAME
set VPPASS=NOCANTREMBERIT

then

database VMONEY type odbc open "$VPBASE" &
                userid "$VPUSER" password "$VPPASS" &
                null values NOT allowed 


Jeff


At 10:11 PM 09-11-04 -0600, you wrote:
>Thanks Jeff
>
>To my knowledge and in my experience SQLServer is case insensitive unless
>explicitly set so.  I my case it is not.
>
>Blue
>
>> -----Original Message-----
>> From: powerh-l-admin@lists.sowder.com
>> [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Jeff Hoffman
>> Sent: Tuesday, November 09, 2004 3:56 PM
>> To: powerh-l@lists.sowder.com
>> Subject: Re: Can't access SQL Server with Qdesign
>>
>>
>> Hi
>>
>> Could it have something to do with case, as table & field names are case
>> sensitive? There is a setting on the DB specification and in the
>> dictionary.
>>
>> Jeff
>>
>> At 08:03 AM 09-11-04 -0800, you wrote:
>> >G'day all
>> >
>> >Env: PH 8.4D1, Win2K, SQL Server 8.
>> >
>> >I can't read the same SQL Server database in Quiz,
>> >Qdesign, etc as I can in Axiant.  The dictionary was
>> >created by Axiant.
>> >
>> >Is this because I'm missing something from the
>> >license?
>> >
>> >This is the contents of the license file:
>> >
>> >SERVER myserver ANY  1701
>> >DAEMON cognos1d C:\PROGRA~1\Cognos\POWERH~1
>> >FEATURE PH8-TEMPORARY cognos1d 1.000 31-DEC-2004 0
>> >CZOGOCODFE "0057190090 COGNOS INC. NI DEMO" DEMO
>> >FEATURE PHWEB-TEMPORARY cognos1d 1.000 31-DEC-2004 0
>> >ZWDREVOWKB "0057190090 COGNOS INC. NI DEMO" DEMO
>> >
>> >Any ideas?
>> >
>> >Blue
>> >
>> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>> >Mailing list: powerh-l@lists.sowder.com
>> >Subscribe: "subscribe" in message body to
>> powerh-l-request@lists.sowder.com
>> >Unsubscribe: "unsubscribe <password>" in message body to
>> powerh-l-request@lists.sowder.com
>> >http://lists.sowder.com/mailman/listinfo/powerh-l
>> >This list is closed, thus to post to the list you must be a subscriber.
>> >
>> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
>> +-+-+-+-+-+
>> + Jeff Hoffman                          + e-mail:
>> wonicon@optushome.com.au  +
>> + Director                              +
>>           +
>> + WoniCon Pty Ltd   (ABN 93 083 502 630)+
>>  ,-_|\    +
>> + 21 Prices Circuit                     + voice: +61 2 9542 1527
>> /     \   +
>> + Woronora    NSW     2232              + fax:   +61 2 9576 7029
>> \_,-._*   +
>> + AUSTRALIA                             + mobile: 040 790 3929
>>      v    +
>> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
>> +-+-+-+-+-
>> +
>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>> Mailing list: powerh-l@lists.sowder.com
>> Subscribe: "subscribe" in message body to
>> powerh-l-request@lists.sowder.com
>> Unsubscribe: "unsubscribe <password>" in message body to
>> powerh-l-request@lists.sowder.com
>> http://lists.sowder.com/mailman/listinfo/powerh-l
>> This list is closed, thus to post to the list you must be a subscriber.
>>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>