I am trying to run a macro and it gives me a run time error

Question

1.00/5 (2 votes)

See more:

I tried to debug and it gives error to me on MyConn.Open line:

Dim MyConn As New ADODB.Connection ' For Forecaster Access tables

Const ForecasterConnString As String = "DSN=Forecaster"

Dim i As Integer, strSQL As String, intRows As Integer
Dim PartNum As String, QtyReq As Double, DateReq As String, DateLoaded As Date, LoadedBy As String, strProdCode As String

MyConn.ConnectionString = ForecasterConnString
If MyConn.State <> adStateOpen Then
MyConn.Open
End If

What I have tried:

Please help me to bug the error as I am not able to upload the data into the system.

Posted 1-Jun-18 8:14am

Member 13854836

Updated 1-Jun-18 10:03am

Add a Solution

Comments

Patrice T 1-Jun-18 14:24pm

And you think you will tell us the exact error message ?

[no name] 1-Jun-18 14:26pm

So it Shows you only "there is a runtime error"? In case it Shows more than this it would be helpfull to know that to help ;)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2018-06-01T10:04:00

You don't need to use a DSN at all. In this day and age, I wonder why anyone still bothers with them. It's just a connection string put in a place that'a a pain in the ass to manage.

If you made a System DSN, either the name you specified in your connection string doesn't exist or the connection string in the DSN definition is bad.

If you made a File DSN, the connection string in your app has to specify "FILEDSN=...". Of course, the name still has to match and the connection string in the DSN file has to be good.

We have no way of telling what's bad here. It's up to you to check this stuff.