View previous topic :: View next topic |
Author |
Message |
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Tue May 18, 2021 1:00 am Post subject: VdsDB Problem |
|
|
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
Description: |
|
Filesize: |
96.69 KB |
Viewed: |
490 Time(s) |
|
|
|
Back to top |
|
|
cnodnarb Professional Member
Joined: 11 Sep 2002 Posts: 762 Location: Rockeledge, GA
|
Posted: Tue May 18, 2021 2:35 am Post subject: |
|
|
Check ODBC Data Sources 32 bit.
You are likely missing a MDB driver.
|
|
Back to top |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Tue May 18, 2021 5:52 pm Post subject: |
|
|
Thanks a lot for your answer.
Odbcad32.exe 32 and 64bits seems to show the driver installed.
Is this what you are talking about?
Description: |
|
Filesize: |
88.43 KB |
Viewed: |
468 Time(s) |
|
|
|
Back to top |
|
|
cnodnarb Professional Member
Joined: 11 Sep 2002 Posts: 762 Location: Rockeledge, GA
|
Posted: Tue May 18, 2021 8:31 pm Post subject: |
|
|
Try correcting the driver name string to include *.accdb
"Microsoft Access Driver (*.mdb, *.accdb)",DSN=
|
|
Back to top |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Tue May 18, 2021 8:52 pm Post subject: |
|
|
Nothing...
|
|
Back to top |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Tue May 18, 2021 11:30 pm Post subject: |
|
|
I think i solved it.
Thanks a lot for your help!!!!
|
|
Back to top |
|
|
JRoza Contributor
Joined: 17 Aug 2003 Posts: 182 Location: Netherlands
|
Posted: Wed May 19, 2021 10:18 am Post subject: |
|
|
Would be nice if you share your solution with us.
Others can learn from it.
|
|
Back to top |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Wed May 19, 2021 4:59 pm Post subject: |
|
|
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 |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 140
|
Posted: Wed May 19, 2021 5:20 pm Post subject: |
|
|
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:
I hope that info helps someone and sorry for my english...
Marcelo
|
|
Back to top |
|
|
cnodnarb Professional Member
Joined: 11 Sep 2002 Posts: 762 Location: Rockeledge, GA
|
Posted: Wed May 19, 2021 7:38 pm Post subject: |
|
|
|
|
Back to top |
|
|
|
|
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
|
|