Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbisql.com Ultralite read in file

7 posts in Ultralite Last posting was on 2011-03-18 18:34:21.0Z
Shao Chan Posted on 2011-03-18 15:18:31.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: dbisql.com Ultralite read in file
Lines: 19
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d8377c7@forums-1-dub>
Date: 18 Mar 2011 07:18:31 -0800
X-Trace: forums-1-dub 1300461511 10.22.241.152 (18 Mar 2011 07:18:31 -0800)
X-Original-Trace: 18 Mar 2011 07:18:31 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12414
Article PK: 1048146

Hi all,

Is there any reason why this does not work?

"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
read
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
It works in 11.0.1. but not in 12.0.1.

Has the syntax changed for 12.0.1?

Thanks,

Shao


Chris Keating (Sybase, an SAP Company) Posted on 2011-03-18 15:30:07.0Z
From: "Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: dbisql.com Ultralite read in file
References: <4d8377c7@forums-1-dub>
In-Reply-To: <4d8377c7@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d837a7f$1@forums-1-dub>
Date: 18 Mar 2011 07:30:07 -0800
X-Trace: forums-1-dub 1300462207 10.22.241.152 (18 Mar 2011 07:30:07 -0800)
X-Original-Trace: 18 Mar 2011 07:30:07 -0800, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12415
Article PK: 1048148

Can you expand on what you mean by 'not work'? Do you get errors or does
the SQL not execute?

This works in my testing of the command when referencing c:\udb\test.udb
and c:\udb\test.sql files and when just referencing the file name
without the path.

On 3/18/2011 11:18 AM, Shao Chan wrote:
> Hi all,
>
> Is there any reason why this does not work?
>
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
> read
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
> It works in 11.0.1. but not in 12.0.1.
>
> Has the syntax changed for 12.0.1?
>
> Thanks,
>
> Shao
>
>
>
>


Shao Chan Posted on 2011-03-18 17:40:04.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d8377c7@forums-1-dub> <4d837a7f$1@forums-1-dub>
Subject: Re: dbisql.com Ultralite read in file
Lines: 68
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d8398f4$1@forums-1-dub>
Date: 18 Mar 2011 09:40:04 -0800
X-Trace: forums-1-dub 1300470004 10.22.241.152 (18 Mar 2011 09:40:04 -0800)
X-Original-Trace: 18 Mar 2011 09:40:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12417
Article PK: 1048145

Hi Chris,

Sorry about that. Had a rubbish internet connection earlier - made it
torturous to use the newsgroups.

I get this:

D:\environments\development\mobileServitor\Remote\bin>"D:\Program Files\SQL
Anyw
here 12\BIN64\DBISQL.COM" -ul -c
"DBF=D:\environments\development\mobileServitor
\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
"D:\environments
\development\mobileServitor\Remote\db\mobileServitor.sql"

Could not connect to the database.
Data source name not found and no default driver specified
SQLCODE=0, ODBC 3 State="IM002"

Could not connect to the database.
Data source name not found and no default driver specified
SQLCODE=0, ODBC 3 State="IM002"

You are not connected to a database.
D:\environments\development\mobileServitor\Remote\bin>

Now, I am not sure where I am going wrong. The code is the same as 11.0.1.
although the creation of the database now uses ulinit rather than ulcreate.

Thanks,

Shao

"Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com> wrote in
message news:4d837a7f$1@forums-1-dub...
> Can you expand on what you mean by 'not work'? Do you get errors or does
> the SQL not execute?
>
> This works in my testing of the command when referencing c:\udb\test.udb
> and c:\udb\test.sql files and when just referencing the file name without
> the path.
>
>
> On 3/18/2011 11:18 AM, Shao Chan wrote:
>> Hi all,
>>
>> Is there any reason why this does not work?
>>
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>> read
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>> It works in 11.0.1. but not in 12.0.1.
>>
>> Has the syntax changed for 12.0.1?
>>
>> Thanks,
>>
>> Shao
>>
>>
>>
>>
>


Chris Keating (Sybase, an SAP Company) Posted on 2011-03-18 17:58:39.0Z
From: "Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: dbisql.com Ultralite read in file
References: <4d8377c7@forums-1-dub> <4d837a7f$1@forums-1-dub> <4d8398f4$1@forums-1-dub>
In-Reply-To: <4d8398f4$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d839d4f$1@forums-1-dub>
Date: 18 Mar 2011 09:58:39 -0800
X-Trace: forums-1-dub 1300471119 10.22.241.152 (18 Mar 2011 09:58:39 -0800)
X-Original-Trace: 18 Mar 2011 09:58:39 -0800, vip152.sybase.com
Lines: 85
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12418
Article PK: 1048144

