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.

Missing Driver

5 posts in General Discussion (old) Last posting was on 2009-11-06 23:01:06.0Z
Mike Marston Posted on 2009-11-05 21:58:21.0Z
From: "Mike Marston" <mikem@ksitech.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Missing Driver
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af34a7d$1@forums-1-dub>
Date: 5 Nov 2009 13:58:21 -0800
X-Trace: forums-1-dub 1257458301 10.22.241.152 (5 Nov 2009 13:58:21 -0800)
X-Original-Trace: 5 Nov 2009 13:58:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:315
Article PK: 841538

Hi All,
I've just installed SQL Anywhere 11.1 on Vista. I opened the ODBC
Adminstrator window to add a DSN. When I clicked ADD, there was no driver
listed for SQL Anywhere 11 so I could not add the DSN.
I checked the registry and the driver is there under the
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST key.

Any ideas?

TIA,
Mike


Chris Keating (Sybase iAnywhere) Posted on 2009-11-06 00:58:48.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Missing Driver
References: <4af34a7d$1@forums-1-dub>
In-Reply-To: <4af34a7d$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: <4af374c8@forums-1-dub>
Date: 5 Nov 2009 16:58:48 -0800
X-Trace: forums-1-dub 1257469128 10.22.241.152 (5 Nov 2009 16:58:48 -0800)
X-Original-Trace: 5 Nov 2009 16:58:48 -0800, vip152.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:316
Article PK: 841539

32 bit or 64 bit Vista? Did you install 32 bit or 64 bit SQL Anywhere?

-chris

Mike Marston wrote:
> Hi All,
> I've just installed SQL Anywhere 11.1 on Vista. I opened the ODBC
> Adminstrator window to add a DSN. When I clicked ADD, there was no driver
> listed for SQL Anywhere 11 so I could not add the DSN.
> I checked the registry and the driver is there under the
> HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST key.
>
> Any ideas?
>
> TIA,
> Mike
>
>


Mike Marston Posted on 2009-11-06 13:58:48.0Z
From: "Mike Marston" <mikem@ksitech.com>
Newsgroups: sybase.public.sqlanywhere
References: <4af34a7d$1@forums-1-dub> <4af374c8@forums-1-dub>
Subject: Re: Missing Driver
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af42b98@forums-1-dub>
Date: 6 Nov 2009 05:58:48 -0800
X-Trace: forums-1-dub 1257515928 10.22.241.152 (6 Nov 2009 05:58:48 -0800)
X-Original-Trace: 6 Nov 2009 05:58:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:317
Article PK: 866746

Chris,
Thanks for the quick response. I have 32 bit Vista. When I installed the SQL
11.1 for 32/64, I did not have a choice of 32 or 64 bit; it automatically
installed the 32 bit version.

"Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com> wrote in
message news:4af374c8@forums-1-dub...
> 32 bit or 64 bit Vista? Did you install 32 bit or 64 bit SQL Anywhere?
>
> -chris
>
>
> Mike Marston wrote:
>> Hi All,
>> I've just installed SQL Anywhere 11.1 on Vista. I opened the ODBC
>> Adminstrator window to add a DSN. When I clicked ADD, there was no driver
>> listed for SQL Anywhere 11 so I could not add the DSN.
>> I checked the registry and the driver is there under the
>> HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST key.
>>
>> Any ideas?
>>
>> TIA,
>> Mike


Chris Keating (Sybase iAnywhere) Posted on 2009-11-06 14:27:04.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Missing Driver
References: <4af34a7d$1@forums-1-dub> <4af374c8@forums-1-dub> <4af42b98@forums-1-dub>
In-Reply-To: <4af42b98@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: <4af43238$1@forums-1-dub>
Date: 6 Nov 2009 06:27:04 -0800
X-Trace: forums-1-dub 1257517624 10.22.241.152 (6 Nov 2009 06:27:04 -0800)
X-Original-Trace: 6 Nov 2009 06:27:04 -0800, vip152.sybase.com
Lines: 58
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:318
Article PK: 841540

Sorry, I meant to followup my post which was incomplete. I asked about
32 vs 64bit vista as the ODBC administrator is named the same on both
versions (included the executable). If you are running 32bit SA on a
64bit OS, you have to ensure that the administrator is also running as
32 bit.


When you stated it was in the HKLM\Software\ODBC\ODBCINST key, did you
get that there was an entry in

HKLM\Software\ODBC\ODBCINST\ODBC Drivers\

with the string value "SQL Anywhere 11"="Installed"?

as well as

HKLM\Software\ODBC\ODBCINST\SQL Anywhere 11

