Re: Database toolkit connection problems

Hi all, I was having this same problem but managed to find the solution! Hopefully it works for everyone else.

FYI: I'm using Vista Home Premium (x64) as the client to connect to a SQL Server 2008 instance which is on the same machine.

As we all figured, it's all to do with the ODBC configuration. I guess we all did the same thing, we added a new User Data Source (User DSN) item for the database in question. Trying to connect Matlab after this no doubt failed for all of us. What needs also to be done is to add a new System Date Source (System DSN) item for the respective database that we want access to.

After doing this, restart Matlab and try to connect to the database in connection through the usual "database" command...this should fix the problem...it did for me.

Good luck.
fj
.

Relevant Pages

  • Re: SQL active - active cluster hardware design?
    ... time on a few hundred rows in an sample database and wants to know why their ... have seen the results all over the map with different workloads (e.g. ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors ...
    (microsoft.public.sqlserver.clustering)
  • RE: Downgrade from SQL2005 x64 EE to SQL2005 x64 SE
    ... We installed a new version of x64 SE on a new x64 bit platform and moved the ... "Mohit K. Gupta" wrote: ... MCITP: Database Administrator ... Was wondering if anyone could tell me the potential issues with downgrading ...
    (microsoft.public.sqlserver.setup)
  • office 2007 x64 and x86 odbc
    ... that our database does not have a x64 driver only a x86 driver and if Office ... database queries since the odbc driver is only x86. ...
    (microsoft.public.windows.terminal_services)
  • Record Locking /Linking via Vista
    ... I have a laptop running vista home premium and need to connect to the office pc that has the BE database. ... I can link to the BE if the office pc is not using the DB, however, when they logon to the system I am looked out and my system freezes. ... I have the default open mode set to 'shared' ...
    (microsoft.public.access.externaldata)
  • Restore from Windows Vista Home Pre x86 to x64
    ... to repair. ... I put an x86 Vista Home Premium instead of x64. ...
    (microsoft.public.windows.vista.installation_setup)
Loading