vbs connection to Micros database

[raphael75]

I have to write another script to connect command-line vbscript to Micros, which uses SQL Anywhere 11. When I try to make the connection I get this error:

The specified dsn contains an architecture mismatch between the driver and application
code 80004005

and the connection:

Set Connection = CreateObject("ADODB.Connection")
strdsn = "DSN=micros;UID=********;PWD=********;"
connection.open strdsn

Apparently that error has something to do with 32- vs. 64-bit drivers, but I don't know how to fix it. Please help, thanks!

 

[hosehead78]

Have a look here.

https://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx

 

[Moregelen]

'SQL connection variables
Dim con_Micros As ADODB.Connection
Dim rs_PeriodTrkTtls As ADODB.Recordset
Dim rs_PeriodOTTtls As ADODB.Recordset
Dim rs_FixedPeriodSeqs As ADODB.Recordset
Dim rs_LaborTotals As ADODB.Recordset
    
Set con_Micros = New ADODB.Connection
Let con_Micros.ConnectionString = "DSN=micros;UID=custom;PWD=custom"
con_Micros.Open

Using this in an excel spreadsheet; works just fine. Did you register the drivers yourself on the machine you're running this on, or are you running it directly on Micros?

Don't think this is valid as of 5.2 in that the actual setup portion where you put in the server information has changed, but it gets you far enough to properly register the driver and start setting up the ODBC connection.

 

[Moregelen]

Meant to post this link when I said that:

https://www.dropbox.com/s/ssc1yy254...cros connection on a remote computer.pdf?dl=0

 

[raphael75]

The .vbs script I'm trying to get working needs to run on the same computer where Micros is installed.

I went to the c:\windows\syswow64 folder and opened the odbcad32.exe file in there. I created a new User DSN called "micros_2" and copied all the settings the "official" Micros System DSN uses. I tested the connection and it was successful. I tried this:

Set Connection = CreateObject("ADODB.Connection")
strdsn = "DSN=[COLOR=#CC0000]micros_2[/color];UID=custom;PWD=custom"
connection.open strdsn

but I got the same vbs error.

 

[Moregelen]

I'm guessing it's an x64 machine then. By default dot net will run in the same architecture of the OS. You must run it as x86.

http://stackoverflow.com/questions/...a-vbscript-in-32-bit-mode-on-a-64-bit-machine

 

[Moregelen]

I would suggest you used a compiled version of VB though because then you can just set the architecture target. Visual Studio Express is free.

 

[raphael75]

I think the best plan will be to use dbisql and parse the results. I have tested this and it works. Thanks so much for all the suggestions.