|
From: Danny G. <dan...@gm...> - 2013-02-20 02:43:45
|
NOTE:When you hit send, your message goes out to everyone subscribed to the mailing list. And hopefully someone helps you out. And when you have knowledge you pay it forward and help someone else out by answering a question. :) You need a driver and alias setup in squirrel to connect to a database using squirrel as a client. For the driver, the zip file will contain a jar file. It should be called something like sqljdbc4.jar. So, create a driver in squirrel (with the + sign) name it whatever you like, your example url should be something like: jdbc:sqlserver://<computer name where database resides>;databaseName=<database name> NOTE: don't include the < or > the string above is for connecting to an existing database, to create a new one it's a little different.. Now click the Extra Class Path tab and browse to the sqljdbc.jar you unzipped. That should populate the Class Name dropdown with com.microsoft.sqlserver.jdbc.SQLServerDriver Click ok Now you should have a driver in the left hand side with a blue check mark next to it. Now you need the alias, (ie: the credentials to logon to an actual database) So create an alias in squirrel (with the + sign) name it whatever you like, pick the driver you just created from the dropdown, the url should be populated with whatever you specified at the driver level, so your good there. enter a valid username and password for the database you are trying to connect to and click test. If successful, now you have an alias with a blue check mark, and can chose that alias and connect whenever you want Should be good to go from there. On Tue, Feb 19, 2013 at 9:05 PM, Andrew Saldivar <and...@ya...>wrote: > Hello all, > > Please pardon this intrusion, as I have no idea what's supposed to happen > when I hit "send". Hopefully someone will receive it and respond. > > I have installed the 3.4 software on Windows XP running in a virtual > machine on a Win7 x64 machine. Seems to run fine except I can't seem to > figure out how to install a driver. The only JDBC driver that is installed > (by default) is the ODBC bridge. > > I'm running Java 7. 13, which shows up as Java 1.7 (I think), then I > downloaded the Microsoft JDBC 4 driver for SQL Server, which doesn't > actually install, it just unzips into a folder. > > There's no documentation or information on what to do next. Whatever I've > tried leads to repeaded class no found error messages. Is there any hope > for getting this to work as a sever novice? I've tried looking at a number > of messages on the users list, but it seems expert knowledge is required to > even understand the lingo. > > If anyone can advise as to how to set this program up so it works, I would > appreciate a response. > > Thank you, > > Andrew > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
