Urban Research
Jump To: SQL Utility - Software
Other: Add Incident to SQL Utility Database
About: Submit Information about SQL Utility

Urban SQL Utility - Incident Detail  

SeverityPriorityStatus
HighestHighestFixed

Urban SQL Utility - Incident Details (As Reported)  
Description: problem opening databases with a "." in the name
Reported By: [hidden]
Date Reported: 2001-10-19
Version: 1.0.1.97
Report Method: WWW::FormSubmission
Details: As follows:
--------------------------------------------------------------
For construction purposes I give my databases the same name as
domains they are intended for. ( something like: mydomain.com )

From mysql directly or through PHP I don't find any problems
connecting to those databases.
(different story when trying to create them but not relevant)
When I use a file or systemdsn which points directly to a
database with a "." in the name,... I don't encounter any
problems using URSQL. But if I try to switch to a different
database (let say: anotherdomain.com) using the pull-down in
the upper-right corner, I encounter the following error:

General SQL error.
[TCX][MyODBC]You have an error in your SQL syntax near '.com' at
line 1

Is it possible to build-in a trick into a future ursql version
to avoid this problem or is this a MyODBC related problem.

Since I didn't find another living sole with the same
problem, I guess I'm the only one...?
...or am I just doing something I shouldn't ?

Hopefully you can help me out here ?


Kind Regargds,

Pieter Kalter
Plexus ICT B.V.


Urban SQL Utility - Incident Status Details  
Resolution: Fixed
Fixed By: jeu
Fixed in Version: 1.0.1.99
Fixed Date: 2001-10-24
Details: Added quoting of database names for
MySQL Servers with a version number
greater than or equal to 3.23.6.


Home | E-Mail | Request Info

© 1996,1997,1998 Urban Research. All rights reserved.