Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 23rd, 2009, 03:39 PM
Friend of Wrox
Points: 550, Level: 8
Points: 550, Level: 8 Points: 550, Level: 8 Points: 550, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , , .
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default VB app connect to DB using DB_CONNECT???

Hi to all...

I have a VB app that I was using with SQL 2000 and was working fine...
I was connecting to the DB using the following

DB_CONNECT = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Connect Timeout=30000;Persist Security Info=False;User ID=sa;Initial Catalog=DBName;Data Source=ServerName"

Now we got a new server which has SQL 2008 studio...
and i used the above to connect and i get an error cannot open DB login failed...
i changed the user ID the data source to the new server info...

is it the correct line to us for SQL 2008 ???

thanking you in advance

Rino
  #2 (permalink)  
Old November 23rd, 2009, 05:03 PM
Friend of Wrox
Points: 550, Level: 8
Points: 550, Level: 8 Points: 550, Level: 8 Points: 550, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , , .
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default

FYI
i got it to work it is the same for SQL 2008...

i was logged in as administrator running the exe i log in as the server name and that worked...

Thx Rino


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting a console App from a vb.net windows app RobCarter Pro Visual Basic 2005 4 June 24th, 2009 09:20 AM
How to connect to Access db thru VB.NET? am_kuthus Visual Studio 2008 1 June 3rd, 2008 04:48 AM
Convert a VB.Net app to a web app? furjaw VB.NET 3 September 24th, 2007 12:27 PM
MySql db_connect ujj Beginning PHP 3 August 16th, 2005 07:49 AM
Need to connect to SQL DB in VB app codehappy VB How-To 3 April 21st, 2005 12:03 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.