Re: No datasources shown, despite System DSNs existing

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on July 17 2007 20:48:37:

In Reply to: No datasources shown, despite System DSNs existing posted by Jonathon on January 19 2007 20:07:50:

Jonathon,

First be sure you have added a SYSTEM DSN and not a USER DSN, you have to choose the good tab in ODBC Manager dialog.

If SQL Script Builder do not list the available data source name (DSN) you want, it is possibly because it cannot access system registry most of the time for security reasons. Ask your system administrator about your registry access rights.

Also you need to be sure that MDAC version 2.1 or later is installed on the system where you plan to run the application. MDAC is automatically installed with software such as Windows and Internet Explorer version 5 or later. It is recomended to have the latest MDAC version installed, an update is available from Microsoft web site.

> I installed SQL Script Builder. v.1.5.0.6. Windows 2000 SP4 is OS I am using.
>
> I see several "Pervasive ODBC Engine Interface" data sources in my "System DSN". I also have 1 "Maximizer ODBC Driver".
>
> SQL Script Builder does not show any databases in the left-hand column of the screen. The error message is "No available sources found".
>
> But, within the ODBC Data Source Administrator, I did successfully connect to all databases.
>
> Any ideas?
>
> Thanks in advance!
>
> Jonathon

Follow Ups:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Jonathon, > > First be sure you have added a SYSTEM DSN and not a USER DSN, you have to choose the good tab in ODBC Manager dialog. > > If SQL Script Builder do not list the available data source name (DSN) you want, it is possibly because it cannot access system registry most of the time for security reasons. Ask your system administrator about your registry access rights. > > Also you need to be sure that MDAC version 2.1 or later is installed on the system where you plan to run the application. MDAC is automatically installed with software such as Windows and Internet Explorer version 5 or later. It is recomended to have the latest MDAC version installed, an <a href="http://go.microsoft.com/fwlink/?LinkId=50233">update</a> is available from Microsoft web site. > > > I installed SQL Script Builder. v.1.5.0.6. Windows 2000 SP4 is OS I am using. > > > > I see several "Pervasive ODBC Engine Interface" data sources in my "System DSN". I also have 1 "Maximizer ODBC Driver". > > > > SQL Script Builder does not show any databases in the left-hand column of the screen. The error message is "No available sources found". > > > > But, within the ODBC Data Source Administrator, I did successfully connect to all databases. > > > > Any ideas? > > > > Thanks in advance! > > > > Jonathon >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]