|
From: Colin B. <col...@te...> - 2003-10-01 01:27:57
|
Hi Norman, > Squirrel keeps asking me for a user/password combo but, as far as > I know none is set up and I do not know the syntax needed in this > case. User and password aren't mandatory, just leave them blank in the connection dialog. > Do I need to be running some database server? SQuirreL should connect to any database providing there is a JDBC driver for it. To use an Access database you don' t need a server but you will need a driver. On Windows the _normal_ way is to create an ODBC data source and then use the JDBC/ODBC Bridge driver (which is shipped with the java runtime) bridge to connect. The URL for this is jdbc:odbc:<alias> replacing <alias> with the name of the ODBC data source. To use ODBC on Linux you'll need to get a third-party ODBC product. A Google search brings up some info but I personally haven't tried doing this. http://www.google.com/search?q=ODBC+for+Linux&hl=en&lr=&ie=UTF-8&oe=utf-8&start=10&sa=N Another possibility is the RmiJdbc driver http://rmijdbc.objectweb.org/ If you want to replace Access totally then you'll need to use another database, possibly a server. MySQL and PostgreSQL are probably the most popular DBMS's for Linux but there are others. See http://squirrel-sql.sourceforge.net/index.php?page=faq#faq0 for a list of DBMS's that have been reported to work with SQuirreL. Some of these (such as Axion) can run in-process (I.E> don't need a server) -- Colin Bell http://squirrel-sql.sf.net -- Colin Bell http://squirrel-sql.sf.net ----- Original Message ----- From: Norman <nor...@nt...> Date: Monday, September 29, 2003 9:10 am Subject: [Squirrel-sql-users] Connecting to MS Access .mdb file > Hi, > I have been trying to connect to a Microsoft Access test.mdb file > which is one I created using MS Access. > > I am running Squirrel on Linux and have shared access to the > database directory which is on my Linux home partition. > > Squirrel keeps asking me for a user/password combo but, as far as > I know none is set up and I do not know the syntax needed in this > case. > > I have > Do I need to be running some database server? > > It is my first time using this software which I hope will help me > to move a number of people from Windows entirely. > > Thanks, > norman > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
