🚀 go-pugleaf

When I use a ADOConnection component then I can connect perfectly but when I use your method then the I get an error that I can't connect to the server, access denied or server doesn't exist. I'm using the exact same provider and connectionstring than with the component, but the component works and your example doesn't ....

Any ideas ?


"Sergey Muschin" <sergey.muschin@tonservices.com> wrote:
>Hi Tom Van den Bon,
>
>  m_pADOConn = new TADOConnection(this);
>  m_pADOConn->Provider = "SQLOLEDB.1";
>  m_pADOConn->ConnectionString ="Provider=SQLOLEDB.1;Persist Security
>Info=False;Initial Catalog=snm;Data Source=dev-fileserver";
>  m_pADOConn->Mode = cmReadWrite;
>  m_pADOConn->IsolationLevel = ilCursorStability;
>  m_pADOConn->CursorLocation = clUseClient;
>  //and so on, if You need to set up something else
>  m_pADOConn->Open("UID","PWD");  //open it
>  //do something
>  m_pADOConn->Close(); //close it
>  delete m_pADOConn;//free memory
>
>PS: this is just an example. In a real world You would need to take care at
>least about Exceptions...
>
>Regards,
>Sergey Muschin