Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
sqlserver2008
- Page 1
Re: search form c#
Programming
Databases
8 Years Ago
by soraa
SQLserver SqlConnection cn = new SqlConnection("Data Source=C:\\Users\toshiba\\Desktop\testtt\\WindowsFormsApplication1\\Database1.sdf"); i just copied it from the properties of the database
Sqlserver 2005 Express Edition
Programming
Software Development
17 Years Ago
by NewVBguy
Hi there, I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance.. newvbguy
Re: Sqlserver 2005 Express Edition
Programming
Software Development
17 Years Ago
by royaloba
[QUOTE=NewVBguy;265270]Hi there, I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance.. newvbguy[/QUOTE] Option Explicit Dim dbCn As String Dim Cn As …
SQLserver soaking up ram
Hardware and Software
Microsoft Windows
14 Years Ago
by sklingb1
I have one terminal on my network that is using a crazy amount of ram. It is slowing the computer way down. How can I adjust the amount of ram that sqlserver can use? In task manager it is always at the top of the list of memory hogs. How do I fix this? I thought it might be a virus but an investigation turned up nothing suspicious. …
sqlserver and asp.net c#
Programming
Web Development
13 Years Ago
by qasimidl
I m using sqlserver there is table name of Attendence Columns of Tables are 1)EmpCode int 2)AttendenceDate datetime 3)AttendenceTime Datetime 4)status tinyint Data in table would be like this Code AttendenceDate AttendenceTime status 1001 3/27/2009 3/27/2009 9:05 1 1001 3/27/2009 3/27/2009 7:05 0 1002 3/28/2009 3/27/2009 10:05 1 …
Re: sqlserver and asp.net c#
Programming
Web Development
13 Years Ago
by dsweb1017
[QUOTE=qasimidl;1176142]I m using sqlserver there is table name of Attendence Columns of Tables are 1)EmpCode int 2)AttendenceDate datetime 3)AttendenceTime Datetime 4)status tinyint Data in table would be like this Code AttendenceDate AttendenceTime status 1001 3/27/2009 3/27/2009 9:05 1 1001 3/27/2009 3/27/2009 7:05 0 1002 3/28/2009 3/27/2009…
java and sqlserver BIG problem??
Programming
Software Development
15 Years Ago
by MxDev
hi guys, i'm trying to connect java application to SQL server 2005 developer edition, i used the following code which comes with the microsoft jdbc-odbc driver 1.2, after that i modify the class path to load sqljdbc_auth.dll file. import java.sql.*; import com.microsoft.sqlserver.jdbc.*; public class connectDS { …
Re: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Programming
Software Development
14 Years Ago
by ManojR
[QUOTE=stackOverflow;701041]Hi All, I'm trying to use jdbc connection with sqlServer 2000. I'm using j2sdk1.4.2. And i have service pack2. I've installed the .jar files mssqlserver.jar, msutil.jar, msbase.jar. I have these jar files in E:\j2sdk1.4.2_04\lib. I'm trying to connect with the following program. [CODE] import java…
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Programming
Software Development
15 Years Ago
by stackOverflow
Hi All, I'm trying to use jdbc connection with sqlServer 2000. I'm using j2sdk1.4.2. And i have service pack2. I've installed the .jar files mssqlserver.jar, msutil.jar, msbase.jar. I have these jar files in E:\j2sdk1.4.2_04\lib. I'm trying to connect with the following program. [CODE] import java.*; import java.io.*; public class …
Re: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Programming
Software Development
11 Years Ago
by Debi prasad
Hello Friends. i have set my environmental variable path of Microsoft JDBC Driver 4.0 as C:\Program Files\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar and i have also used the url "com.microsoft.sqlserver.jdbc.SQLServerDriver" in my Class.forName(). But still at run time i get the exception java.lang.…
Re: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Programming
Software Development
15 Years Ago
by ncaissie
I have writen a simple test using the java compiler and I get the this result. import java.util.*; import java.text.*; import java.sql.*; import java.io.*; import java.*; class test { public static void main(String args[]){ System.out.print("Start"); try { …
format date time type is sqlserver express 2005 to accept dd/MM/yyyy
Programming
Databases
13 Years Ago
by khaled_jawaher
pls,i need help in inserting a date from a text field using java, to mssql database. i am getting incorrect date for example when i insert 13/3/2010,i am getting the date 1/3/2011.i want a solution,i've searched a lot but useless.the problem is in mssql not java,so what i can do to configure date to accept dd\MM\yyyy the code is: Java Syntax (…
Import Excel into sqlserver
Programming
Software Development
12 Years Ago
by mca.shantha
Hi, I am maintaining 100 lakhs record in 1 table often i browse 1 excel from my desktop and import excel into sqlserver.In which there is possibility of same data in that excel that data should be updated in sqlserver and in excel sheet there is possibilty of new data and that data should be inserted into sqlserver using bulk import excel …
Re: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Programming
Software Development
10 Years Ago
by parsifal
Friend, your debugging informaiton is: > java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver May be the woking code below will hints you: ` Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance()`
java sqlserver connectivity issue with eclipse
Programming
Software Development
15 Years Ago
by aman_dba
hi friends i am connecting to sql server with java through eclipse as IDE. here's my base connectivity class to sql server public class BaseDAO { public Connection getConnection() throws Exception { String userName = "aman"; String password = "password"; …
java.lang.classnotfoundexception com.microsoft.sqlserver.jdbc.sqlserverdriver
Programming
Software Development
14 Years Ago
by btreksql
Hi, I need help, I am trying to connect from remote windows xp computer B to ms sqlserver2005 express edition in another windows xp computer A and got this error: java.lang.classnotfoundexception com.microsoft.sqlserver.jdbc.sqlserverdriver My software can connect locally to the sqlserver 2005 though in the local computer A, however when…
C# as front End and Sqlserver 2005 as backend: Method 500 ERROR
Programming
Software Development
12 Years Ago
by megha.iconweb
We are using C# as front End and Sqlserver 2005 as backend.We are using visual studio 2008. System.data.sqlclient is the provider for sqlserver in our localhost and our functionality is running correctly. But we are using bigrock as hostgator, where we uploaded our files and we get to know that they are providing oleDB as provider for sqlserver …
data from mysql to ms sqlserver database
Programming
Web Development
11 Years Ago
by Arjun_Sarankulu
I have a crontab job in which data from csv file get insert into mysql table at regular interval. Now i want the same table data to be inserted in ms sqlserver database. I know i can write code again to take data from csv to ms sqlserver database. But i want to avoid the same. Is there a way programmatically to insert data into ms sqlserver …
Re: which file should i add for SQLServer Database in Package and Deployment
Programming
Software Development
9 Years Ago
by Santanu.Das
MS SQlSERVER creates two files, .mdf and .log. So if you want to attach your datafile in your package, you must select that two files. At the time of installation, the package only copies the files at their destination. You can face a problem to open the database by SqlServer. From my opinion, make a backup of the database and attach it in your …
storing .doc file data into sqlserver
Programming
Web Development
15 Years Ago
by krany18
hai friends, please guide me how to store a .doc (resume ) into sqlserver in asp.net using c# i know the fileupload control but how it can store into sqlserver which datatype i can take.. please give me a valuable solution as soon as possible. Thanks & Regards A.Kranti Kumar MudiamInc S/w Pvt. Ltd
Re: storing .doc file data into sqlserver
Programming
Web Development
15 Years Ago
by priyankaa
u can save files in any location(D:\Resume) with file name attached with rowid and save the name of file with location in database.and for security u can encrypt the file data. [QUOTE=krany18;738539]hai friends, please guide me how to store a .doc (resume ) into sqlserver in asp.net using c# i know the fileupload control but how it can …
Help with godaddy sqlserver connection in c#
Programming
Software Development
15 Years Ago
by csharplearner
Hello all, I am trying to connect to sqlserver on godaddy but facing so much trouble with the connection strings. I wanted to use C# but wasnt successfully in making a connection. when i simply copy-pasted their vb-script connection strings sample.. it worked. I tried to modify vb to c# accordingly with no success. If anybody knows how to connect …
Cannot create SQLServer Backups
Programming
Databases
14 Years Ago
by poparosa
Hi. Intel Xeon CPU 2.40Ghz -- 2GB Ram Windows 2003 R2 Standard edition - (SP 2 applied) SQLServer 2008 Management Studio 2008 (v 10.0.1600.22) I am trying to add a maintenance job using the wizard to perform a backup and I get almost to the end and then I see an error in the five step finishing window. The action is "saving …
How to write same query for MySql and SqlServer
Programming
Web Development
14 Years Ago
by pradeepfusion
Hi, Everybody! I have one problem, I want to use same sql query in MySql and SqlServer. In case of Sql Server generally you have to write query in this way- select * from databasename.dbo.tablename but in case of MySql you have to write query in this way- select * from databasename.tablename. There is no problem if you write in this way- select …
Show Data in DataGrid with VB.Net 2003 and SQLServer 2000
Programming
Software Development
16 Years Ago
by Jx_Man
This Code is easy way to load / show data in Datagrid. This Code write in vb.net 2003 and use sqlserver 2000 as database. I use module to connected VB.Net with SqlServer 2000. so the function to connected can be use in every form in this project.
Inserting a UDT from C# app into sqlserver DB
Programming
Software Development
14 Years Ago
by sedalnas
Hi, I'm new to sqlserver so i has a lot of confuse in working with the user defined types and my C# app , i mean that the problem is how to pass the variables from my c# app to a stored procedure or function in sqlserver , if some body can help me plzzzzz tell me the steps of doing this , i searched a lot in the internet but without any benefit ...
Asp.net C#,Show Message box after saving the data into db(sqlserver)
Programming
Web Development
13 Years Ago
by qasimidl
asp.net with C# how to show the message box after saving the data in db(sqlserver) ?? earlier i was using javascript alert like this [code] <pre lang="xml">public static void ShowMessage(string strMessage,Page pgno) { Label lbl = new Label(); lbl.Text = "<script type='text/javascript' language='javascript'&…
acces sqlserver express remotely using java
Programming
Software Development
13 Years Ago
by khaled_jawaher
I want to use java to access microsoft sql server express remotely.i have allow remote connection in the database that i have.and i allow port 1433 through firewall. the code is: [CODE] import java.sql.*; import java.lang.*; public class Jdbcconn { public static void main(String[] args) { try { //load the driver class Class.…
Re: Show Data in DataGrid with VB.Net 2003 and SQLServer 2000
Programming
Software Development
13 Years Ago
by kentlytears
[QUOTE=Jx_Man;969087]This Code is easy way to load / show data in Datagrid. This Code write in vb.net 2003 and use sqlserver 2000 as database. I use module to connected VB.Net with SqlServer 2000. so the function to connected can be use in every form in this project.[/QUOTE] Hello! thanks for the code you post it was very helpful. how can i …
how display the colunm record to Row using View sqlserver
Programming
Software Development
13 Years Ago
by psathish2
hi Viewer , i was designed reports while there display the shift record column to row , there is multiple there is multiple record i want display one record into column to Row using sqlserver .. i have query in column to row i donot how to apply in view in sqlserver this My View SELECT DISTINCT JC.[JC No] ,D.[Drawing Name],P.[Pattern …
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC