forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


VdsDB Problem

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help
View previous topic :: View next topic  
Author Message
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Tue May 18, 2021 1:00 am    Post subject: VdsDB Problem Reply with quote

Hi. I have a program using VdsDB.dll.
Im using VDS5 Ide and it works great in Windows XP 32bits and Windows 7 32 and 64bits.
I recently updated my desktop machine to windows 10 x64 and all the examples using VDSDB dont run. I attached an example of the error.
Is this a problem of Windows 10? Any idea of how to solve it?

Sorry for my english...

Marcelo



Error.jpg
 Description:
 Filesize:  96.69 KB
 Viewed:  453 Time(s)

Error.jpg


Back to top
View user's profile Send private message
cnodnarb
Professional Member
Professional Member


Joined: 11 Sep 2002
Posts: 762
Location: Rockeledge, GA

PostPosted: Tue May 18, 2021 2:35 am    Post subject: Reply with quote

Check ODBC Data Sources 32 bit.

You are likely missing a MDB driver.
Back to top
View user's profile Send private message AIM Address
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Tue May 18, 2021 5:52 pm    Post subject: Reply with quote

Thanks a lot for your answer.
Odbcad32.exe 32 and 64bits seems to show the driver installed.
Is this what you are talking about?



Error2.jpg
 Description:
 Filesize:  88.43 KB
 Viewed:  430 Time(s)

Error2.jpg


Back to top
View user's profile Send private message
cnodnarb
Professional Member
Professional Member


Joined: 11 Sep 2002
Posts: 762
Location: Rockeledge, GA

PostPosted: Tue May 18, 2021 8:31 pm    Post subject: Reply with quote

Try correcting the driver name string to include *.accdb

"Microsoft Access Driver (*.mdb, *.accdb)",DSN=
Back to top
View user's profile Send private message AIM Address
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Tue May 18, 2021 8:52 pm    Post subject: Reply with quote

Nothing... Sad
Back to top
View user's profile Send private message
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Tue May 18, 2021 11:30 pm    Post subject: Reply with quote

I think i solved it.

Thanks a lot for your help!!!!
Back to top
View user's profile Send private message
JRoza
Contributor
Contributor


Joined: 17 Aug 2003
Posts: 182
Location: Netherlands

PostPosted: Wed May 19, 2021 10:18 am    Post subject: Reply with quote

Would be nice if you share your solution with us.
Others can learn from it.
Back to top
View user's profile Send private message Visit poster's website
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Wed May 19, 2021 4:59 pm    Post subject: Reply with quote

JRoza wrote:
Would be nice if you share your solution with us.
Others can learn from it.


Sure! I finally find the solution in the forum and i rewrite it in VDS.

I will post it here as soon as i explain the code....
Back to top
View user's profile Send private message
marcelo
Contributor
Contributor


Joined: 10 May 2008
Posts: 140

PostPosted: Wed May 19, 2021 5:20 pm    Post subject: Reply with quote

This is the solution that works for me.
For an example "db setup" line:

Code:
db setup,"Microsoft Access Driver (*.mdb)",DSN=MyOwnDSN,UID=admin,PWD=Mypass,DataDirectory=,DBQ=db\Mydatabase.mdb


This is what i need to do in place of use "db setup":

Code:

%%DSN = MyOwnDSN
%%UID = admin
%%PWD = MyPass
%%DBQ = db\MyDatabase.mdb

registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"Driver","C:\Windows\system32\odbcjt32.dll"
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"PWD",%%PWD
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"DBQ",%%DBQ
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"DriverId",00000025,INTEGER
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"SafeTransactions",00000000,INTEGER
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN,"UID",%%UID
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN\Engines
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN\Engines\Jet
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN\Engines\Jet,"ImplicitCommitSync"," "
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN\Engines\Jet,"Threads",00000003,INTEGER
registry WRITE,LOCAL,Software\WOW6432Node\ODBC\ODBC.INI\%%DSN\Engines\Jet,"UserCommitSync","Yes"
registry WRITE,LOCAL,"Software\WOW6432Node\ODBC\ODBC.INI\ODBC Data Sources"
Registry WRITE,LOCAL,"Software\WOW6432Node\ODBC\ODBC.INI\ODBC Data Sources",%%DSN,"Microsoft Access Driver (*.mdb)"


I take that registry values from a 32bits machine with a working connection.

Now yo can connect using:

Code:

db connect,MyOwnDSN,admin,


I'm thinking of make a function to simplify its use:
I.e:

Code:

@dbsetup(%%DSN,%%UID,%%PWD,%%DBQ)


and the ability of removing it from registry.
Something like:

Code:
@dbremove(%%DSN)


I hope that info helps someone and sorry for my english...

Marcelo
Back to top
View user's profile Send private message
cnodnarb
Professional Member
Professional Member


Joined: 11 Sep 2002
Posts: 762
Location: Rockeledge, GA

PostPosted: Wed May 19, 2021 7:38 pm    Post subject: Reply with quote

Thumbs Up Thumbs Up
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group