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.DLL and 64bit OS

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Advanced Help for VDS 5 & Up
View previous topic :: View next topic  
Author Message
Aslan
Valued Contributor
Valued Contributor


Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA

PostPosted: Wed Feb 18, 2009 5:08 am    Post subject: VDSDB.DLL and 64bit OS Reply with quote

I seem to have a problem getting Tommy's vdsdb.dll to work properly on any 64 bit version of Windows.

Anyone have any ideas on the subject? In fact, has anyone heard from Tommy the last few years? I wonder if he would be willing to release the source so that someone might update it for 64bit systems. I have a feeling this is going to be a more prominent issue as time goes by.

Dragonsphere, I wouldn't be suprised if there was a way to communcate with SQL using GadgetX (I'm hoping anyway Smile) I can do it in VBS so I'm guessing that chances are good.
Back to top
View user's profile Send private message Send e-mail
PGWARE
Web Host


Joined: 29 Dec 2001
Posts: 1562

PostPosted: Wed Feb 18, 2009 7:18 am    Post subject: Reply with quote

I suspect you installed a 64-bit version of MySQL? The vdsdb likely is calling the 64bit dll and that won't work. Is it possible for you to use the 32bit version of MySQL? as it will work fine on a 64bit OS.

I doubt there is any fix available for a 32bit process to call/load a 64bit dll.
Back to top
View user's profile Send private message
Aslan
Valued Contributor
Valued Contributor


Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA

PostPosted: Wed Feb 18, 2009 2:26 pm    Post subject: Reply with quote

Hiya P Smile

In this instance I'm trying to use the vdsdb.dll on Windows XP 64bit to talk to M$SQL that is on another server. Vdsdb uses ODBC and I suspect that might be where my problem is since it's trying to connect to a 64bit driver.
Back to top
View user's profile Send private message Send e-mail
Aslan
Valued Contributor
Valued Contributor


Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA

PostPosted: Fri Feb 20, 2009 12:24 am    Post subject: Reply with quote

I got this handled so I thought I'd share Smile

There is a builtin 32 bit SQL server driver on Windows x64 systems.

The solution is that you have to create a 32bit DSN. (The ODBC tool in admin tools is for 64bit DSN)

You can create it in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\<yourDSNhere>

-OR-

You can create it with the builtin utility:
%WINDIR%\SysWOW64\odbcad32.exe

I hope this is just as helpful to others as it is for me. Wink
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Advanced Help for VDS 5 & Up 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