Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Vb connecting to SQL?

Posted on 2003-03-25
3
Medium Priority
?
142 Views
Last Modified: 2013-11-23
Hello guys and gals. I was wondering if someone could helpe me. I am writing a VB program to connect to SQL database I am using the DSN name. but when I put the DSN name in the program It throws me an error saying OBDC not found or driver not specified. Not when I leave it blank it will prompt to select my data file source name. and it works. What I am I doing wrong? Am I missing something or should I have written this another way? Thank you very much
0
Comment
Question by:D_basham
3 Comments
 
LVL 1

Accepted Solution

by:
BurtonRacing earned 100 total points
ID: 8202868
Is the DSN name exact?  I would try to use a DSN-Less connection, but you could do a search on www.google.com for "Connection Strings" which will give you a bunch of sites that show how to connect to different types of databases in different manners.  If that doesn't help post your code.  It would be nice to see how you have the DSN setup, but not a big deal.
0
 

Author Comment

by:D_basham
ID: 8203018
Yeah it is the exact DSN name I thought of that too. I will try the search and if I don't see anything I will post the code. Thank you very much.
0
 

Expert Comment

by:archekrypt
ID: 8216284
you haven't got a valid DRIVER as a provider, check your ADO References.

OR

the database isn't there, or it is there but NOT VALID!!!!!!!

So, yeah!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month13 days, 1 hour left to enroll

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question