 |  |  |  |  |  |  |  |
MS SQL Server 2005 Express & VB6
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
•
•
Join Date: Jan 2008
Posts: 50
Reputation: 
Solved Threads: 1
Junior Poster in Training
Hi all,
Can anybody help me out with the connectionstring for connecting VB6 to a Microsoft SQL Server 2005 Express Edition. I have tried several documented varieties which do not work.
My latest attempt was a version from this website.
I downloaded the application and associated files and changed the server name in the connection string to LAPTOP (which is the name of my server)but when ran I keep getting error message
This problem is driving me insane as the error messages are almost as baffling as connection strings and sqlserver put together!!!!
Can anybody help me out with the connectionstring for connecting VB6 to a Microsoft SQL Server 2005 Express Edition. I have tried several documented varieties which do not work.
My latest attempt was a version from this website.
I downloaded the application and associated files and changed the server name in the connection string to LAPTOP (which is the name of my server)but when ran I keep getting error message
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
This problem is driving me insane as the error messages are almost as baffling as connection strings and sqlserver put together!!!!
Ther are 10 types of people in the world. Those who do understand binary and those who don't!!
•
•
Join Date: Jan 2008
Posts: 50
Reputation:
Solved Threads: 1
Junior Poster in Training
I had tried this site already.However,after the advice from a colleague at work and yourself I took a second look.
The suggested..
didn't work. I then replaced with and Hey Presto...!!
Ya little booty.
Cheers for the reply.
The suggested..
•
•
•
•
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase; Trusted_Connection=yes;
•
•
•
•
Driver
•
•
•
•
Provider
Ya little booty.
Cheers for the reply.
Last edited by lostandfound; Nov 6th, 2008 at 3:26 pm. Reason: spelling
Ther are 10 types of people in the world. Those who do understand binary and those who don't!!
 |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: winamp plug-in
- Next Thread: FTP using Inet (remote server log directory)
Views: 1580 | Replies: 2
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
