|
From: David C. <Dav...@ve...> - 2006-04-29 11:53:06
|
Peter - Yes, your problem stems from what appears to be a mis-understanding on your part about how database-SERVERS work. One does NOT ever specify an actual driver-letter, file and directory (as you tried to do). The SERVER knows where the data comes from...the client does NOT! I presume that you've inserted a few records into your sample database (using whatever sofware came with 'Firebird'). So, the server would then know TWO NAMES: o a 'DB' name (e.g. 'employees') o a 'table' name (e.g. 'employeedata') So, the jdbc 'URL' would contain ONLY that DB-name (as one piece of the URL). (The 'table' name you would reference in a later SQL statement, such as "select * from employeedata") AFTER you have connected to the DB thru the server.) The two OTHER parts of a JDBC 'url' are the HOST and the PORT. The host is either a REMOTE machine name (e.g. such as 'myserver.ibm.com' or if it is on the SAME machine that your SQuirreL pgm is running on, then the HOST would be just 'localhost'). The PORT is of course typically a 2- to 4-digit number (that your server is listening on), such as 3050 (as you stated in your msg). The JDBC 'url' is similar to the way web-servers are addressed...where the PROTOCOl, HOST and PORT are specified: HTTP://GOOGLE.COM:80 (etc) In that case, GOOGLE.COM is the 'host' and '80' is the port that the HTML server is listening on. Hope this helps... Dave [just another SQuirreL user] -----Original Message----- From: squ...@li... [mailto:squ...@li...]On Behalf Of sun...@us... Sent: Saturday, April 29, 2006 5:14 AM To: squ...@li... Subject: [Squirrel-sql-users] Attaching to database with URL I have installed the drivers for Firebird and then look to add an alias for the required database. However when I try to do a test connection I get an error message, "CF: Problem getting connection: could not get a db connection" or get the error message "CF:Unable to create connection. Check your URL" The syntax presented for Firebird is: jdbc:firebirdsql:[//host[:port]/]<database> I have tried and got the error Problem getting connection: jdbc:firebirdsql:c\compiere\data\compiere.fdb jdbc:firebirdsql:c:\\compiere\\data\\compiere.fdb Check your URL error: jdbc:firebirdsql://taurus/c:\compiere\data\compiere.fdb jdbc:firebirdsql://taurus/c:\\compiere\\data\\compiere.fdb jdbc:firebirdsql://taurus/taurus-c:\\compiere\\data\\compiere.fdb I obtained the original syntax from Compiere properties file as: taurus{taurus-c\:\\compiere\\data\\compiere.fdb-SYSDBA} I'm using: - Windows XP Professional - Java 1.5 - Machine name: taurus - apps port: 1099 - DB port: 3050 - DB User: SYSDBA - DB Pwd: masterkey If anyone can point me to the correct syntax or if there is anything else I am missing, would be appreciated. Thanks Peter ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