The error " Data source name not found and no default driver specified"
means that the ODBC driver is missing or not installed correctly. Since
the DBISQL is running from the bin64, the ODBC driver must be 64 bit also.

Can you verify that the file ulodbc12.dll is found in the directory
D:\Program Files\SQL Anywhere 12\BIN64

and if so, execute regsvr32 against that file. This will install the
driver into the ODBC environment on your system.

Once that succeeds, retry your dbisql invocation to see if the problem
is resolved.

-chris

On 3/18/2011 1:40 PM, Shao Chan wrote:
> Hi Chris,
>
> Sorry about that. Had a rubbish internet connection earlier - made it
> torturous to use the newsgroups.
>
> I get this:
>
> D:\environments\development\mobileServitor\Remote\bin>"D:\Program Files\SQL
> Anyw
> here 12\BIN64\DBISQL.COM" -ul -c
> "DBF=D:\environments\development\mobileServitor
> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
> "D:\environments
> \development\mobileServitor\Remote\db\mobileServitor.sql"
>
> Could not connect to the database.
> Data source name not found and no default driver specified
> SQLCODE=0, ODBC 3 State="IM002"
>
> Could not connect to the database.
> Data source name not found and no default driver specified
> SQLCODE=0, ODBC 3 State="IM002"
>
> You are not connected to a database.
> D:\environments\development\mobileServitor\Remote\bin>
>
> Now, I am not sure where I am going wrong. The code is the same as 11.0.1.
> although the creation of the database now uses ulinit rather than ulcreate.
>
> Thanks,
>
> Shao
>
>
>
> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote in
> message news:4d837a7f$1@forums-1-dub...
>> Can you expand on what you mean by 'not work'? Do you get errors or does
>> the SQL not execute?
>>
>> This works in my testing of the command when referencing c:\udb\test.udb
>> and c:\udb\test.sql files and when just referencing the file name without
>> the path.
>>
>>
>> On 3/18/2011 11:18 AM, Shao Chan wrote:
>>> Hi all,
>>>
>>> Is there any reason why this does not work?
>>>
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>> read
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>> It works in 11.0.1. but not in 12.0.1.
>>>
>>> Has the syntax changed for 12.0.1?
>>>
>>> Thanks,
>>>
>>> Shao
>>>
>>>
>>>
>>>
>>
>
>


Shao Chan Posted on 2011-03-18 18:12:31.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d8377c7@forums-1-dub> <4d837a7f$1@forums-1-dub> <4d8398f4$1@forums-1-dub> <4d839d4f$1@forums-1-dub>
Subject: Re: dbisql.com Ultralite read in file
Lines: 139
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d83a08f@forums-1-dub>
Date: 18 Mar 2011 10:12:31 -0800
X-Trace: forums-1-dub 1300471951 10.22.241.152 (18 Mar 2011 10:12:31 -0800)
X-Original-Trace: 18 Mar 2011 10:12:31 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12419
Article PK: 1048159

Hi Chris,

