Connecting with SQL Server Express 2005

jakes

Hi,

I am new to Rapid Miner.

I have just installed the new version of RM (5.0) and I am trying to connect to a SQL server (Express) database on the same home machine. For some reason it always gives me an error.

Even though i did download the driver(http://www.microsoft.com/downloads/details.aspx?familyid=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en) and copied both the .jar files into the /lib folder, when i look under Tools -> Database Drivers, the SQL Server (Microsoft) driver is not enabled.

Can anyone help me with this?

Thanks in advance.

Jake

land

Hi Jake,
please copy the driver into the /lib/jdbc directory. This is the only path searched automatically. Please tell me, if this does not work either.

Greetings,
  Sebastian

jakes

Hi Sebastian,

Many thanks for your reply.

I did copy the sqljdbc.jar file into the /lib/jdbc and still it doesn't work.

I would really appreciate if you could help.

Regards,

Jake

haddock

Hi there,

You may not need to go though this pain - I can connect to SQL Express dbases using the JTDS driver that comes ready installed with RM5. If that fails enclose the error messages from the log in your next post.

jakes

Hi haddock,

Many thanks for your reply.

I am using the wizard available with RM5 and it still gives me an error using the JTDS driver.

The specific error I am getting is " Please check your connection settings and revalidate the connection URL: 'jdbc:jtds:sqlserver://localhost:1433/dbschemaname'.

Would be great if you could help!

Cheers,

Jake

land

Hi Jake,
seems to me, there's no sever available on the specified address with the schema "dbschemaname". Anyway this name seems to be unrealistic silly, it is correct?

Greetings,
  Sebastian

el_chief

Are you using a Named Instance on the SQL Server?

if so, change your connection string to this:

jdbc:jtds:sqlserver://domain:1433/databasename;instance=sqlexpress

http://www.youtube.com/user/VancouverData