I have a windows application using a MSSQL (the free 2gig version) database. When the application is first started, I have to select 'sql server' and then I need to give the sql setup (servername, user+pass) in an ODBC datasource setup dialog. Now I am wondering, would there be a chance I could use PostgreSQL on my linux server, with an ODBC windows driver, and let this application create and use a postgresql database instead, without having to make changes to the application itself? Or do I have a way to positive idea about ODBC interfaces... Right now I tried to get this working, I installed postgresql 7.1, and the postgresql ODBC driver for windows, but I can't even import database tables from postgresql in MSAccess. But this could very well be because the highest version I can select in the driver is the 6.4/6.5 protocol. The only way to convince people to move from MSSQL to PostgreSQL would be when they don't notice the difference ;-) Should I go on with this, or don't I have a chance? Best regards, Pieter ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