Thanks for that. It works now. I get a different error message (listed
below - this is consistent with the error message that I get with the XML
load - I'll post in another thread).

Regarding the ODBC, is this normal - that I have to register the
ulodbc12.dll from the BINxx directory of whichever version I will be using?

Or is it a bug or is my installation simply went wrong silently?

Basically, I need to know whether I should be adding a regsvr32 to my
installation scripts.

Thanks,

Shao




D:\environments\development\mobileServitor\Remote\bin>"D:\Program
Files\SQL Anyw
here 12\BIN64\DBISQL.COM" -ul -c
"DBF=D:\environments\development\mobileServitor
\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
"D:\environments
\development\mobileServitor\Remote\db\mobileServitor.sql"
Could not execute statement.
[UltraLite Database] Foreign key 'primary' for table 'contractItem'
duplicates an existing foreign key [SQL Offset: 142]
SQLCODE=-251, ODBC 3 State="ERROR"
File: "mobileServitor.sql" on line 1028, column 1
-- Done publications
-------------------
-- Create indexes
-------------------
...
You can continue executing or stop.
1. Stop
2. Continue
Select an option:

"Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com> wrote in
message news:4d839d4f$1@forums-1-dub...
> The error " Data source name not found and no default driver specified"
> means that the ODBC driver is missing or not installed correctly. Since
> the DBISQL is running from the bin64, the ODBC driver must be 64 bit also.
>
> Can you verify that the file ulodbc12.dll is found in the directory
> D:\Program Files\SQL Anywhere 12\BIN64
>
> and if so, execute regsvr32 against that file. This will install the
> driver into the ODBC environment on your system.
>
> Once that succeeds, retry your dbisql invocation to see if the problem is
> resolved.
>
> -chris
>
> On 3/18/2011 1:40 PM, Shao Chan wrote:
>> Hi Chris,
>>
>> Sorry about that. Had a rubbish internet connection earlier - made it
>> torturous to use the newsgroups.
>>
>> I get this:
>>
>> D:\environments\development\mobileServitor\Remote\bin>"D:\Program
>> Files\SQL
>> Anyw
>> here 12\BIN64\DBISQL.COM" -ul -c
>> "DBF=D:\environments\development\mobileServitor
>> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
>> "D:\environments
>> \development\mobileServitor\Remote\db\mobileServitor.sql"
>>
>> Could not connect to the database.
>> Data source name not found and no default driver specified
>> SQLCODE=0, ODBC 3 State="IM002"
>>
>> Could not connect to the database.
>> Data source name not found and no default driver specified
>> SQLCODE=0, ODBC 3 State="IM002"
>>
>> You are not connected to a database.
>> D:\environments\development\mobileServitor\Remote\bin>
>>
>> Now, I am not sure where I am going wrong. The code is the same as
>> 11.0.1.
>> although the creation of the database now uses ulinit rather than
>> ulcreate.
>>
>> Thanks,
>>
>> Shao
>>
>>
>>
>> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote in
>> message news:4d837a7f$1@forums-1-dub...
>>> Can you expand on what you mean by 'not work'? Do you get errors or does
>>> the SQL not execute?
>>>
>>> This works in my testing of the command when referencing c:\udb\test.udb
>>> and c:\udb\test.sql files and when just referencing the file name
>>> without
>>> the path.
>>>
>>>
>>> On 3/18/2011 11:18 AM, Shao Chan wrote:
>>>> Hi all,
>>>>
>>>> Is there any reason why this does not work?
>>>>
>>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>>> read
>>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>>> It works in 11.0.1. but not in 12.0.1.
>>>>
>>>> Has the syntax changed for 12.0.1?
>>>>
>>>> Thanks,
>>>>
>>>> Shao
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>


Chris Keating (Sybase, an SAP Company) Posted on 2011-03-18 18:27:23.0Z
From: "Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: dbisql.com Ultralite read in file
References: <4d8377c7@forums-1-dub> <4d837a7f$1@forums-1-dub> <4d8398f4$1@forums-1-dub> <4d839d4f$1@forums-1-dub> <4d83a08f@forums-1-dub>
In-Reply-To: <4d83a08f@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d83a40b@forums-1-dub>
Date: 18 Mar 2011 10:27:23 -0800
X-Trace: forums-1-dub 1300472843 10.22.241.152 (18 Mar 2011 10:27:23 -0800)
X-Original-Trace: 18 Mar 2011 10:27:23 -0800, vip152.sybase.com
Lines: 151
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12420
Article PK: 1048158

The ODBC driver should install correctly. There must have been a problem
during the install that was not reported.

If you are manually deploying, you should use regsvr32 to register the
driver - or manually create the registry entries. If you are using the
SA installer (or install tools), this should be handled.

On 3/18/2011 2:12 PM, Shao Chan wrote:
> Hi Chris,
>
> Thanks for that. It works now. I get a different error message (listed
> below - this is consistent with the error message that I get with the XML
> load - I'll post in another thread).
>
> Regarding the ODBC, is this normal - that I have to register the
> ulodbc12.dll from the BINxx directory of whichever version I will be using?
>
> Or is it a bug or is my installation simply went wrong silently?
>
> Basically, I need to know whether I should be adding a regsvr32 to my
> installation scripts.
>
> Thanks,
>
> Shao
>
>
>
>
> D:\environments\development\mobileServitor\Remote\bin>"D:\Program
> Files\SQL Anyw
> here 12\BIN64\DBISQL.COM" -ul -c
> "DBF=D:\environments\development\mobileServitor
> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
> "D:\environments
> \development\mobileServitor\Remote\db\mobileServitor.sql"
> Could not execute statement.
> [UltraLite Database] Foreign key 'primary' for table 'contractItem'
> duplicates an existing foreign key [SQL Offset: 142]
> SQLCODE=-251, ODBC 3 State="ERROR"
> File: "mobileServitor.sql" on line 1028, column 1
> -- Done publications
> -------------------
> -- Create indexes
> -------------------
> ...
> You can continue executing or stop.
> 1. Stop
> 2. Continue
> Select an option:
>
>
>
>
> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote in
> message news:4d839d4f$1@forums-1-dub...
>> The error " Data source name not found and no default driver specified"
>> means that the ODBC driver is missing or not installed correctly. Since
>> the DBISQL is running from the bin64, the ODBC driver must be 64 bit also.
>>
>> Can you verify that the file ulodbc12.dll is found in the directory
>> D:\Program Files\SQL Anywhere 12\BIN64
>>
>> and if so, execute regsvr32 against that file. This will install the
>> driver into the ODBC environment on your system.
>>
>> Once that succeeds, retry your dbisql invocation to see if the problem is
>> resolved.
>>
>> -chris
>>
>> On 3/18/2011 1:40 PM, Shao Chan wrote:
>>> Hi Chris,
>>>
>>> Sorry about that. Had a rubbish internet connection earlier - made it
>>> torturous to use the newsgroups.
>>>
>>> I get this:
>>>
>>> D:\environments\development\mobileServitor\Remote\bin>"D:\Program
>>> Files\SQL
>>> Anyw
>>> here 12\BIN64\DBISQL.COM" -ul -c
>>> "DBF=D:\environments\development\mobileServitor
>>> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
>>> "D:\environments
>>> \development\mobileServitor\Remote\db\mobileServitor.sql"
>>>
>>> Could not connect to the database.
>>> Data source name not found and no default driver specified
>>> SQLCODE=0, ODBC 3 State="IM002"
>>>
>>> Could not connect to the database.
>>> Data source name not found and no default driver specified
>>> SQLCODE=0, ODBC 3 State="IM002"
>>>
>>> You are not connected to a database.
>>> D:\environments\development\mobileServitor\Remote\bin>
>>>
>>> Now, I am not sure where I am going wrong. The code is the same as
>>> 11.0.1.
>>> although the creation of the database now uses ulinit rather than
>>> ulcreate.
>>>
>>> Thanks,
>>>
>>> Shao
>>>
>>>
>>>
>>> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote in
>>> message news:4d837a7f$1@forums-1-dub...
>>>> Can you expand on what you mean by 'not work'? Do you get errors or does
>>>> the SQL not execute?
>>>>
>>>> This works in my testing of the command when referencing c:\udb\test.udb
>>>> and c:\udb\test.sql files and when just referencing the file name
>>>> without
>>>> the path.
>>>>
>>>>
>>>> On 3/18/2011 11:18 AM, Shao Chan wrote:
>>>>> Hi all,
>>>>>
>>>>> Is there any reason why this does not work?
>>>>>
>>>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>>>> read
>>>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>>>> It works in 11.0.1. but not in 12.0.1.
>>>>>
>>>>> Has the syntax changed for 12.0.1?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Shao
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>


Shao Chan Posted on 2011-03-18 18:34:21.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d8377c7@forums-1-dub> <4d837a7f$1@forums-1-dub> <4d8398f4$1@forums-1-dub> <4d839d4f$1@forums-1-dub> <4d83a08f@forums-1-dub> <4d83a40b@forums-1-dub>
Subject: Re: dbisql.com Ultralite read in file
Lines: 172
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d83a5ad$1@forums-1-dub>
Date: 18 Mar 2011 10:34:21 -0800
X-Trace: forums-1-dub 1300473261 10.22.241.152 (18 Mar 2011 10:34:21 -0800)
X-Original-Trace: 18 Mar 2011 10:34:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12422
Article PK: 1048197

Thanks Chris,

We manually deploy our part of the application, but the SQL Anywhere
installation is straight from the SQL Anywhere installer.

We'll run the installer on another machine to double-check this.

Thanks,

Shao

"Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com> wrote in
message news:4d83a40b@forums-1-dub...
>
> The ODBC driver should install correctly. There must have been a problem
> during the install that was not reported.
>
> If you are manually deploying, you should use regsvr32 to register the
> driver - or manually create the registry entries. If you are using the SA
> installer (or install tools), this should be handled.
>
>
>
> On 3/18/2011 2:12 PM, Shao Chan wrote:
>> Hi Chris,
>>
>> Thanks for that. It works now. I get a different error message (listed
>> below - this is consistent with the error message that I get with the XML
>> load - I'll post in another thread).
>>
>> Regarding the ODBC, is this normal - that I have to register the
>> ulodbc12.dll from the BINxx directory of whichever version I will be
>> using?
>>
>> Or is it a bug or is my installation simply went wrong silently?
>>
>> Basically, I need to know whether I should be adding a regsvr32 to my
>> installation scripts.
>>
>> Thanks,
>>
>> Shao
>>
>>
>>
>>
>> D:\environments\development\mobileServitor\Remote\bin>"D:\Program
>> Files\SQL Anyw
>> here 12\BIN64\DBISQL.COM" -ul -c
>> "DBF=D:\environments\development\mobileServitor
>> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
>> "D:\environments
>> \development\mobileServitor\Remote\db\mobileServitor.sql"
>> Could not execute statement.
>> [UltraLite Database] Foreign key 'primary' for table 'contractItem'
>> duplicates an existing foreign key [SQL Offset: 142]
>> SQLCODE=-251, ODBC 3 State="ERROR"
>> File: "mobileServitor.sql" on line 1028, column 1
>> -- Done publications
>> -------------------
>> -- Create indexes
>> -------------------
>> ...
>> You can continue executing or stop.
>> 1. Stop
>> 2. Continue
>> Select an option:
>>
>>
>>
>>
>> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote in
>> message news:4d839d4f$1@forums-1-dub...
>>> The error " Data source name not found and no default driver specified"
>>> means that the ODBC driver is missing or not installed correctly. Since
>>> the DBISQL is running from the bin64, the ODBC driver must be 64 bit
>>> also.
>>>
>>> Can you verify that the file ulodbc12.dll is found in the directory
>>> D:\Program Files\SQL Anywhere 12\BIN64
>>>
>>> and if so, execute regsvr32 against that file. This will install the
>>> driver into the ODBC environment on your system.
>>>
>>> Once that succeeds, retry your dbisql invocation to see if the problem
>>> is
>>> resolved.
>>>
>>> -chris
>>>
>>> On 3/18/2011 1:40 PM, Shao Chan wrote:
>>>> Hi Chris,
>>>>
>>>> Sorry about that. Had a rubbish internet connection earlier - made it
>>>> torturous to use the newsgroups.
>>>>
>>>> I get this:
>>>>
>>>> D:\environments\development\mobileServitor\Remote\bin>"D:\Program
>>>> Files\SQL
>>>> Anyw
>>>> here 12\BIN64\DBISQL.COM" -ul -c
>>>> "DBF=D:\environments\development\mobileServitor
>>>> \Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql" read
>>>> "D:\environments
>>>> \development\mobileServitor\Remote\db\mobileServitor.sql"
>>>>
>>>> Could not connect to the database.
>>>> Data source name not found and no default driver specified
>>>> SQLCODE=0, ODBC 3 State="IM002"
>>>>
>>>> Could not connect to the database.
>>>> Data source name not found and no default driver specified
>>>> SQLCODE=0, ODBC 3 State="IM002"
>>>>
>>>> You are not connected to a database.
>>>> D:\environments\development\mobileServitor\Remote\bin>
>>>>
>>>> Now, I am not sure where I am going wrong. The code is the same as
>>>> 11.0.1.
>>>> although the creation of the database now uses ulinit rather than
>>>> ulcreate.
>>>>
>>>> Thanks,
>>>>
>>>> Shao
>>>>
>>>>
>>>>
>>>> "Chris Keating (Sybase, an SAP Company)"<last_name@sybase.com> wrote
>>>> in
>>>> message news:4d837a7f$1@forums-1-dub...
>>>>> Can you expand on what you mean by 'not work'? Do you get errors or
>>>>> does
>>>>> the SQL not execute?
>>>>>
>>>>> This works in my testing of the command when referencing
>>>>> c:\udb\test.udb
>>>>> and c:\udb\test.sql files and when just referencing the file name
>>>>> without
>>>>> the path.
>>>>>
>>>>>
>>>>> On 3/18/2011 11:18 AM, Shao Chan wrote:
>>>>>> Hi all,
>>>>>>
>>>>>> Is there any reason why this does not work?
>>>>>>
>>>>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>>>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>>>>> read
>>>>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>>>>> It works in 11.0.1. but not in 12.0.1.
>>>>>>
>>>>>> Has the syntax changed for 12.0.1?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Shao
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>