DSN-less connection

[Lynn]

Hi
I know that DSN-less connections can improve the speed of applications. I've tried using this but I always get error like this:

DataSource Name not found and no default driver specified.

Anyone knows what went wrong?

[Lothar Haensler]

post your connection string, please.
Does it look similar to the one below?
"Driver={SQL Server};Server=yourserver;UID=;PWD=;database=yourdatabase"?

[Lynn]

Hi, my connection string is as follows:
("", rdDriverNoPrompt, False,server=orc0;Driver=MSDASQL;uid=system;pwd=manager")

Hi, i have arround the same problem wuth my connection TO Access, the following lines doesn't go
// m_strConnection = _T("Provider=MSQASQL.1;Data Source=access");
m_strConnection = _T("Provider=Microsoft.Jet.OLEDB.3.51.1;Data Source=access");
m_strCmdText = _T("select * from newbd");
m_pRs->Open((LPCTSTR)m_strCmdText, (LPCTSTR)m_strConnection, adOpenStatic,
adLockReadOnly, adCmdTableDirect);