ODBC connection timeout to Cygnet database
Anyone have any experience with connecting to a Cygnet database via Access or SQL Server?
Specifically, I'm interested in linking to the vhs.HistoricalValues table, which apparently is quite large. I have a machine DSN created for Cygnet, but I continue to get timeouts when I try to link to the database.
Specifically, I'm interested in linking to the vhs.HistoricalValues table, which apparently is quite large. I have a machine DSN created for Cygnet, but I continue to get timeouts when I try to link to the database.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeff,
I kept looking for those properties in the 2010, but just couldn't seem to find them. Appreciated that input.
The data structure in this table I'm dealing with is extremely frustrating, I think I preferred not being able to access the table to having to figure out how to pull the information I need. There are a couple of other tables I need to dig into to see if they provide some insight. Otherwise, I'm going to have to build my own data structure and import data into that.
I kept looking for those properties in the 2010, but just couldn't seem to find them. Appreciated that input.
The data structure in this table I'm dealing with is extremely frustrating, I think I preferred not being able to access the table to having to figure out how to pull the information I need. There are a couple of other tables I need to dig into to see if they provide some insight. Otherwise, I'm going to have to build my own data structure and import data into that.
...oh,
I might have used Access 2013, but those same setting exist do in 2010.
I might have used Access 2013, but those same setting exist do in 2010.
ASKER
Discovered that I was trying to import the table, not link to it.
Proves that I don't look at member names...
;-)
Sorry I could not help more, but glad you got it resolved...
;-)
Jeff