dbInfoRef

[william humphrey]

This to try:

SELECT
            SERVERPROPERTY('MachineName') AS [ServerName],
			SERVERPROPERTY('ServerName') AS [ServerInstanceName],
            SERVERPROPERTY('InstanceName') AS [Instance],
            SERVERPROPERTY('Edition') AS [Edition],
            SERVERPROPERTY('ProductVersion') AS [ProductVersion],
			Left(@@Version, Charindex('-', @@version) - 2) As VersionName


On Wed, Sep 23, 2015 at 3:02 PM, william humphrey <
bill at bluewatermaritime.com> wrote:

> is there a SQL command that will return the name of the database server
> host? I want to use just dbREF and not serverRef or dbInfoRef as I get
> crashes with those commands (I will work up a Manta report sometime later).
> It's really a shame that *DataBase_Path(dbRef does not actually return
> the path to the database and only returns the database name.*
>
> On Sat, Sep 19, 2015 at 3:40 AM, Ivan Smahin <
> ivan_smahin at paradigmasoft.com> wrote:
>
>> put VConnection_Constructor( "localhost", "sa", "sa") into mConn
>> ...
>> put VServer_New( mConn ) into serverRef
>> put 1 into dbIndex
>> put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef
>> ...
>>
>> On Sep 18, 2015, at 6:26 PM, william humphrey <bill at bluewatermaritime.com>
>> wrote:
>>
>> never mind. I got confused as to what version of Valentina is the most
>> recent.  So I'm still getting crashes. Instead of this old method
>>
>> It should be something like this one:
>>
>> put VServer_New( connectionRef ) into serverRef
>> put 1 into dbIndex
>> put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef
>>
>> I would like to use something like
>> *put* VConnection_Constructor(gDbServer2, "sa", "sa", 15432) into
>> serverRef
>> put 1 into dbIndex
>> put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef
>>
>> But this crashes LiveCode every time.
>>
>> On Fri, Sep 18, 2015 at 11:15 AM, william humphrey <
>> bill at bluewatermaritime.com> wrote:
>>
>>> Is  put VConnection_Constructor( "localhost", "sa", "sa") into mConn
>>> replaced by
>>>
>>> put VServer_New( "localhost", "sa", "sa" ) into srvRef
>>>
>>> I don't see any reference to any VConnection commands in
>>>
>>> VALENTINA 3 for Revolution Reference
>>>
>>> this is pretty important to know as I should change the way I connect to
>>> the valentina database server with this new method and maybe a lot of my
>>> problems will be solved.
>>>
>>>
>>>
>>> On Fri, Sep 18, 2015 at 2:45 AM, Ivan Smahin <
>>> ivan_smahin at paradigmasoft.com> wrote:
>>>
>>>> put 1 into dbIndex
>>>> put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef
>>>>
>>>
>>>
>>>
>>>
>>> --
>>> http://www.bluewatermaritime.com
>>>
>>
>>
>>
>> --
>> http://www.bluewatermaritime.com
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
>> --
>> Best regards,
>> Ivan Smahin
>> Senior Software Engineer
>> Paradigma Software, Inc
>> Valentina - The Ultra-Fast Database
>> http://www.valentina-db.com
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
>
>
> --
> http://www.bluewatermaritime.com
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20150923/94629f52/attachment-0001.html>