with values for "Driver" and "Setup" pointing the dbodbc11.dll?


If this all looks correct, I have seem problems in the registry that
could cause this issue. Generally, a corruption (or some other glich) in
an entry prior to the missing drivers would cause this. Export the key
HKLM\Software\ODBC\ODBCINST\ODBC Drivers\ and look for a driver that
does not look correct (i.e., I have seen '*' as an indicator).

HTH
-chris

Mike Marston wrote:
> Chris,
> Thanks for the quick response. I have 32 bit Vista. When I installed the SQL
> 11.1 for 32/64, I did not have a choice of 32 or 64 bit; it automatically
> installed the 32 bit version.
>
>
> "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com> wrote in
> message news:4af374c8@forums-1-dub...
>> 32 bit or 64 bit Vista? Did you install 32 bit or 64 bit SQL Anywhere?
>>
>> -chris
>>
>>
>> Mike Marston wrote:
>>> Hi All,
>>> I've just installed SQL Anywhere 11.1 on Vista. I opened the ODBC
>>> Adminstrator window to add a DSN. When I clicked ADD, there was no driver
>>> listed for SQL Anywhere 11 so I could not add the DSN.
>>> I checked the registry and the driver is there under the
>>> HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST key.
>>>
>>> Any ideas?
>>>
>>> TIA,
>>> Mike
>
>


Mike Marston Posted on 2009-11-06 23:01:06.0Z
From: "Mike Marston" <mikem@ksitech.com>
Newsgroups: sybase.public.sqlanywhere
References: <4af34a7d$1@forums-1-dub> <4af374c8@forums-1-dub> <4af42b98@forums-1-dub> <4af43238$1@forums-1-dub>
Subject: Re: Missing Driver
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af4aab2$1@forums-1-dub>
Date: 6 Nov 2009 15:01:06 -0800
X-Trace: forums-1-dub 1257548466 10.22.241.152 (6 Nov 2009 15:01:06 -0800)
X-Original-Trace: 6 Nov 2009 15:01:06 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:319
Article PK: 841541

Chris,
You got it exactly right. The registry had a corrupted entry (@=""). Once we
got rid of that the driver showed up on the ODBC Adminstrator list.

We do still have a small problem that may be related...
After createing the new DSN it does not show up on the System DSN tabpage.
It works just fine, but we can't see it and therefore can't edit it. If we
create a new one with the same name it asks if we want to replace the
existing one. Could this be more corruption? Any ideas?

Thanks
Mike

"Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com> wrote in
message news:4af43238$1@forums-1-dub...
> Sorry, I meant to followup my post which was incomplete. I asked about 32
> vs 64bit vista as the ODBC administrator is named the same on both
> versions (included the executable). If you are running 32bit SA on a 64bit
> OS, you have to ensure that the administrator is also running as 32 bit.
>
>
> When you stated it was in the HKLM\Software\ODBC\ODBCINST key, did you get
> that there was an entry in
>
> HKLM\Software\ODBC\ODBCINST\ODBC Drivers\
>
> with the string value "SQL Anywhere 11"="Installed"?
>
> as well as
>
> HKLM\Software\ODBC\ODBCINST\SQL Anywhere 11
>
> with values for "Driver" and "Setup" pointing the dbodbc11.dll?
>
>
> If this all looks correct, I have seem problems in the registry that could
> cause this issue. Generally, a corruption (or some other glich) in an
> entry prior to the missing drivers would cause this. Export the key
> HKLM\Software\ODBC\ODBCINST\ODBC Drivers\ and look for a driver that does
> not look correct (i.e., I have seen '*' as an indicator).
>
> HTH
> -chris
>
> Mike Marston wrote:
>> Chris,
>> Thanks for the quick response. I have 32 bit Vista. When I installed the
>> SQL 11.1 for 32/64, I did not have a choice of 32 or 64 bit; it
>> automatically installed the 32 bit version.
>>
>>
>> "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com> wrote in
>> message news:4af374c8@forums-1-dub...
>>> 32 bit or 64 bit Vista? Did you install 32 bit or 64 bit SQL Anywhere?
>>>
>>> -chris
>>>
>>>
>>> Mike Marston wrote:
>>>> Hi All,
>>>> I've just installed SQL Anywhere 11.1 on Vista. I opened the ODBC
>>>> Adminstrator window to add a DSN. When I clicked ADD, there was no
>>>> driver listed for SQL Anywhere 11 so I could not add the DSN.
>>>> I checked the registry and the driver is there under the
>>>> HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST key.
>>>>
>>>> Any ideas?
>>>>
>>>> TIA,
>>>> Mike
>>