Error in tracking users login/logout times on your site

Question

1.00/5 (1 vote)

See more:

I want to use this scrip, but after login details it gives error as

Script error detected at line 39.
Source line: conn.Open Application("connString")

Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

What I have tried:

my database mdb file is in folder at location: <pre>E:\USERLOGINTOSITE

so I added this line
:

Application("connString") = "DRIVER={Microsoft Access Driver (*.mdb)}; E:\USERLOGINTOSITE\DBQ=test.mdb"

Pleaes guide

Posted 19-Apr-22 19:36pm

Member 15532479

Updated 19-Apr-22 21:45pm

Add a Solution

2 solutions

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)

OriginalGriff · Answer 1 · 2022-04-19T19:59:00

Solution 1

Your connection string is wrong.
See heer: Access connection strings - ConnectionStrings.com[^]

Posted 19-Apr-22 19:59pm

OriginalGriff

Comments

Member 15532479 20-Apr-22 2:08am

Please provide the right string for me.

OriginalGriff 20-Apr-22 2:24am

Certainly!
Just ship your computer and the network it is connected to so I can looks ate the files and work out what the connections string for your specific situation might be ...

Or ... and this is quicker given how long international shipping can take ... look at the file you want and at the example strings and try for yourself?

Member 15532479 20-Apr-22 2:51am

Sorry for that..
I am using
Application("connString") ="Driver={Microsoft Access Driver (*.mdb)};Dbq=E:\USERLOGINTOSITE\test.mdb;"

Path to mdb is E:\USERLOGINTOSITE\test.mdb

I Have Access 2019.

Still getting error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Really appreciate your help ans support please.

Richard MacCutchan · Answer 2 · 2022-04-19T21:45:00

Solution 2

Your connection string is incorrect, look at the position of "DBQ=" in the string. See Microsoft Access ODBC Driver Connection Strings - ConnectionStrings.com[^].

Posted 19-Apr-22 21:45pm

Richard MacCutchan

Comments

Member 15532479 20-Apr-22 4:04am

Thanks dear, I am getting error for connection:

I am using
Application("connString") ="Driver={Microsoft Access Driver (*.mdb)};Dbq=E:\USERLOGINTOSITE\test.mdb;"

Path to mdb is E:\USERLOGINTOSITE\test.mdb

I Have Access 2019.

Still getting error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Really appreciate your help ans support please.

Richard MacCutchan 20-Apr-22 4:23am

You have tagged your question "script", that is not a language that I know of.