Re: No datasources shown, despite System DSNs existing - New version 1.5.0.7 released

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

Posted by Dave on January 22 2007 22:46:27:

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

Jonathon,

Note : The possibility to add sources names directly to the left panel have been removed since version 1.6.0.14 for security reasons. If you think this option should be re-enabled because you have valid sources that do not get listed in the left panel, post a message here or contact us.

You can also see this post for more info.

It appears that most of the time when SQL Script Builder cannot list the sources it is because for some reasons it can't access the system registry. So with version 1.5.0.7, I added the possibility to add sources names directly to the TreeView (left panel) so you can create the script for the tables if you know how your data source name (DSN) is spelled.

To do so go into Connection -> Add Source and type the name of your DSN and click on Add Source, the name will be added to the TreeView (left panel). Now you can normally get the script for the table you want.

I hope this will help.
Dave

> 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, > > <font color="#FF0000">Note : The possibility to add sources names directly to the left panel have been removed since version 1.6.0.14 for security reasons. If you think this option should be re-enabled because you have valid sources that do not get listed in the left panel, post a message here or contact us.</font> > > You can also see <a href="50.php">this post</a> for more info. > > It appears that most of the time when SQL Script Builder cannot list the sources it is because for some reasons it can't access the system registry. So with version 1.5.0.7, I added the possibility to add sources names directly to the TreeView (left panel) so you can create the script for the tables if you know how your data source name (DSN) is spelled. > > To do so go into Connection -> Add Source and type the name of your DSN and click on Add Source, the name will be added to the TreeView (left panel). Now you can normally get the script for the table you want. > > I hope this will help. > Dave > > > 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 ]