hiteksoftware.com Forum Index hiteksoftware.com
User discussion forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Connecting to a SQL 2005 database

 
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions
View previous topic :: View next topic  
Author Message
Seblock



Joined: 16 Sep 2010
Posts: 2

PostPosted: Thu Sep 16, 2010 7:41 am    Post subject: Connecting to a SQL 2005 database Reply with quote

Hi,

I'm trying to connect to a SQl database but am getting the standard error that I don't have the class right or the files loaded correctly.

I downloaded the JDBC drivers from Microsoft
I installed the file (It installed onto the desktop)....bit strange
I copied the .jar files into the ../jre/lib/ext within automize, I also copied it to the main automize folder
I created an ODBC DSn on the machine called transport which works fine from other software - did a few reeboots and restarts of the software

I think I am going wrong with my class name and url

I have
Class Name: com.microsoft.jdbc.sqlserver.SQLServerDriver
URL: jdbc:odbc:DSN

I have also tried jdbc:microsoft:sqlserver://locksvrdb01:1433 as the URl and a variety of Class Names

Help

Thanks

Seb
Back to top
View user's profile Send private message
melvin
Site Admin


Joined: 25 May 2006
Posts: 635
Location: Santa Barbara, california

PostPosted: Thu Sep 16, 2010 8:17 pm    Post subject: Reply with quote

if you are using the jdbc-odbc bridge, then try for driver class name:
sun.jdbc.odbc.JdbcOdbcDriver
Back to top
View user's profile Send private message Send e-mail
Seblock



Joined: 16 Sep 2010
Posts: 2

PostPosted: Fri Sep 17, 2010 1:10 am    Post subject: Reply with quote

Laughing

Perfect - worked straight away. Thanks Melvin
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group