On Jan 31, 2013, at 12:47 PM, Jorge Flávio Aquino da Costa wrote: > yeah that's where the MSSQL dialect is doing things that aren't going to work > with QODBC. I don't have a quick fix for this for you, it would require > creating a new dialect that doesn't perform these particular startup queries. > unless you want to get into doing a little bit of programming, you might > have to work directly with pyodbc for now. > > > Michael and Scotty, > > I´m facing a similar problem, but regarding to Intersystems Caché DB. I can > connect through pyOdbc and proprietary cacheodbc driver for win64. At the > moment, there´s no one single dialect of Caché DB for SA and that forced me > to build one. I also didn´t find any documentation about how to do it so I > tried to modify the existing mssql that used pyodbc too. > > I could figure some quirks out such as how to find the default schema but > hardcoded others (currently loged user). The mssql dialect was renamed to > cachedb and its new reencarnation managed to connect to my test database with > a relative success (few non fatal errros). But, as of now, the compiled sql > followed MS SQL conventions and surrounded the column names with a '[' as in: > "Select [Person].[Name], [Person].[Phone] From [dbo].[Person]" where it > should be "Select Person.Name, Person.Phone From dbo.Person". > > The lack of documentation didn´t help me to discover where and how to alter > that decoration behaviour not supported by Intersystems Caché. Any help about > this problem? Is there a howto in creating SA dialects from scratch? Is this > a better aproach?
people usually create dialect by following the examples of the existing ones. The quoting behavior is controlled by the IdentifierPreparer provided by the dialect and is fairly self-explainatory. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.