Resloved: vb6 app connecting to 64bit OS Server?

[coolwater]

QUESTION: What will be the effect of a vb6 DB Application connecting to a 64 bit sql server 2005, 64 bit Windows 2003 server.

My DB app was written in vb6 connecting to a 32 bit Windows 2003 Server Ent., Using Sql Server 2000 as DBMS. VB6 app has been running for 3 years with no problems.

My dilema is we have a new Server Machine running on a 64 bit Windows 2003 server and 64 bit SQL Server 2005 as DBMS. I'm hesitant to transfer/import all users, rights, SQL (mdf's), etc from the old 32 bit server to the new 64 bit server. I dont know the effects. Will my vb6 app be able to connect to sql 64 bit server 2005? Frustrating! I don't want to experiment. Existing Data is too valuable for me to experiment. Will my vb6 app can do add, edit, delete, select on a 64 bit sql server 2005?

Any comments, suggestions is highly appreciated.

[Al42]

Run SQL Server on the new computer as a test. Bang on it. Then you'll see whether it works or not. Don't go live until you're comfortable that there are no issues.

[randem]

That sounds like a job for concurrent testing (as well as it should be).

[coolwater]

we just finished setting up the x4200 SERVER using 64bit Windows Server 2003 and the 64bit SQL server 2005. To my surprise my vb6 clients did not have problems connecting to the 64bit OS server. Amazing! So far no problems yet, and it seems posting transactions/data seems a bit faster now. Truly amazing! Our only problem now is our asp/web applications wont work on the new 64 bit windows server. We are still using asp and not asp.net. Waaaaah! I guess we need a crash course on asp.net? We're Still trying to figure out why our web app wont work. huhuhuhuhuhuhu

[coolwater]

Just finished testing the 64 bit windows 2003 server and 64 bit sql server 2005. Everything works fine. my vb6 apps can connect to the 64bit server. And what's truly amazing is, data acces is super fast! Fantastic! No vb6 codes where re-written. Truly amazing! I would recommend switching to 64 bit computing. Data Access is much faster....